MS Excel - Top Tips & Tricks Question Title * 1. What is your name? (First, Last) Question Title * 2. What is your location? Winnipeg, MB Regina, SK Saskatoon, SK Itasca, IL Tukwila, WA Vaughan, ON Other Question Title * 3. What is your role/job title/department? Question Title * 4. What is the correct Hlookup formula? Select the correct answer =xlookup (Lookup_value, lookup_array, return array, [if not found], [match_mode], [search mode]) xlookup (Lookup_value, lookup_array, return array, [if not found], [match_mode], [search mode]) xlookup (Lookup_value, lookup, return, [if not found], [match_mode], [search mode]) None of the above Question Title * 5. True or false; Does Excel offer an autosum feature? True False Question Title * 6. What are some functions you can use in Excel? Select all that apply: SUM VLOOKUP TRUE/FALSE AVERAGE All the above Question Title * 7. When would you use a SUMIFS Function? To find the sum of the entire data To find the sum of the data if it meets a certain condition or criteria To find the subtotal None of the above Question Title * 8. When would you use the CONCATENATE function? Combine data from more than one cell into a single cell Separate data from specific cell into other cells To find the total amount of data None of the above Question Title * 9. Which tab on the Excel Toolbar do you find the Freeze Pane function? Select the correct answer: Home Insert Data View Question Title * 10. True or False? Can you define a cell? True False Question Title * 11. Which formula is correct for Xlookup? Please select the correct answer: =vlookup (Lookup_value, lookup,array, [if not found], [match_mode], [search mode]) =vlookup (Lookup_value, lookup_array, return array, [if not found], [match_mode], [search mode]) =xlookup (Lookup_value, lookup,array, [if not found], [match_mode], [search mode]) =xlookup (Lookup_value, lookup_array, return array, [if not found], [match_mode], [search mode]) =xlookup (Lookup_value, lookup_array, return array, [if not found], [match_mode], [search mode]) Question Title * 12. True or False? If you highlight all data and double click it will automatically adjust the column & row size True False Question Title * 13. How would you rate the relevance of this material to your day-to-day job? Extremely valuable Somewhat valuable Not valuable at all Question Title * 14. Did you learn anything about the position/topic that you didn’t know prior to this? Question Title * 15. How would you rate the relevance of this material to your day-to-day job? A great deal A moderate amount None at all Question Title * 16. If you gained new knowledge, be specific! Question Title * 17. What kind of content would you like to see in the future to help improve your day-to-day work life? Check all that apply: Current updates in the industry Step-by-step guides to using specific software/programs Shortcuts in the programs I currently use Other Question Title * 18. If you selected other material that you would like to see in the future, please be specific: Question Title * 19. Was there anything unclear in the material that you would like your manager or the Frontier-U team to expand on? Done