by Cull Frantz
Excel is a cornerstone of data management and analysis, used by professionals and students alike to organize, calculate, and visualize information. This quiz will challenge your understanding of Excel’s features, functions, and capabilities. Good luck, and may your cells always align perfectly!
We recommend that you do not leave the page that you are taking this quiz in. Stay honest 🙂
Excel Quiz Questions Overview
1. What is the default file extension for an Excel workbook?
.xls
.xlsx
.xlsm
.csv
2. Which function would you use to find the average of a range of cells?
SUM
AVERAGE
MEDIAN
MODE
3. How can you quickly sum a column of numbers in Excel?
Use the SUM function
Press Ctrl + S
Press Alt + =
Use the AVERAGE function
4. What does the VLOOKUP function do?
Sorts data
Looks up a value in a vertical table
Calculates the sum of a range
Finds the maximum value
5. Which of the following is NOT a valid Excel data type?
Text
Number
Boolean
Image
6. What is the purpose of the CONCATENATE function?
To add numbers
To combine text from multiple cells
To find the largest value
To create a pivot table
7. Which keyboard shortcut is used to create a new workbook in Excel?
Ctrl + N
Ctrl + O
Ctrl + S
Ctrl + P
8. How do you freeze the top row of a worksheet?
Go to View > Freeze Panes > Freeze Top Row
Go to Home > Format > Freeze Top Row
Go to Insert > Freeze > Top Row
Go to Data > Freeze > Top Row
9. What does the IF function do?
Calculates the sum of a range
Checks if a condition is met and returns one value if true and another if false
Finds the average of a range
Sorts data in ascending order
10. Which function would you use to count the number of cells that contain numbers?
COUNT
COUNTA
COUNTIF
COUNTBLANK
11. What is the shortcut for opening the Format Cells dialog box?
Ctrl + 1
Ctrl + F
Ctrl + Shift + F
Ctrl + Alt + 1
12. Which function would you use to remove spaces from text in Excel?
CLEAN
TRIM
SUBSTITUTE
TEXT
13. What is the purpose of a pivot table?
To create charts
To summarize, analyze, explore, and present data
To format cells
To sort data
14. Which function would you use to find the largest number in a range?
MAX
LARGE
SUM
AVERAGE
15. How do you create a chart from selected data in Excel?
Press F11
Press Alt + F1
Press Ctrl + C
Press Ctrl + P
16. Which function would you use to join two or more text strings together?
JOIN
MERGE
TEXTJOIN
CONCAT
17. How do you apply a filter to a range of data?
Go to Data > Sort
Go to Data > Filter
Go to Home > Filter
Go to Insert > Filter
18. Which function would you use to calculate the number of days between two dates?
DATEDIF
DATE
DAYS
NETWORKDAYS
19. What is the shortcut for saving a workbook?
Ctrl + S
Ctrl + A
Ctrl + Z
Ctrl + X
20. Which function would you use to find the smallest number in a range?
MIN
SMALL
SUM
AVERAGE
21. How do you insert a new worksheet into an Excel workbook?
Go to Insert > Worksheet
Right-click on a sheet tab and select Insert
Press Shift + F11
Go to Home > Insert > Worksheet
We recommend that you do not leave the page that you are taking this quiz in. Stay honest 🙂
