Page 1 of 152
Excel Crash Course Exam|| All Questions
And Correct Answers|| Latest And
Complete Update 2026 With Expert
Solutions|| Complete A+ Guide
1. What does the Ctrl + → (right arrow) shortcut do?
A) Moves one cell right
B) Moves to the last cell with data in the row
C) Opens the next worksheet
D) Inserts a new column
Correct Answer: B
Rationale: Ctrl + Arrow jumps to the edge of the current data
region (last non-empty cell before a blank or sheet edge).
,Page 2 of 152
2. Which file extension represents a standard Excel workbook
in Excel 2016 and later?
A) .xls
B) .xlsx
C) .csv
D) .xlsm
Correct Answer: B
Rationale: .xlsx is the default for macro-free
workbooks; .xlsm includes macros, .xls is legacy (pre-2007).
3. Scenario: You are reviewing a spreadsheet with 50 columns
and 10,000 rows. You need to return to cell A1 quickly. Which
shortcut works?
A) Ctrl + Home
B) Ctrl + End
,Page 3 of 152
C) Home
D) Alt + Home
Correct Answer: A
Rationale: Ctrl + Home jumps to the beginning (A1) regardless
of scroll position. Ctrl + End goes to the last used cell.
4. True or False: You can rename a worksheet by
double-clicking its tab.
Correct Answer: True
Rationale: Double-click the sheet tab or right-click → Rename.
5. What does the “Name Box” display?
A) File name
B) Active cell reference
C) Formula result
D) Sheet name
, Page 4 of 152
Correct Answer: B
Rationale: The Name Box (left of formula bar) shows the
address of the currently selected cell or range.
6. To insert a new column, you:
A) Right-click a column header → Insert
B) Press Ctrl + Shift + =
C) Both A and B
D) None of the above
Correct Answer: C
Rationale: Both methods insert a column to the left of the
selected column.
7. How many worksheets does a new Excel workbook contain
by default (current Excel version)?
A) 1
B) 3
Excel Crash Course Exam|| All Questions
And Correct Answers|| Latest And
Complete Update 2026 With Expert
Solutions|| Complete A+ Guide
1. What does the Ctrl + → (right arrow) shortcut do?
A) Moves one cell right
B) Moves to the last cell with data in the row
C) Opens the next worksheet
D) Inserts a new column
Correct Answer: B
Rationale: Ctrl + Arrow jumps to the edge of the current data
region (last non-empty cell before a blank or sheet edge).
,Page 2 of 152
2. Which file extension represents a standard Excel workbook
in Excel 2016 and later?
A) .xls
B) .xlsx
C) .csv
D) .xlsm
Correct Answer: B
Rationale: .xlsx is the default for macro-free
workbooks; .xlsm includes macros, .xls is legacy (pre-2007).
3. Scenario: You are reviewing a spreadsheet with 50 columns
and 10,000 rows. You need to return to cell A1 quickly. Which
shortcut works?
A) Ctrl + Home
B) Ctrl + End
,Page 3 of 152
C) Home
D) Alt + Home
Correct Answer: A
Rationale: Ctrl + Home jumps to the beginning (A1) regardless
of scroll position. Ctrl + End goes to the last used cell.
4. True or False: You can rename a worksheet by
double-clicking its tab.
Correct Answer: True
Rationale: Double-click the sheet tab or right-click → Rename.
5. What does the “Name Box” display?
A) File name
B) Active cell reference
C) Formula result
D) Sheet name
, Page 4 of 152
Correct Answer: B
Rationale: The Name Box (left of formula bar) shows the
address of the currently selected cell or range.
6. To insert a new column, you:
A) Right-click a column header → Insert
B) Press Ctrl + Shift + =
C) Both A and B
D) None of the above
Correct Answer: C
Rationale: Both methods insert a column to the left of the
selected column.
7. How many worksheets does a new Excel workbook contain
by default (current Excel version)?
A) 1
B) 3
