Microsoft Excel MCQs with Answers | 100 Multiple Choice Questions

Practice 100 Microsoft Excel MCQs with answers covering formulas, functions, charts, cell references, shortcuts, and data analysis tools. Ideal for students and exam preparation.

Microsoft Excel is one of the most powerful and widely used spreadsheet applications for organizing, calculating, and analyzing data. This carefully designed set of 100 Microsoft Excel MCQs with answers covers essential topics such as Excel basics, formulas and functions, cell references, charts, data sorting and filtering, pivot tables, and shortcut keys. Created for students, beginners, office professionals, and competitive exam aspirants, these multiple choice questions are ideal for exam preparation, skill assessment, and quick revision, helping learners strengthen their practical knowledge and confidence in using Microsoft Excel effectively.

Here are 100 MCQs on Microsoft Excel, written in clear English, suitable for students, beginners, office users, and competitive exams. Each question includes four options and the correct answer.

Microsoft Excel – 100 MCQs with Answers

Basics of Microsoft Excel (1–20)

1. Microsoft Excel is a:
   A. Word processing software
   B. Spreadsheet software
   C. Presentation software
   D. Database software
   Answer: B

2. Microsoft Excel is developed by:
   A. Apple
   B. Google
   C. Microsoft
   D. IBM
   Answer: C

3. The default file extension of Excel 2016 and later is:
   A. .xls
   B. .xlsx
   C. .csv
   D. .docx
   Answer: B

4. Excel is mainly used for:
   A. Drawing
   B. Calculations and data analysis
   C. Typing letters
   D. Designing posters
   Answer: B

5. A spreadsheet is made up of:
   A. Slides
   B. Pages
   C. Rows and columns
   D. Charts
   Answer: C

6. The intersection of a row and column is called a:
   A. Box
   B. Field
   C. Cell
   D. Table
   Answer: C

7. Each cell in Excel has a unique:
   A. Number
   B. Name
   C. Cell address
   D. Value
   Answer: C

8. Which of the following is a valid cell address?
   A. 1A
   B. AA
   C. A1
   D. 11
   Answer: C

9. Rows in Excel are identified by:
   A. Letters
   B. Numbers
   C. Symbols
   D. Colors
   Answer: B

10. Columns in Excel are identified by:
    A. Numbers
    B. Symbols
    C. Letters
    D. Colors
    Answer: C

11. A worksheet is:
    A. A complete Excel file
    B. A single spreadsheet
    C. A chart
    D. A formula
    Answer: B

12. A workbook is:
    A. One worksheet
    B. Collection of worksheets
    C. A chart
    D. A cell
    Answer: B

13. By default, a new workbook contains:
    A. One worksheet
    B. Two worksheets
    C. Three worksheets
    D. Four worksheets
    Answer: A

14. Which key is used to edit a cell?
    A. F1
    B. F2
    C. F5
    D. F10
    Answer: B

15. Which shortcut key creates a new workbook?
    A. Ctrl + S
    B. Ctrl + O
    C. Ctrl + N
    D. Ctrl + P
    Answer: C

16. Which shortcut key saves a workbook?
    A. Ctrl + A
    B. Ctrl + S
    C. Ctrl + C
    D. Ctrl + V
    Answer: B

17. Which symbol is used to start a formula?
    A. +
    B. =
    C. *
    D. %
    Answer: B

18. Which option is used to open an existing file?
    A. Ctrl + N
    B. Ctrl + O
    C. Ctrl + P
    D. Ctrl + F
    Answer: B

19. Excel files are also called:
    A. Documents
    B. Workbooks
    C. Slides
    D. Records
    Answer: B

20. Which key deletes the contents of a selected cell?
    A. Backspace
    B. Delete
    C. Esc
    D. Enter
    Answer: B

Formulas & Functions (21–50)

21. A formula in Excel always begins with:
    A. +
    B. #
    C. =
    D. @
    Answer: C

22. Which function is used to add values?
    A. ADD()
    B. SUM()
    C. TOTAL()
    D. PLUS()
    Answer: B

23. Which function calculates average?
    A. MEAN()
    B. AVG()
    C. AVERAGE()
    D. MID()
    Answer: C

24. Which function counts numeric values?
    A. COUNT()
    B. COUNTA()
    C. COUNTIF()
    D. TOTAL()
    Answer: A

25. COUNTA() is used to count:
    A. Numbers only
    B. Empty cells
    C. Non-empty cells
    D. Formulas only
    Answer: C

26. Which function finds the largest value?
    A. LARGE()
    B. MAX()
    C. BIG()
    D. TOP()
    Answer: B

27. Which function finds the smallest value?
    A. SMALL()
    B. MIN()
    C. LOW()
    D. LESS()
    Answer: B

28. Which function rounds a number?
    A. ROUND()
    B. FIX()
    C. INT()
    D. VALUE()
    Answer: A

29. Which function returns current date?
    A. DATE()
    B. NOW()
    C. TODAY()
    D. TIME()
    Answer: C

30. Which function returns current date and time?
    A. TODAY()
    B. DATE()
    C. NOW()
    D. CLOCK()
    Answer: C

31. Which function is used to combine text?
    A. JOIN()
    B. CONCAT()
    C. MERGE()
    D. TEXTJOIN()
    Answer: B

32. IF function is used for:
    A. Calculations
    B. Logical testing
    C. Formatting
    D. Printing
    Answer: B

33. Which function counts based on condition?
    A. COUNT()
    B. COUNTA()
    C. COUNTIF()
    D. SUM()
    Answer: C

34. SUMIF() is used to:
    A. Count values
    B. Add values with condition
    C. Find average
    D. Sort data
    Answer: B

35. Which symbol is used for absolute reference?
    A. &
    B. #
    C. $
    D. %
    Answer: C

36. $A$1 represents:
    A. Relative reference
    B. Mixed reference
    C. Absolute reference
    D. Cell value
    Answer: C

37. A1 is an example of:
    A. Absolute reference
    B. Relative reference
    C. Mixed reference
    D. Invalid reference
    Answer: B

38. Which error occurs when dividing by zero?
    A. #VALUE!
    B. #REF!
    C. #DIV/0!
    D. #NAME?
    Answer: C

39. Which function returns length of text?
    A. SIZE()
    B. LEN()
    C. COUNT()
    D. TEXT()
    Answer: B

40. Which function converts text to uppercase?
    A. CAPITAL()
    B. UPPER()
    C. BIG()
    D. LARGE()
    Answer: B

Formatting, Charts & Data Tools (41–70)

41. Which tab is used for formatting cells?
    A. Insert
    B. Home
    C. Data
    D. Review
    Answer: B

42. Which option changes cell background color?
    A. Font Color
    B. Fill Color
    C. Cell Border
    D. Text Color
    Answer: B

43. Which alignment places text in the center?
    A. Left
    B. Right
    C. Center
    D. Justify
    Answer: C

44. Which feature automatically fills data?
    A. Flash Fill
    B. Auto Fill
    C. Smart Fill
    D. Quick Fill
    Answer: B

45. Which option merges multiple cells?
    A. Merge & Center
    B. Wrap Text
    C. Align Center
    D. Format Cells
    Answer: A

46. Which chart is best for comparison?
    A. Pie chart
    B. Line chart
    C. Column chart
    D. Area chart
    Answer: C

47. Which chart shows trends over time?
    A. Pie
    B. Line
    C. Bar
    D. Doughnut
    Answer: B

48. Which chart shows percentage distribution?
    A. Column
    B. Bar
    C. Pie
    D. Line
    Answer: C

49. Which tab is used to insert charts?
    A. Home
    B. Insert
    C. Data
    D. Review
    Answer: B

50. Which option sorts data?
    A. Filter
    B. Sort
    C. Group
    D. Format
    Answer: B

51. Which option hides unwanted data?
    A. Sort
    B. Filter
    C. Freeze
    D. Format
    Answer: B

52. Which feature keeps headings visible?
    A. Freeze Panes
    B. Split Cells
    C. Wrap Text
    D. Group
    Answer: A

53. Which tool removes duplicate data?
    A. Sort
    B. Filter
    C. Remove Duplicates
    D. Clean Data
    Answer: C

54. Which tab contains PivotTable?
    A. Home
    B. Insert
    C. Data
    D. Review
    Answer: B

55. PivotTable is used for:
    A. Formatting
    B. Data summarization
    C. Printing
    D. Drawing
    Answer: B

56. Conditional Formatting is used to:
    A. Print data
    B. Highlight cells based on rules
    C. Protect data
    D. Sort data
    Answer: B

57. Which feature adds borders to cells?
    A. Font
    B. Alignment
    C. Borders
    D. Styles
    Answer: C

58. Which option formats numbers?
    A. Home → Number
    B. Insert → Chart
    C. Data → Sort
    D. Review → Proofing
    Answer: A

59. Which format shows currency?
    A. General
    B. Number
    C. Currency
    D. Text
    Answer: C

60. Which feature rotates text?
    A. Orientation
    B. Alignment
    C. Merge
    D. Wrap
    Answer: A

Advanced Features & Shortcuts (71–100)

71. Which shortcut selects all cells?
    A. Ctrl + S
    B. Ctrl + A
    C. Ctrl + C
    D. Ctrl + V
    Answer: B

72. Which shortcut copies data?
    A. Ctrl + X
    B. Ctrl + C
    C. Ctrl + V
    D. Ctrl + Z
    Answer: B

73. Which shortcut pastes data?
    A. Ctrl + C
    B. Ctrl + V
    C. Ctrl + X
    D. Ctrl + P
    Answer: B

74. Which shortcut cuts data?
    A. Ctrl + X
    B. Ctrl + C
    C. Ctrl + V
    D. Ctrl + A
    Answer: A

75. Which shortcut opens Find?
    A. Ctrl + H
    B. Ctrl + G
    C. Ctrl + F
    D. Ctrl + R
    Answer: C

76. Which shortcut opens Replace?
    A. Ctrl + F
    B. Ctrl + H
    C. Ctrl + G
    D. Ctrl + R
    Answer: B

77. Which shortcut inserts a new worksheet?
    A. Shift + F11
    B. Ctrl + N
    C. Alt + F4
    D. Ctrl + T
    Answer: A

78. Which shortcut edits the active cell?
    A. F1
    B. F2
    C. F5
    D. F12
    Answer: B

79. Which function is used to lookup data vertically?
    A. HLOOKUP
    B. LOOKUP
    C. VLOOKUP
    D. FIND
    Answer: C

80. Which function searches horizontally?
    A. VLOOKUP
    B. HLOOKUP
    C. XLOOKUP
    D. MATCH
    Answer: B

81. Which function replaces both VLOOKUP and HLOOKUP?
    A. LOOKUP
    B. FIND
    C. XLOOKUP
    D. SEARCH
    Answer: C

82. Which tab protects worksheets?
    A. Home
    B. Insert
    C. Review
    D. Data
    Answer: C

83. Which feature restricts data entry?
    A. Filter
    B. Data Validation
    C. Conditional Format
    D. Protect Sheet
    Answer: B

84. Which format stores plain text data?
    A. .xlsx
    B. .xls
    C. .csv
    D. .pdf
    Answer: C

85. Which feature automatically saves changes?
    A. AutoSave
    B. Save As
    C. Backup
    D. Export
    Answer: A

86. Which view shows page layout?
    A. Normal
    B. Page Break Preview
    C. Page Layout
    D. Custom View
    Answer: C

87. Which feature inserts comments?
    A. Notes
    B. Comments
    C. Review
    D. Track Changes
    Answer: B

88. Which function removes extra spaces?
    A. CLEAN()
    B. TRIM()
    C. SPACE()
    D. LEN()
    Answer: B

89. Which function converts text to lowercase?
    A. LOWER()
    B. SMALL()
    C. MIN()
    D. TEXT()
    Answer: A

90. Which function joins text with delimiter?
    A. CONCAT()
    B. JOIN()
    C. TEXTJOIN()
    D. MERGE()
    Answer: C

91. Which option inserts a table?
    A. Home
    B. Insert
    C. Data
    D. Review
    Answer: B

92. Which option converts range to table?
    A. Insert Table
    B. Format as Table
    C. Create Table
    D. Make Table
    Answer: B

93. Which feature tracks changes in Excel?
    A. Track Changes
    B. Share Workbook
    C. Comments
    D. Protect Sheet
    Answer: B

94. Which tool analyzes data quickly?
    A. Solver
    B. What-If Analysis
    C. Scenario Manager
    D. All of these
    Answer: D

95. Which option inserts sparklines?
    A. Insert → Charts
    B. Insert → Sparklines
    C. Data → Charts
    D. Review → Graph
    Answer: B

96. Which function checks logical condition?
    A. IF()
    B. AND()
    C. OR()
    D. All of these
    Answer: D

97. Which key exits Excel?
    A. Ctrl + Q
    B. Alt + F4
    C. Ctrl + W
    D. Esc
    Answer: B

98. Which feature recovers unsaved files?
    A. AutoSave
    B. AutoRecover
    C. Backup
    D. Save As
    Answer: B

99. Which function returns text from a cell?
    A. TEXT()
    B. VALUE()
    C. CHAR()
    D. CODE()
    Answer: A

100. Microsoft Excel is mainly used for:
     A. Writing documents
     B. Making presentations
     C. Data calculation and analysis
     D. Drawing images
     Answer: C