WALL STREET PREP EXCEL CRASH COURSE RETAKE EXAM – VERIFIED ANSWER KEY WITH STEP-BY-STEP SOLUTIONS | A+ SCORE | COMPLETE REVIEW GUIDE!! 136/136****Detailed.

WALL STREET PREP EXCEL CRASH COURSE RETAKE
EXAM – VERIFIED ANSWER KEY WITH STEP-BY-STEP
SOLUTIONS | A+ SCORE | COMPLETE REVIEW GUIDE!!
136/136**2025-2026**Detailed.



WALL STREET PREP EXCEL CRASH COURSE – RETAKE EXAM

SECTION 1: EXCEL FUNDAMENTALS & NAVIGATION (Qs 1–15)

1. What is the keyboard shortcut to go directly to cell A1 from anywhere in a worksheet
(Windows)?
A) Ctrl + Home
B) Ctrl + End
C) Alt + Home
D) Shift + Space

Correct Answer: A
Rationale: Ctrl + Home moves the cursor to cell A1. Ctrl + End goes to the last used cell. Alt +
Home is not a standard shortcut. Shift + Space selects the entire row.

2. To switch between open workbooks in Windows Excel, use:
A) Ctrl + Tab
B) Alt + Tab
C) Ctrl + F6
D) Both A and C

Correct Answer: D
Rationale: Both Ctrl + Tab and Ctrl + F6 cycle through open workbooks. Alt + Tab switches
between all open applications, not just Excel.

3. Which shortcut inserts a new worksheet?
A) Shift + F11
B) Alt + Shift + F1
C) Ctrl + Shift + F11
D) Both A and B

Correct Answer: D
Rationale: Shift + F11 and Alt + Shift + F1 both insert a new worksheet. Ctrl + Shift + F11 is
not a standard Excel shortcut.

,4. To select the entire column of the active cell (Windows):
A) Ctrl + Space
B) Shift + Space
C) Ctrl + Shift + Space
D) Alt + Space

Correct Answer: A
Rationale: Ctrl + Space selects the entire column. Shift + Space selects the entire row. Ctrl +
Shift + Space selects the entire worksheet.

5. The shortcut to open the “Go To” dialog box is:
A) Ctrl + G
B) F5
C) Ctrl + Shift + G
D) Both A and B

Correct Answer: D
Rationale: Both Ctrl + G and F5 open the Go To dialog.

6. Which key do you press to edit the active cell?
A) F2
B) Enter
C) Ctrl + E
D) F4

Correct Answer: A
Rationale: F2 enters edit mode in the active cell. F4 repeats last action or toggles absolute
references.

7. What does Ctrl + D do?
A) Fill down from the cell above
B) Duplicate the worksheet
C) Delete column
D) Open the Data tab

Correct Answer: A
Rationale: Ctrl + D copies the content and format from the top cell of a selected range into
the cells below.

8. To hide the current row (Windows):
A) Ctrl + 9
B) Ctrl + 0
C) Ctrl + -
D) Ctrl + Shift + 9

, Correct Answer: A
Rationale: Ctrl + 9 hides the selected row(s). Ctrl + 0 hides columns. Ctrl + - deletes
cells/rows/columns.

9. On a Mac, the shortcut for “Fill Right” is:
A) Cmd + R
B) Ctrl + R
C) Cmd + D
D) Fn + R

Correct Answer: A
Rationale: On Mac Excel, Cmd + R fills right. Cmd + D fills down.

10. Which shortcut opens the Format Cells dialog?
A) Ctrl + 1
B) Ctrl + Shift + F
C) Alt + H + F + M
D) All of the above

Correct Answer: D
Rationale: Ctrl + 1 is the direct shortcut; Ctrl + Shift + F opens the Font tab of Format Cells;
Alt + H + F + M also accesses format options via the ribbon.

11. To insert the current date in a cell (static):
A) Ctrl + ;
B) Ctrl + Shift + ;
C) Ctrl + D
D) Ctrl + T

Correct Answer: A
Rationale: Ctrl + ; inserts today’s date as a fixed value. Ctrl + Shift + ; inserts the current time.

12. What does F4 do when editing a cell reference?
A) Toggles between relative, absolute, and mixed references
B) Repeats the last action
C) Opens the function wizard
D) Both A and B

Correct Answer: D
Rationale: F4 toggles reference types when editing a formula; otherwise, it repeats the last
action.

13. To group rows or columns (Windows):
A) Alt + Shift + Right Arrow
B) Ctrl + Shift + G