Part 1: Basic Excel Concepts (Questions 1-25)

1. What is the default file extension for a workbook in Microsoft Excel

2007 and later?
A) .xls
B) .xlsx
C) .doc
D) .txt

2. What is the intersection of a row and a column called?

A) Grid
B) Table
C) Cell
D) Box

3. Which of the following is the correct cell address format?

A) 1A
B) A1
C) $A
D) A-1

4. What is the collection of worksheets called?

A) Excel sheet
B) Workbook
C) Spreadsheet
D) Data sheet

5. By default, how many worksheets are there in a new Excel workbook

in older versions?
A) 1
B) 2
C) 3
D) 4

6. What is the maximum number of rows supported in a single Excel

2016 worksheet?
A) 65,536
B) 1,048,576
C) 16,384
D) 512,000

7. What is the maximum number of columns supported in a single

Excel worksheet?
A) 256
B) 1,024
C) 16,384
D) 32,768
8. Which bar is used to view, enter, or edit data and formulas in an
active cell?
A) Status Bar
B) Formula Bar
C) Title Bar
D) Menu Bar

9. Which symbol must every formula in Excel begin with?

A) +
B) @
C) =
D) #

10. Which area displays the address of the currently selected cell?
A) Formula Bar
B) Name Box
C) Title Bar
D) Status Bar

11. What is the default alignment of text data in an Excel cell?

A) Left
B) Right
C) Center
D) Justified

12. What is the default alignment of numeric data in an Excel cell?

A) Left
B) Right
C) Center
D) Justified

13. Which shortcut key is used to open an existing workbook?

A) Ctrl + N
B) Ctrl + O
C) Ctrl + S
D) Ctrl + W

14. Which shortcut key creates a new blank workbook?

A) Ctrl + W
B) Ctrl + N
C) Ctrl + M
D) Ctrl + B

15. What is the shortcut key to save a workbook?

A) Ctrl + S
B) Ctrl + A
 C) Ctrl + V
D) Ctrl + P

16. Which shortcut key closes the currently open workbook?

A) Ctrl + E
B) Ctrl + W
C) Ctrl + Q
D) Ctrl + X

17. To undo the last action in Excel, which shortcut key should you
use?
A) Ctrl + Y
B) Ctrl + Z
C) Ctrl + U
D) Ctrl + I

18. What is the shortcut key to redo an action?

A) Ctrl + Z
B) Ctrl + R
C) Ctrl + Y
D) Ctrl + Shift + Z

19. Which command is used to combine multiple selected cells

into one single larger cell?
A) Wrap Text
B) Merge & Center
C) Join Cells
D) Group Cells

20. What feature automatically wraps text to multiple lines within

a cell if it exceeds the column width?
A) Merge Cells
B) AutoFit
C) Wrap Text
D) Text Align

21. Columns are identified by which of the following?

A) Numbers (1, 2, 3...)
B) Letters (A, B, C...)
C) Roman numerals (I, II, III...)
D) Symbols (*, #, @...)

22. Rows are identified by which of the following?

A) Letters (A, B, C...)
B) Numbers (1, 2, 3...)
C) Colors
D) Special characters
 23. What is the keyboard shortcut to edit the content of a selected
cell?
A) F1
B) F2
C) F3
D) F4

24. What is the box in the bottom-right corner of a selected cell or

range called?
A) Fill Handle
B) Form Box
C) Copy Box
D) Target Tool

25. Which tab on the Ribbon contains commands for changing

fonts, text alignment, and cell styles?
A) Insert
B) Page Layout
C) Home
D) Data

Part 2: Formulas, Functions, and Errors (Questions 26-50)

26. Which function adds all the numbers in a range of cells?

A) TOTAL
B) ADD
C) SUM
D) PLUS

27. Which function calculates the arithmetic mean of a range of

numbers?
A) MEAN
B) AVERAGE
C) MEDIAN
D) MODE

28. Which function returns the highest value in a specified range?

A) HIGH
B) MAXIMUM
C) MAX
D) LARGEST

29. Which function returns the lowest value in a specified range?

A) MIN
B) LOW
 C) MINIMUM
D) SMALLEST

30. Which function counts only the cells that contain numeric
values?
A) COUNTA
B) COUNT

31. COUNTBLANK
D) COUNTIF

31. Which function counts all non-empty cells in a range, including

text and numbers?
A) COUNT
B) COUNTA
C) COUNTIF
D) COUNTBLANK

32. Which function counts the number of empty cells in a

specified range?
A) COUNT
B) COUNTA
C) COUNTBLANK
D) COUNTEMPTY

33. What type of cell reference changes automatically when a

formula is copied to another cell?
A) Absolute Reference
B) Relative Reference
C) Mixed Reference
D) Dynamic Reference

34. What symbol is used to make a cell reference absolute

(locked)?
A) %
B) &
C) $
D) #

35. Which of the following represents an absolute cell reference?

A) A1
B) $A1
C) A$1
D) \(A\)1

36. Which function returns one value if a condition is true and

another value if it is false?
 A) AND
B) OR
C) IF
D) NOT

37. Which error code indicates that Excel does not recognize text
used in a formula (such as a misspelled function name)?
A) #VALUE!
B) #NAME?
C) #REF!
D) #DIV/0!

38. What does the #DIV/0! error mean?

A) The formula is trying to divide by zero or an empty cell.
B) The column is too narrow to display the value.
C) A cell reference is invalid.
D) The wrong data type is being used.

39. What does it mean when a cell displays a series of pound

signs (#####)?
A) There is a formula error.
B) The cell is locked.
C) The column is not wide enough to display the numeric data.
D) The data has been deleted.

40. Which error code appears when a formula refers to a cell that
has been deleted?
A) #NAME?
B) #REF!
C) #VALUE!
D) #NUM!

41. Which error code appears if you use the wrong type of
argument or operand in a formula?
A) #VALUE!
B) #REF!
C) #DIV/0!
D) #NAME?

42. What is the correct way to write a cell range from cell A1
through cell A10?
A) A1-A10
B) A1 to A10
C) A1:A10
D) A1,A10
43. Which mathematical operator has the highest precedence in
Excel formulas?
A) Multiplication (*)
B) Addition (+)
C) Parentheses ( )
D) Exponentiation (^)

44. Which function is used to join two or more text strings into one
string?
A) JOIN
B) CONCATENATE
C) MERGE
D) COMBINE

45. Which function is used to search for a value in the leftmost

column of a table and return a value in the same row?
A) HLOOKUP
B) VLOOKUP
C) INDEX
D) MATCH

46. In VLOOKUP, what does the "V" stand for?

A) Variable
B) Vertical
C) Value
D) Verified

47. In HLOOKUP, what does the "H" stand for?

A) Height
B) Horizontal
C) Hidden
D) Header

48. Which function returns the current date and time?

A) TODAY()
B) NOW()
C) DATE()
D) TIME()

49. Which function returns only the current system date without
the time?
A) DATE()
B) NOW()
C) TODAY()
D) CURRENT()
 50. Which function converts lowercase text to all uppercase
letters?
A) UPPER
B) LOWER
C) PROPER
D) CAPS

Part 3: Data Management and Formatting (Questions 51-75)

51. Which feature allows you to arrange data in a specific order

(e.g., A to Z or smallest to largest)?
A) Filter
B) Sort
C) Group
D) Validate

52. Which feature allows you to display only the rows that meet
specific criteria while hiding the rest?
A) Sort
B) Filter
C) Freeze Panes
D) Conditional Formatting

53. Which tool allows you to automatically apply formatting (like

cell color) based on the cell value?
A) Format Painter
B) Styles
C) Conditional Formatting
D) Themes

54. What is the shortcut key to open the "Find and Replace" dialog
box?
A) Ctrl + F
B) Ctrl + H
C) Ctrl + R
D) Ctrl + G

55. Which shortcut key is specifically used to open the "Find" tab
directly?
A) Ctrl + F
B) Ctrl + H
C) Ctrl + E
D) Ctrl + D
56. Which tool copies formatting from one object or cell and
applies it to another?
A) Copy-Paste
B) Format Painter
C) Transpose
D) SmartArt

57. Which feature locks specific rows or columns in place so they

remain visible while scrolling?
A) Lock Cells
B) Split Panes
C) Freeze Panes
D) Pin Rows

58. What feature helps prevent invalid data from being entered
into a cell?
A) Conditional Formatting
B) Data Validation
C) Protect Sheet
D) Goal Seek

59. Which command allows you to turn rows into columns or

columns into rows during a paste operation?
A) Shift
B) Invert
C) Transpose
D) Flip

60. What is the shortcut key to select the entire worksheet?

A) Ctrl + S
B) Ctrl + A
C) Ctrl + W
D) Ctrl + Space

61. What is the shortcut key to select an entire column?

A) Ctrl + Spacebar
B) Shift + Spacebar
C) Ctrl + Shift + C
D) Alt + Spacebar

62. What is the shortcut key to select an entire row?

A) Ctrl + Spacebar
B) Shift + Spacebar
C) Ctrl + Shift + R
D) Alt + Enter
63. Which feature removes duplicate values from a selected range
of data?
A) Clean Data
B) Filter Duplicates
C) Remove Duplicates
D) Deduplicate

64. What type of chart is best suited for showing trends over
time?
A) Pie Chart
B) Line Chart
C) Bar Chart
D) Scatter Plot

65. What type of chart is ideal for showing proportional shares or

percentages of a whole?
A) Column Chart
B) Line Chart
C) Pie Chart
D) Area Chart

66. What are the small charts embedded within a single

worksheet cell to show data trends called?
A) Mini Charts
B) Micro Charts
C) Sparklines
D) Cell Charts

67. Which feature allows you to summarize, analyze, and explore

large amounts of cross-tabulated data?
A) PivotTable
B) Smart Table
C) Data Matrix
D) Power Pivot

68. What is the keyboard shortcut to insert a new chart in the

current worksheet instantly?
A) F11
B) Alt + F1
C) F2
D) Shift + F11

69. What is the keyboard shortcut to create a chart on a separate

chart sheet?
A) Alt + F1
B) F11
 C) Ctrl + P
D) F5

70. Which tab on the Ribbon do you use to insert charts or

PivotTables?
A) Home
B) Design
C) Insert
D) Data

71. Which wild card character matches any single character in a

search or filter operation?
A) Asterisk (*)
B) Question mark (?)
C) Ampersand (&)
D) Dollar sign ($)

72. Which wild card character matches any sequence of

characters?
A) Question mark (?)
B) Asterisk (*)
C) Hash (#)
D) At symbol (@)

73. How do you display formulas in cells instead of their

calculated results?
A) Press Ctrl + ` (Grave Accent)
B) Press Ctrl + F
C) Click the View Tab
D) Press Alt + Enter

74. What feature allows you to save a pre-formatted style layout

for tables?
A) Cell Styles
B) Format as Table
C) Themes
D) Layout Planner

75. Which button changes a number format to include a dollar

sign, commas, and two decimals?
A) Percent Style
B) Comma Style
C) Accounting Number Format
D) Merge Center
Part 4: Advanced Excel and Keyboard Shortcuts (Questions 76-
100)

76. What tool is used to automate repetitive tasks by recording

actions?
A) PivotTable
B) Macro
C) Solver
D) Goal Seek

77. What programming language is used to write or edit Excel

Macros?
A) Python
B) C++
C) VBA (Visual Basic for Applications)
D) Java

78. Which tab on the Ribbon must be enabled to work with Macros
and VBA?
A) Review
B) Developer
C) Data
D) Add-ins

79. What is the file extension of an Excel Macro-Enabled

Workbook?
A) .xlsx
B) .xls
C) .xlsm
D) .xltx

80. Which tool is used to find the input value needed to achieve a
specific formula result?
A) Scenario Manager
B) Solver
C) Goal Seek
D) Data Table

81. Which advanced analysis tool handles complex problems with

multiple changing variables and constraints?
A) Goal Seek
B) Solver
C) Quick Analysis
D) Forecast Sheet

82. What is the shortcut key to insert the current date into a cell?
A) Ctrl + ; (Semicolon)
 B) Ctrl + Shift + ;
C) Alt + D
D) Ctrl + D

83. What is the shortcut key to insert the current time into a cell?
A) Ctrl + ;
B) Ctrl + Shift + : (Colon)
C) Alt + T
D) Ctrl + T

84. What happens when you press Alt + Enter inside a cell?
A) It enters the data and moves down one cell.
B) It enters the data and moves right one cell.
C) It inserts a new line break within the same cell.
D) It clears the content of the cell.

85. Which shortcut key flashes the "Flash Fill" command to

recognize patterns and fill data?
A) Ctrl + F
B) Ctrl + E
C) Ctrl + G
D) Ctrl + D

86. Which shortcut key copies the formula or value from the cell
directly above into the current cell?
A) Ctrl + R
B) Ctrl + D
C) Ctrl + C
D) Ctrl + Up Arrow

87. Which shortcut key copies the formula or value from the cell
directly to the left into the current cell?
A) Ctrl + L
B) Ctrl + R
C) Ctrl + D
D) Ctrl + Left Arrow

88. What is the shortcut key to open the "Format Cells" dialog
box?
A) Ctrl + 1
B) Ctrl + F
C) Ctrl + Shift + F
D) Alt + 1

89. Which shortcut toggles a cell reference between relative,

absolute, and mixed styles while editing a formula?
A) F2
 B) F4
C) F9
D) F11

90. Which function returns the number of characters in a text

string?
A) COUNT
B) LEN
C) CHAR
D) LENGTH

91. Which function extracts a specified number of characters

starting from the left side of a text string?
A) LEFT
B) RIGHT
C) MID
D) FIRST

92. Which function removes all leading, trailing, and extra spaces
from a text string except for single spaces between words?
A) CLEAN
B) CLEAR
C) TRIM
D) REMOVE

93. What is the keyboard shortcut to force a manual recalculation

of all formulas in a workbook?
A) F2
B) F5
C) F9
D) F12

94. What is the keyboard shortcut to display the "Go To" dialog
box?
A) F2
B) F5
C) F7
D) F9

95. What keyboard shortcut opens the Excel Help window?

A) F1
B) F2
C) F3
D) F4

96. Which shortcut key starts a spellcheck on the active

worksheet?
 A) F2
B) F5
C) F7
D) F11

97. What view allows you to see exactly where pages will break
when printed?
A) Normal View
B) Page Layout View
C) Page Break Preview
D) Custom View

98. Which feature allows you to lock cells and protect structure to
prevent unauthorized changes?
A) Hide Workbook
B) Protect Sheet
C) Password Lock
D) Data Validation

99. What does the function =COUNTA(A1:A5) do?

A) Counts only numbers in the range.
B) Counts empty cells in the range.
C) Counts all non-blank cells (text, numbers, errors) in the range.
D) Adds up the values in the range.

100. Which tool allows you to easily combine data from multiple
worksheets or workbooks into one master summary table?
A) Consolidate
B) Merge Workbooks
C) PivotTable Connect
D) Data Link

🔑 Answer Key

Part 1 (Basic Concepts)

1. B | 2. C | 3. B | 4. B | 5. C | 6. B | 7. C | 8. B | 9. C | 10. B | 11. A | 12.

B | 13. B | 14. B | 15. A | 16. B | 17. B | 18. C | 19. B | 20. C | 21. B |
22. B | 23. B | 24. A | 25. C

Part 2 (Formulas & Errors)

26. C | 27. B | 28. C | 29. A | 30. B | 31. B | 32. C | 33. B | 34. C |

35. D | 36. C | 37. B | 38. A | 39. C | 40. B | 41. A | 42. C | 43. C | 44.
B | 45. B | 46. B | 47. B | 48. B | 49. C | 50. A

Part 3 (Data Management)

 51. B | 52. B | 53. C | 54. B | 55. A | 56. B | 57. C | 58. B | 59. C |
60. B | 61. A | 62. B | 63. C | 64. B | 65. C | 66. C | 67. A | 68. B | 69.
B | 70. C | 71. B | 72. B | 73. A | 74. B | 75. C

Part 4 (Advanced & Shortcuts)

76. B | 77. C | 78. B | 79. C | 80. C | 81. B | 82. A | 83. B | 84. C |

85. B | 86. B | 87. B | 88. A | 89. B | 90. B | 91. A | 92. C | 93. C | 94.
B | 95. A | 96. C | 97. C | 98. B | 99. C | 100. A