20+ Microsoft Excel MCQs with Answers
Test your Microsoft Excel knowledge with over 20 multiple-choice questions and answers. Improve your Excel skills and prepare for exams with these MCQs.
1. What is the keyboard shortcut to paste only values in Excel?
- Ctrl + C
- Ctrl + V
- Ctrl + Alt + V
- Ctrl + Shift + V
Answer: d)
2. Which of the following is not a valid chart type in Excel?
- Pie chart
- Bar chart
- Line chart
- Round chart
Answer: d)
3. Which function can be used to count the number of cells in a range that contain a specific value?
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNT
Answer: c)
4. Which keyboard shortcut is used to save an Excel worksheet?
- Ctrl + S
- Ctrl + Shift + S
- Ctrl + Alt + S
- Ctrl + A
Answer: a)
5. Which of the following is not a valid reference type in Excel?
- Absolute reference
- Relative reference
- Fixed reference
- Mixed reference
Answer: c)
6. What is the maximum number of columns in Excel 2019?
- 255
- 512
- 1024
- 2048
Answer: d)
7. Which of the following is not a valid method for inserting a new worksheet in Excel?
- Right-click on a worksheet tab and select "Insert"
- Click on "Insert" in the Ribbon and select "Worksheet"
- Press Ctrl + N
- Press Ctrl + Shift + N
Answer: d)
8. What is the function of the VLOOKUP function in Excel?
- To search for a value in the leftmost column of a table and return a value in the same row from a specified column to the right
- To count the number of cells in a range that meet a certain criteria
- To calculate the average of a range of cells
- To concatenate two or more strings
Answer: a)
9. Which of the following is not a valid function category in Excel?
- Math and trigonometry
- Text
- Date and time
- File and folder
Answer: d)
10. Which keyboard shortcut is used to autofill a series of values or data in Excel?
- Ctrl + D
- Ctrl + R
- Ctrl + E
- Ctrl + Drag
Answer: d)
11. Which of the following is not a valid method for inserting a comment in Excel?
- Right-click on a cell and select "Insert Comment"
- Click on "Review" in the Ribbon and select "New Comment"
- Press Shift + F2
- Press Ctrl + Alt + C
Answer: d)
12. Which function is used to find the largest value in a range in Excel?
- MAX
- MIN
- SUM
- AVERAGE
Answer: a)
13. Which of the following is not a valid method for creating a chart in Excel?
- Select the data and press F11
- Click on "Insert" in the Ribbon and select "Chart"
- Right-click on the data and select "Create Chart"
- Click on "Format" in the Ribbon and select "Chart Style"
Answer: d)
14. Which of the following is not a valid data type in Excel?
- Text
- Number
- Date/Time
- Boolean
- Image
Answer: e)
15. Which of the following is not a valid method for changing the font size in Excel?
- Click on the "Home" tab in the Ribbon and select a font size from the "Font Size" dropdown
- Right-click on the cell and select "Font" from the context menu, then select a font size
- Type the font size in the formula bar and press Enter
- Press Ctrl + Shift + > to increase the font size or Ctrl + Shift + < to decrease the font size
Answer: c)
16. Which of the following is not a valid way to sort data in Excel?
- Click on the "Data" tab in the Ribbon and select "Sort"
- Right-click on the cell and select "Sort"
- Press Ctrl + Shift + S
- Click on the column header and select "Sort A to Z" or "Sort Z to A"
Answer: c)
17. Which of the following is not a valid method for protecting cells in Excel?
- Click on the "Review" tab in the Ribbon and select "Protect Sheet"
- Right-click on the cell and select "Format Cells", then select the "Protection" tab
- Click on the "File" tab in the Ribbon and select "Protect Workbook"
- Press Ctrl + 1, select the "Protection" tab, and check the "Locked" or "Hidden" boxes
Answer: c)
18. Which of the following is not a valid method for creating a pivot table in Excel?
- Click on the "Insert" tab in the Ribbon and select "Pivot Table"
- Press Alt + N, then press V and T
- Right-click on the data and select "Create Pivot Table"
- Click on the "Data" tab in the Ribbon and select "Pivot Table"
Answer: d)
19. Which of the following is not a valid way to format a cell in Excel?
- Click on the "Home" tab in the Ribbon and select a format from the "Number" dropdown
- Right-click on the cell and select "Format Cells", then select a format
- Type the format in the formula bar and press Enter
- Press Ctrl + Shift + $ to format the cell as currency
Answer: c)
20. Which of the following is not a valid way to add a comment to a cell in Excel?
- Right-click on the cell and select "Insert Comment"
- Click on the "Review" tab in the Ribbon and select "New Comment"
- Type the comment directly in the cell and press Enter
- Press Shift + F2
Answer: c)
21. Which of the following is not a valid way to insert a hyperlink in Excel?
- Click on the "Insert" tab in the Ribbon and select "Hyperlink"
- Right-click on the cell and select "Hyperlink"
- Type the URL directly in the cell and press Enter
- Press Ctrl + K
Answer: c)
22. Which of the following is not a valid function in Excel?
- SUM
- AVERAGE
- MINIMUM
- RANDOMIZE
Answer: d)
23. Which of the following is not a valid way to insert a chart in Excel?
- Click on the "Insert" tab in the Ribbon and select a chart type
- Right-click on the data and select "Insert Chart"
- Click on the "Chart" button in the "Charts" group on the "Home" tab in the Ribbon
- Press Alt + F1
Answer: b)
