30 Excel Quiz Questions and Answers

Microsoft Excel is a widely used spreadsheet application developed by Microsoft. It is a powerful tool that allows users to create, manipulate, and analyze data in a tabular format. Excel is used in various industries, including finance, accounting, marketing, data analysis, and many others, due to its versatility and user-friendly interface.

Excel is an essential tool for professionals who work with data, financial analysts, project managers, researchers, and students. It provides a wide range of functionalities to handle data effectively, create reports, and make data-driven decisions. Excel’s popularity is attributed to its accessibility, extensive features, and integration with other Microsoft Office applications, making it a go-to tool for data analysis and presentation.

Pro Tip

Want to assess your learners online? Create an online quiz for free!

Article overview

Part 1: 30 Microsoft Excel quiz questions & answers

1. What is Microsoft Excel primarily used for?
a) Creating presentations
b) Writing documents
c) Creating and analyzing spreadsheets
d) Editing images
Answer: c) Creating and analyzing spreadsheets

2. In Excel, what is a collection of cells called?
a) Rows
b) Columns
c) Worksheets
d) Range
Answer: d) Range

3. What is a cell reference in Excel?
a) The text label of a cell
b) The row and column location of a cell
c) The data entered in a cell
d) The color of a cell
Answer: b) The row and column location of a cell

4. Which Excel feature allows users to summarize and analyze data using various functions?
a) Charts and graphs
b) Formulas
c) Data validation
d) Conditional formatting
Answer: b) Formulas

5. Which Excel function is used to add up a range of numbers?
a) AVERAGE
b) COUNT
c) SUM
d) MAX
Answer: c) SUM

6. What is the keyboard shortcut to save an Excel workbook?
a) Ctrl + S
b) Ctrl + C
c) Ctrl + V
d) Ctrl + P
Answer: a) Ctrl + S

7. Which chart type is used to compare values across different categories in Excel?
a) Bar chart
b) Pie chart
c) Line chart
d) Scatter plot
Answer: a) Bar chart

8. How can you freeze panes in Excel?
a) Click on the “Freeze Panes” button in the View tab
b) Press Alt + F4
c) Use the Freeze Panes option in the Format menu
d) Right-click on the cell you want to freeze and select “Freeze Panes”
Answer: d) Right-click on the cell you want to freeze and select “Freeze Panes”

9. What does the AutoSum button in Excel do?
a) It adds a new worksheet to the workbook
b) It automatically inserts the SUM formula for the selected range
c) It saves the current workbook
d) It creates a new workbook
Answer: b) It automatically inserts the SUM formula for the selected range

10. What is the function of the VLOOKUP function in Excel?
a) It searches for a value in the first column of a table array and returns a value in the same row from a specified column.
b) It performs a vertical alignment of the selected cells.
c) It verifies the data entered in a cell against a predefined set of rules.
d) It calculates the average of a range of numbers.
Answer: a) It searches for a value in the first column of a table array and returns a value in the same row from a specified column.

11. What does the COUNT function in Excel do?
a) It calculates the total count of numbers in a range.
b) It counts the number of cells that contain text.
c) It counts the number of cells that are not empty.
d) It calculates the average of a range of numbers.
Answer: c) It counts the number of cells that are not empty.

12. How can you apply a currency format to a cell in Excel?
a) Select the cell and click on the Currency button in the Home tab.
b) Right-click the cell, choose Format Cells, and select Currency from the list.
c) Press Ctrl + Shift + C.
d) Press Ctrl + B.
Answer: b) Right-click the cell, choose Format Cells, and select Currency from the list.

13. What does the COUNTIF function in Excel do?
a) It calculates the total count of numbers in a range.
b) It counts the number of cells that contain text.
c) It counts the number of cells that meet a specific condition.
d) It calculates the average of a range of numbers.
Answer: c) It counts the number of cells that meet a specific condition.

14. How can you insert a new row in Excel?
a) Click on the Insert button in the Home tab and select Row from the drop-down menu.
b) Press Ctrl + R.
c) Right-click on the row header and choose Insert from the context menu.
d) Press Alt + Shift + R.
Answer: c) Right-click on the row header and choose Insert from the context menu.

15. How can you delete a column in Excel?
a) Click on the Delete button in the Home tab and select Column from the drop-down menu.
b) Press Ctrl + C.
c) Right-click on the column header and choose Delete from the context menu.
d) Press Ctrl + Shift + C.
Answer: c) Right-click on the column header and choose Delete from the context menu.

Part 2: Download Microsoft Excel questions & answers for free

Download questions & answers for free

16. What is the purpose of using conditional formatting in Excel?
a) To create charts and graphs.
b) To automatically sum up values in a range.
c) To apply different formatting based on specific conditions.
d) To convert text to numbers.
Answer: c) To apply different formatting based on specific conditions.

17. How can you merge two or more cells in Excel?
a) Click on the Merge Cells button in the Home tab.
b) Press Ctrl + M.
c) Right-click on the selected cells and choose Merge Cells from the context menu.
d) Press Ctrl + Shift + M.
Answer: c) Right-click on the selected cells and choose Merge Cells from the context menu.

18. What is the purpose of using a pivot table in Excel?
a) To create charts and graphs.
b) To perform data analysis and summarize large datasets.
c) To format the appearance of the workbook.
d) To calculate percentages.
Answer: b) To perform data analysis and summarize large datasets.

19. How can you copy the contents of a cell to another cell in Excel?
a) Press Ctrl + X.
b) Press Ctrl + C and then Ctrl + V.
c) Press Ctrl + D.
d) Press Ctrl + P.
Answer: b) Press Ctrl + C and then Ctrl + V.

20. What is the purpose of using the IF function in Excel?
a) To insert new rows in a worksheet.
b) To automatically sum up values in a range.
c) To perform logical tests and return different values based on the results.
d) To merge cells.
Answer: c) To perform logical tests and return different values based on the results.

21. What is the maximum number of rows in a worksheet in Excel?
a) 10,000 rows
b) 65,536 rows
c) 1,048,576 rows
d) 100,000 rows
Answer: c) 1,048,576 rows

22. Which ribbon tab in Excel contains commands for formatting and styling data?
a) Home
b) Insert
c) Page Layout

d) Data
Answer: a) Home

23. How can you change the width of a column in Excel?
a) Drag the column boundary to the desired width.
b) Right-click the column header, choose Format Cells, and specify the width.
c) Press Ctrl + W.
d) Press Ctrl + Shift + W.
Answer: a) Drag the column boundary to the desired width.

24. What is the purpose of using the MAX function in Excel?
a) To find the average of a range of numbers.
b) To find the highest value in a range of numbers.
c) To calculate the total count of numbers in a range.
d) To find the lowest value in a range of numbers.
Answer: b) To find the highest value in a range of numbers.

25. How can you change the font size of the text in a cell in Excel?
a) Click on the Font Size drop-down menu in the Home tab and select the desired size.
b) Press Ctrl + F.
c) Right-click the cell and choose Font Size from the context menu.
d) Press Ctrl + Shift + F.
Answer: a) Click on the Font Size drop-down menu in the Home tab and select the desired size.

26. What is the purpose of using the COUNTA function in Excel?
a) To calculate the average of a range of numbers.
b) To find the highest value in a range of numbers.
c) To count the number of cells that are not empty.
d) To count the number of cells that meet a specific condition.
Answer: c) To count the number of cells that are not empty.

Just so you know

With OnlineExamMaker quiz software, anyone can create & share professional online assessments easily.

27. How can you remove a filter in Excel?
a) Click on the Filter button in the Data tab.
b) Press Ctrl + R.
c) Right-click on any filtered column and choose Clear Filter from the context menu.
d) Press Alt + Shift + R.
Answer: c) Right-click on any filtered column and choose Clear Filter from the context menu.

28. Which Excel feature allows you to show the result of a formula instead of the actual formula in a cell?
a) Formulas view
b) Formula bar
c) Function Arguments dialog box
d) Show Formulas option
Answer: d) Show Formulas option

29. How can you create a line break within a cell in Excel?
a) Press Ctrl + Enter.
b) Press Ctrl + B.
c) Right-click the cell and choose Line Break from the context menu.
d) Press Ctrl + Shift + B.
Answer: a) Press Ctrl + Enter.

30. Which Excel function is used to round a number to the nearest integer or to a specified number of decimal places?
a) ROUND
b) SUM
c) COUNT
d) MAX
Answer: a) ROUND

Part 3: Best online quiz making platform – OnlineExamMaker

Save time and effort with automated grading, instantly generating scores and results for each respondent. OnlineExamMaker grades your quizzes automatically, and provides valuable insights for performance evaluation. Whether you are an educator looking to engage students or a business professional seeking effective training methods, OnlineExamMaker quiz maker is a reliable and efficient solution that streamlines the assessment process for improved learning outcomes.

Create Your Next Quiz/Exam with OnlineExamMaker

SAAS, free forever
100% data ownership