100+ Excel Spreadsheet Modeling MCQs with Answers – Shortcut Keys & Error Handling
How many rows are available in an Excel worksheet?
a) 1,048,576
b) 16,384
c) 2,000,000
d) 65,536
Answer: a) 1,048,576
How many columns are available in an Excel worksheet?
a) 1,024
b) 16,384
c) 10,000
d) 20,000
Answer: b) 16,384
What is the default file extension for an Excel workbook in newer versions?
a) .xls
b) .xlsx
c) .csv
d) .xlsm
Answer: b) .xlsx
What is the function of an Excel workbook?
a) It contains multiple worksheets
b) It is a single worksheet
c) It saves only charts
d) It only stores formulas
Answer: a) It contains multiple worksheets
What is the default font in Excel?
a) Arial
b) Times New Roman
c) Calibri
d) Verdana
Answer: c) Calibri
Which key moves one cell up?
a) Up Arrow
b) Ctrl + Up Arrow
c) Shift + Up Arrow
d) Ctrl + Shift + Up Arrow
Answer: a) Up Arrow
What does "Ctrl + Down Arrow" do?
a) Moves to the last element of the column
b) Moves to the first element of the column
c) Moves to the last row of the worksheet
d) Moves to the first row of the worksheet
Answer: a) Moves to the last element of the column
How do you select the entire column?
a) Ctrl + Shift + Right Arrow
b) Ctrl + Space
c) Shift + Space
d) Ctrl + A
Answer: b) Ctrl + Space
How do you select an entire row?
a) Shift + Space
b) Ctrl + Space
c) Ctrl + Shift + Right Arrow
d) Ctrl + A
Answer: a) Shift + Space
What does "Ctrl + Home" do?
a) Moves to the last row
b) Moves to the first cell in the worksheet
c) Moves to the last filled cell
d) Moves to the center of the sheet
Answer: b) Moves to the first cell in the worksheet
What is the shortcut for undoing an action?
a) Ctrl + X
b) Ctrl + Y
c) Ctrl + Z
d) Alt + U
Answer: c) Ctrl + Z
What is the shortcut for redoing an undone action?
a) Ctrl + Y
b) Ctrl + R
c) Ctrl + X
d) Ctrl + U
Answer: a) Ctrl + Y
What does "Ctrl + F" do?
a) Find text
b) Format cells
c) Freeze panes
d) Find and replace
Answer: a) Find text
What does "Ctrl + H" do?
a) Find text
b) Replace text
c) Insert a new row
d) Hide a column
Answer: b) Replace text
What is the shortcut for opening the formula dialog box?
a) Shift + F3
b) F2
c) Ctrl + Alt + F3
d) Shift + Ctrl + F
Answer: a) Shift + F3
What shortcut adds a new row in Excel?
a) Ctrl + Shift + "+"
b) Ctrl + "-"
c) Shift + Enter
d) Ctrl + R
Answer: a) Ctrl + Shift + "+"
How do you remove a row or column?
a) Ctrl + "+"
b) Ctrl + "-"
c) Shift + Delete
d) Ctrl + Backspace
Answer: b) Ctrl + "-"
What shortcut repeats the last action?
a) F4
b) Ctrl + Y
c) Both A & B
d) None of the above
Answer: c) Both A & B
What does the "#####" error indicate?
a) Incorrect formula
b) Column width is too small
c) Circular reference
d) Missing function
Answer: b) Column width is too small
What does the "#NAME?" error mean?
a) Unrecognized text in a formula
b) Division by zero
c) Missing cell reference
d) Incorrect argument type
Answer: a) Unrecognized text in a formula
What causes the "#VALUE!" error?
a) A formula has the wrong type of argument
b) A missing reference
c) A circular reference
d) A missing worksheet
Answer: a) A formula has the wrong type of argument
What does the "#DIV/0!" error indicate?
a) A missing function
b) A division by zero
c) A missing reference
d) A calculation overflow
Answer: b) A division by zero
What does the "#REF!" error indicate?
a) A missing or invalid cell reference
b) A division by zero
c) A missing worksheet
d) A circular reference
Answer: a) A missing or invalid cell reference
What is the cause of a "#N/A" error?
a) A missing value in lookup functions
b) A syntax error
c) A formatting error
d) A function name error
Answer: a) A missing value in lookup functions
What is the shortcut to move one screen down in an Excel worksheet?
a) Ctrl + Down Arrow
b) Page Down
c) Shift + Down Arrow
d) Ctrl + Page Down
Answer: b) Page Down
How do you move one screen up in an Excel worksheet?
a) Page Up
b) Ctrl + Page Up
c) Shift + Page Up
d) Ctrl + Shift + Up Arrow
Answer: a) Page Up
What does "Alt + Page Down" do?
a) Moves one screen to the left
b) Moves one screen to the right
c) Moves one row down
d) Moves to the last row of the worksheet
Answer: b) Moves one screen to the right
What does "Alt + Page Up" do?
a) Moves one screen to the left
b) Moves one screen to the right
c) Moves one row up
d) Moves to the first row of the worksheet
Answer: a) Moves one screen to the left
How do you move to the last cell with content in a worksheet?
a) Ctrl + End
b) Ctrl + Home
c) Ctrl + Down Arrow
d) Shift + End
Answer: a) Ctrl + End
How do you extend the selection of cells to the beginning of the worksheet?
a) Ctrl + Home
b) Ctrl + Shift + Home
c) Ctrl + Shift + Up Arrow
d) Shift + Home
Answer: b) Ctrl + Shift + Home
What is the shortcut to edit a formula inside a cell?
a) F2
b) F3
c) Ctrl + E
d) Ctrl + Shift + E
Answer: a) F2
How do you enter a formula into a cell?
a) Just type the formula and press Enter
b) Press Alt + F4
c) Press Ctrl + F2
d) Press Shift + Enter
Answer: a) Just type the formula and press Enter
How can you recalculate all formulas in an Excel sheet?
a) Ctrl + Shift + R
b) F9
c) Ctrl + R
d) Alt + Enter
Answer: b) F9
What is the shortcut to open the "Insert Function" dialog box?
a) Shift + F3
b) Ctrl + F3
c) F2
d) Ctrl + Shift + F
Answer: a) Shift + F3
Which shortcut fixes a cell reference (adds a $ sign)?
a) F4
b) F2
c) Shift + F4
d) Ctrl + Alt + 4
Answer: a) F4
What is the shortcut for copying a selected cell?
a) Ctrl + X
b) Ctrl + C
c) Ctrl + V
d) Alt + C
Answer: b) Ctrl + C
How do you paste copied content?
a) Ctrl + C
b) Ctrl + X
c) Ctrl + V
d) Shift + P
Answer: c) Ctrl + V
What is the shortcut for cutting a cell?
a) Ctrl + X
b) Ctrl + C
c) Ctrl + Z
d) Ctrl + Shift + X
Answer: a) Ctrl + X
How do you open the "Paste Special" dialog box?
a) Ctrl + V
b) Ctrl + Shift + V
c) Ctrl + Alt + V
d) Alt + E + S
Answer: c) Ctrl + Alt + V
What is the shortcut for bolding text?
a) Ctrl + U
b) Ctrl + B
c) Ctrl + I
d) Ctrl + Shift + B
Answer: b) Ctrl + B
How do you italicize text in Excel?
a) Ctrl + I
b) Ctrl + U
c) Ctrl + Shift + I
d) Alt + I
Answer: a) Ctrl + I
What is the shortcut for underlining text?
a) Ctrl + I
b) Ctrl + U
c) Ctrl + Shift + U
d) Alt + U
Answer: b) Ctrl + U
What is the shortcut to open the "Find and Replace" dialog box?
a) Ctrl + H
b) Ctrl + F
c) Ctrl + R
d) Ctrl + Shift + H
Answer: a) Ctrl + H
What is the shortcut for applying filters?
a) Ctrl + Shift + L
b) Ctrl + Alt + F
c) Ctrl + F
d) Shift + F3
Answer: a) Ctrl + Shift + L
How do you remove filters in Excel?
a) Ctrl + Shift + L
b) Ctrl + Alt + L
c) Ctrl + R
d) Alt + R
Answer: a) Ctrl + Shift + L
What is the shortcut for opening the "Go To" dialog box?
a) Ctrl + G
b) F5
c) Alt + G
d) Ctrl + Alt + G
Answer: b) F5
What is the shortcut for opening the Excel Help window?
a) Ctrl + H
b) F1
c) Shift + F1
d) Ctrl + Shift + H
Answer: b) F1
How do you insert a new worksheet?
a) Shift + F11
b) Ctrl + N
c) Alt + W
d) Ctrl + Shift + N
Answer: a) Shift + F11
What is the shortcut to open the "Format Cells" dialog box?
a) Ctrl + 1
b) Ctrl + Shift + F
c) Ctrl + Alt + F1
d) Shift + F2
Answer: a) Ctrl + 1
How do you lock a workbook to prevent editing?
a) Protect Sheet option
b) Save As Read-Only
c) Both A & B
d) None of the above
Answer: c) Both A & B
