Microsoft Excel: 50 MCQ Quiz
Basic Computer Skills MCQs with Answers

Microsoft Excel MCQ Quiz (50 Questions)

Test your spreadsheet skills! This 50-question quiz covers everything from basic cell manipulation and formulas to advanced data analysis tools like PivotTables and What-if Analysis.

Lessons 1-4: Interface, OneDrive & Workbooks

1. In Excel, what is the intersection of a row and a column called?
Correct Answer: B Explanation: A cell is the basic unit of a worksheet where you enter data. It is identified by a column letter and row number (e.g., A1).
2. Which feature allows you to save your Excel file to the cloud for easy collaboration?
Correct Answer: C Explanation: OneDrive is Microsoft’s cloud service that lets you store and share workbooks online.

Lessons 5-8: Cell Basics, Rows, Columns & Formatting

3. What happens if you double-click the boundary between two column headers?
Correct Answer: B Explanation: Double-clicking the right boundary of a column header automatically adjusts the width to fit the longest text in that column.
4. Which number format should you use to display a value like "0.75" as "75%"?
Correct Answer: C Explanation: The Percentage format multiplies the cell value by 100 and displays it with a percent symbol.

Lessons 9-12: Multiple Sheets, Search & Printing

5. How can you select multiple worksheets at once to edit them simultaneously?
Correct Answer: B Explanation: Holding Ctrl (or Shift for a range) allows you to "group" worksheets.

Lessons 13-16: Formulas & Cell References

6. Every formula in Excel must begin with which symbol?
Correct Answer: C Explanation: The equal sign tells Excel that the succeeding characters constitute a formula.
7. In the formula =A1+A2, what kind of cell reference is being used?
Correct Answer: B Explanation: Relative references change when a formula is copied to another cell.
8. Which symbol is used to create an Absolute Reference (e.g., to keep a cell fixed when copying)?
Correct Answer: B Explanation: Putting a dollar sign before the column and row (e.g., $A$1) locks the reference.
9. Which function would you use to find the highest value in a range?
Correct Answer: C Explanation: The MAX function returns the largest value in a set of values.

Lessons 17-21: Data Sorting, Filtering & View Options

10. Which feature keeps the top row visible while you scroll down through a long list?
Correct Answer: B Explanation: "Freeze Top Row" is a common use of the Freeze Panes feature.
11. What is the difference between Sorting and Filtering?
Correct Answer: B Explanation: Sorting changes the sequence (A-Z), while Filtering limits what is currently visible on the screen.

Lessons 22-26: Tables, Charts & Protection

12. Which tool allows you to automatically format cells based on their value (e.g., highlighting values over 100 in red)?
Correct Answer: C Explanation: Conditional Formatting applies formatting only when specific rules are met.

Lessons 27-29: PivotTables & What-if Analysis

13. What is the primary purpose of a PivotTable?
Correct Answer: B Explanation: PivotTables are one of Excel's most powerful data summarization tools.
14. Which "What-if Analysis" tool would you use to find the input value needed to reach a specific result (e.g., "What interest rate do I need to make my payment $500?")?
Correct Answer: B Explanation: Goal Seek works backward from a result to find the necessary input.

Lessons 30-34: Office 365, Draw & Icons

15. Which reference style uses numbers for both rows and columns (e.g., R1C1 instead of A1)?
Correct Answer: C Explanation: This style can be enabled in Excel Options and is often used in macro programming.
16. What is the keyboard shortcut to open the "Find and Replace" dialog?
Correct Answer: B Explanation: Ctrl + F opens the Find tab; Ctrl + H opens the Replace tab.
17. Which function calculates the average of a range of cells?
Correct Answer: D Explanation: While =AVERAGE() is the built-in function, dividing the sum by the count also calculates the average.
18. What does the "Fill Handle" (small green square in cell corner) do?
Correct Answer: B Explanation: Dragging the fill handle is a quick way to copy formulas or create sequences.
19. Which tab contains the "Charts" group?
Correct Answer: C Explanation: You insert new elements like Charts, Tables, and Pictures from the Insert tab.
20. What is the file extension for a standard Excel 2016/2019/365 workbook?
Correct Answer: B Explanation: .xlsx is the XML-based format for modern Excel workbooks.
21. To select the entire worksheet, which shortcut do you use?
Correct Answer: B Explanation: Ctrl + A selects all cells in the current worksheet.
22. What does #VALUE! indicate in Excel?
Correct Answer: C Explanation: This error occurs when a formula expects a number but finds text or an incompatible data type.
23. Which feature allows you to combine two or more cells into one larger cell?
Correct Answer: B Explanation: Merge & Center is commonly used for worksheet titles.
24. Which function counts cells that contain numbers only?
Correct Answer: C Explanation: =COUNT() only looks for numeric values. =COUNTA() counts all non-empty cells.
25. How do you start a "New Line" within the same cell?
Correct Answer: C Explanation: Alt + Enter inserts a line break inside a cell.
26. In the formula =B2*C2, what does the * symbol represent?
Correct Answer: C Explanation: Excel uses the asterisk for multiplication and the forward slash (/) for division.
27. Which function allows you to test a condition and return one value if TRUE and another if FALSE?
Correct Answer: B Explanation: The IF function is one of the most popular functions in Excel.
28. What does "#####" in a cell mean?
Correct Answer: C Explanation: Widening the column will reveal the full number.
29. Which chart type is best for showing parts of a whole?
Correct Answer: C Explanation: Pie charts visualize percentages or proportions effectively.
30. What is a "Slicer" in Excel?
Correct Answer: B Explanation: Slicers provide buttons that you can click to filter data.
31. Which tab is used to protect a workbook with a password?
Correct Answer: B Explanation: The Review tab contains Protect Sheet and Protect Workbook options.
32. How many rows are there in an Excel 365 worksheet?
Correct Answer: B Explanation: Modern Excel supports over 1 million rows and 16,384 columns.
33. Which feature allows you to see what your data would look like as a chart before you actually create it?
Correct Answer: B Explanation: The Quick Analysis button appears in the bottom right of a selected range.
34. Flash Fill is used to:
Correct Answer: B Explanation: Flash Fill is excellent for splitting first and last names or combining data.
35. Which shortcut is used to "Undo" an action?
Correct Answer: B Explanation: Ctrl + Z is the universal undo command.
36. What is the shortcut to save a workbook?
Correct Answer: D Explanation: Ctrl + S saves the current file; F12 opens the "Save As" dialog.
37. Which function would you use to find a value in a table by looking up a specific key (like a product ID)?
Correct Answer: B Explanation: VLOOKUP stands for "Vertical Lookup."
38. What does "Wrap Text" do?
Correct Answer: B Explanation: This prevents long text from overlapping adjacent empty cells.
39. Which operator is used for Exponentiation (power of) in Excel?
Correct Answer: B Explanation: For example, =2^3 results in 8.
40. To add a background color to a cell, you use:
Correct Answer: B Explanation: The Fill Color icon looks like a paint bucket.
41. What is the shortcut for "AutoSum"?
Correct Answer: B Explanation: Alt + = automatically inserts the SUM function for the adjacent range.
42. How do you delete a worksheet?
Correct Answer: C Explanation: Deleting a sheet is permanent and cannot be undone via Ctrl+Z.
43. Which tool in the "Draw" tab allows you to convert handwritten math into digital numbers?
Correct Answer: C Explanation: Ink to Math opens a tool that recognizes hand-drawn equations.
44. What is a "Cell Range"?
Correct Answer: B Explanation: A range is usually written as A1:B10.
45. Which tab contains the "Sort & Filter" command?
Correct Answer: D Explanation: It is available on the Home tab for quick access and the Data tab for advanced options.
46. What is the shortcut to open the "Print" menu?
Correct Answer: A Explanation: Ctrl + P takes you to the Print pane in Backstage View.
47. Which mathematical operation is performed first in a complex formula (Order of Operations)?
Correct Answer: C Explanation: Excel follows the standard PEMDAS rule.
48. To select a non-adjacent range of cells (e.g., A1 and C1), you should hold which key while clicking?
Correct Answer: C Explanation: Ctrl allows for individual selection; Shift allows for range selection.
49. What is the shortcut to create a new, blank workbook?
Correct Answer: B Explanation: Ctrl + N opens a new Excel file.
50. Which Office Intelligent Service can find data types (like Stocks or Geography) for you?
Correct Answer: D Explanation: Modern Excel includes several AI-powered tools on the Data and Review tabs to enhance your work.

You May Also Like

Loading...