Excel Mastery QuizOnline version Test your knowledge of Excel features and functions with this fun quiz! by Lesly Tecum 1 What function would you use to sum a range of cells in Excel? a b COUNT c MAX d SUM 2 Which feature allows you to analyze data visually in Excel? a Macros b Tables c Charts d Comments 3 What does the VLOOKUP function do? a Formats cells b Looks up a value in a table c Sorts data d Counts values 4 Which shortcut opens the 'Format Cells' dialog in Excel? a Ctrl + V b Ctrl + F c Ctrl + 1 d Ctrl + C 5 What is the maximum number of rows in an Excel worksheet? a 65,536 b 1,048,576 c 500,000 d 2,000,000 6 What does the CONCATENATE function do? a Finds duplicates b Joins text strings together c Splits text strings d Calculates averages 7 Which Excel feature helps to automatically fill cells with data? a Sorting b Conditional Formatting c AutoFill d Data Validation 8 What is the purpose of Pivot Tables in Excel? a Entering formulas b Formatting cells c Creating charts d Summarizing data 9 Which function would you use to find the average of a range? a SUM b COUNT c AVERAGE d MEDIAN 10 What is the shortcut to save a workbook in Excel? a Ctrl + O b Ctrl + S c Ctrl + N d Ctrl + P