25 Multiple Choice Questions on Microsoft Excel

Basic Questions

1. What is the default file extension of an Excel workbook?
   a) .docx
   b) .xlsx
   c) .pptx
   d) .xlsm
   • Answer: b) .xlsx

2. Which shortcut key is used to save a workbook in Excel?
   a) Ctrl + S
   b) Ctrl + P
   c) Ctrl + X
   d) Ctrl + V
   • Answer: a) Ctrl + S

3. What is the intersection of a row and a column called?
   a) Box
   b) Cell
   c) Table
   d) Grid
   • Answer: b) Cell

4. Which symbol is used to start a formula in Excel?
   a) #
   b) @
   c) =
   d) &
   • Answer: c) =

5. What does the SUM function do in Excel?
   a) Counts the number of cells
   b) Finds the highest value
   c) Adds a range of numbers
   d) Finds the lowest value
   • Answer: c) Adds a range of numbers

---

Formulas and Functions

6. Which of the following is NOT a function in Excel?
   a) AVERAGE
   b) COUNT
   c) SUM
   d) COMBINE
   • Answer: d) COMBINE

7. Which function is used to find the largest number in a range?
   a) MAX
   b) MIN
   c) AVERAGE
   d) LARGE
   • Answer: a) MAX

8. Which function is used to count the number of numeric values in a range?
   a) COUNTA
   b) COUNT
   c) SUM
   d) COUNTIF
   • Answer: b) COUNT

9. What does the IF function do?
   a) Formats text
   b) Adds numbers
   c) Performs a logical test
   d) Converts numbers into text
   • Answer: c) Performs a logical test

10. What will =ROUND(25.678,2) return?
    a) 25.6
    b) 25.68
    c) 25.67
    d) 25.7

• Answer: b) 25.68

---

Formatting and Editing

11. Which shortcut key is used to bold text in Excel?
    a) Ctrl + B
    b) Ctrl + U
    c) Ctrl + I
    d) Ctrl + Shift + B

• Answer: a) Ctrl + B

12. What feature allows you to apply a format to multiple cells based on a condition?
    a) Data Validation
    b) Conditional Formatting
    c) AutoFill
    d) Data Filter

• Answer: b) Conditional Formatting

13. Which tab in the ribbon contains the Merge & Center button?
    a) Home
    b) Insert
    c) View
    d) Data

• Answer: a) Home

14. How can you remove all formatting from a cell?
    a) Press Delete
    b) Use Clear Formats
    c) Use Find and Replace
    d) Use AutoFill

• Answer: b) Use Clear Formats

15. Which option is used to change the background color of a cell?
    a) Font Color
    b) Fill Color
    c) Conditional Formatting
    d) Borders

• Answer: b) Fill Color

---

Data Management and Analysis

16. Which feature allows you to quickly fill a series of cells with data or a pattern?
    a) AutoFormat
    b) AutoFill
    c) Data Validation
    d) Sorting

• Answer: b) AutoFill

17. What does the Filter feature do?
    a) Sorts data
    b) Highlights duplicates
    c) Hides non-matching rows
    d) Merges cells

• Answer: c) Hides non-matching rows

18. Which tool is used to summarize and analyze data in Excel?
    a) Pivot Table
    b) AutoSum
    c) VLOOKUP
    d) COUNTIF

• Answer: a) Pivot Table

19. Which function is used to search for a value in a column and return a value from another column?
    a) VLOOKUP
    b) HLOOKUP
    c) INDEX
    d) MATCH

• Answer: a) VLOOKUP

20. Which function helps in finding the position of a value within a range?
    a) FIND
    b) SEARCH
    c) MATCH
    d) INDEX

• Answer: c) MATCH

---

Shortcuts and Special Features

21. Which shortcut is used to insert a new worksheet in Excel?
    a) Ctrl + N
    b) Shift + F11
    c) Alt + Shift + N
    d) Ctrl + Shift + N

• Answer: b) Shift + F11

22. Which key is used to edit a selected cell?
    a) F2
    b) F4
    c) Enter
    d) Esc

• Answer: a) F2

23. What happens when you press Ctrl + Z in Excel?
    a) Redo the last action
    b) Undo the last action
    c) Save the file
    d) Copy the text

• Answer: b) Undo the last action

24. Which key combination is used to apply or remove filters?
    a) Ctrl + Shift + L
    b) Ctrl + L
    c) Alt + F4
    d) Ctrl + Alt + L

• Answer: a) Ctrl + Shift + L

25. Which of the following is NOT a valid Excel data type?
    a) Text
    b) Number
    c) Formula
    d) Paragraph

• Answer: d) Paragraph