100 Excel MCQs (One-Line Questions with Answers)
🧮 100 Excel MCQs (One-Line Questions with Answers)
1. Excel is a ___ software. → Spreadsheet
2. File created in Excel is called a ___. → Workbook
3. The intersection of a row and column is called a ___. → Cell
4. Rows are labeled with ___. → Numbers
5. Columns are labeled with ___. → Letters
6. A group of cells is called a ___. → Range
7. The default file extension of Excel 2007 and later is ___. → .xlsx
8. The formula in Excel always starts with ___. → = (Equal Sign)
9. In Excel, data is stored in ___. → Cells
10. The smallest unit in Excel is ___. → Cell
11. Which function adds values? → SUM()
12. Which function finds the average? → AVERAGE()
13. Which function counts numeric cells? → COUNT()
14. Which function shows maximum value? → MAX()
15. Which function shows minimum value? → MIN()
16. The shortcut key to save a file is ___. → Ctrl + S
17. The shortcut key to open a file is ___. → Ctrl + O
18. The shortcut key to create a new workbook is ___. → Ctrl + N
19. The shortcut key to print is ___. → Ctrl + P
20. The shortcut key to copy is ___. → Ctrl + C
21. The shortcut key to cut is ___. → Ctrl + X
22. The shortcut key to paste is ___. → Ctrl + V
23. The shortcut key to undo is ___. → Ctrl + Z
24. The shortcut key to redo is ___. → Ctrl + Y
25. The shortcut key to find is ___. → Ctrl + F
26. The shortcut key to replace is ___. → Ctrl + H
27. The shortcut key to close Excel is ___. → Alt + F4
28. The key to start editing a cell is ___. → F2
29. The shortcut to AutoSum is ___. → Alt + =
30. The default number of worksheets in a workbook is ___. → 1 (or 3 in older versions)
31. Which tab contains chart options? → Insert Tab
32. Which tab contains Sort and Filter options? → Data Tab
33. Which tab contains page setup? → Page Layout Tab
34. Which tab contains Spell Check? → Review Tab
35. A chart in Excel represents data ___. → Graphically
36. The default chart type is ___. → Column Chart
37. Formula Bar is used to ___. → Enter or edit formulas
38. The Name Box shows ___. → Active cell address
39. Which function displays current date? → TODAY()
40. Which function displays current time? → NOW()
41. Which function joins text? → CONCATENATE()
42. Which function removes extra spaces? → TRIM()
43. Which function converts text to uppercase? → UPPER()
44. Which function converts text to lowercase? → LOWER()
45. Which function capitalizes words? → PROPER()
46. Which function checks a condition? → IF()
47. Which function finds data vertically? → VLOOKUP()
48. Which function finds data horizontally? → HLOOKUP()
49. Which function counts non-empty cells? → COUNTA()
50. Which function adds values based on criteria? → SUMIF()
51. Which function counts based on condition? → COUNTIF()
52. Which function returns rank? → RANK()
53. Which function returns average with condition? → AVERAGEIF()
54. Which function rounds numbers? → ROUND()
55. Which function gives integer value? → INT()
56. Which function finds remainder? → MOD()
57. Which function generates random numbers? → RAND()
58. Which function calculates standard deviation? → STDEV()
59. Which function finds correlation? → CORREL()
60. Which function returns nth largest value? → LARGE()
61. Which function returns nth smallest value? → SMALL()
62. Excel files are saved with extension ___. → .xlsx
63. Old Excel versions used extension ___. → .xls
64. Which function finds square root? → SQRT()
65. Which function calculates power? → POWER()
66. Which function displays the end of the month? → EOMONTH()
67. Which function calculates loan payment? → PMT()
68. Which function calculates future value? → FV()
69. Which function calculates present value? → PV()
70. Which function calculates net present value? → NPV()
71. Which function calculates internal rate of return? → IRR()
72. Which function counts blank cells? → COUNTBLANK()
73. Which function returns row number? → ROW()
74. Which function returns column number? → COLUMN()
75. Which function returns cell address? → ADDRESS()
76. Which function returns cell value by position? → INDEX()
77. Which function returns position of value? → MATCH()
78. Which function combines INDEX and MATCH? → INDEX-MATCH
79. Which function creates hyperlink? → HYPERLINK()
80. Which function protects a sheet? → Protect Sheet option
81. Which feature helps summarize data? → Pivot Table
82. Which feature highlights cells based on condition? → Conditional Formatting
83. Which feature is used to hide data? → Filter
84. Which feature sorts data alphabetically? → Sort
85. Which feature adds comments? → Review Tab
86. Which feature checks spelling? → Spelling Checker
87. Which function checks multiple conditions? → AND()
88. Which function checks if one condition is true? → OR()
89. Which function reverses logical value? → NOT()
90. Which function avoids error messages? → IFERROR()
91. Which function returns TRUE value? → TRUE()
92. Which function returns FALSE value? → FALSE()
93. Which key combination applies filter? → Ctrl + Shift + L
94. Which key combination inserts new worksheet? → Shift + F11
95. Which key combination selects all? → Ctrl + A
96. Which key combination opens help window? → F1
97. Which key combination repeats last action? → F4
98. Which key combination goes to specific cell? → Ctrl + G
99. Which key combination opens Format Cells dialog? → Ctrl + 1
100. Which company developed Excel? → Microsoft