100% A+ ANSWER SHEET - WALL STREET
PREP EXCEL CRASH COURSE RETAKE EXAM
ANSWER SHEET 48/48 **2024/2025** Excel
Crash Course Exam 2025 Latest Version –
Wall Street Prep (WSP) 100% Verified
Questions & Correct Answers130+Questions
Updated!!
WALL STREET PREP EXCEL CRASH COURSE – RETAKE EXAM (2025 Latest Version)
SECTION 1: EXCEL BASICS & NAVIGATION (Questions 1–20)
1. What is the keyboard shortcut to go to cell A1 from anywhere in a worksheet?
A) Ctrl + Home
B) Ctrl + End
C) Alt + A1
D) F5 + Enter
Answer: A) Ctrl + Home
Rationale: Ctrl + Home moves the cursor to cell A1. Ctrl + End goes to the last used cell. F5
opens Go To but requires typing A1.
2. To switch between open workbooks, which shortcut is most efficient?
A) Alt + Tab
, B) Ctrl + Tab
C) Ctrl + F6
D) Both B and C
Answer: D) Both B and C
Rationale: Ctrl + Tab and Ctrl + F6 both cycle through open workbooks in Excel. Alt + Tab
switches between all open applications.
3. Which setting ensures that formulas recalculate automatically when source data changes?
A) Manual calculation
B) Automatic calculation
C) Iterative calculation
D) Data Table refresh
Answer: B) Automatic calculation
Rationale: Automatic calculation (default) updates formulas instantly. Manual is used for
large models to prevent lag.
(Questions 4–20 continue in similar style – examples below)
4. What does F4 do when editing a cell reference in a formula?
A) Opens the function arguments
B) Toggles absolute/relative referencing
C) Repeats last action
D) Opens Find & Replace
Answer: B) Toggles absolute/relative referencing
Rationale: F4 cycles through $A$1, A$1, $A1, A1.
5. Which shortcut inserts a new worksheet?
A) Shift + F11
B) Alt + I + W
C) Ctrl + N
D) Both A and B
Answer: D) Both A and B
PREP EXCEL CRASH COURSE RETAKE EXAM
ANSWER SHEET 48/48 **2024/2025** Excel
Crash Course Exam 2025 Latest Version –
Wall Street Prep (WSP) 100% Verified
Questions & Correct Answers130+Questions
Updated!!
WALL STREET PREP EXCEL CRASH COURSE – RETAKE EXAM (2025 Latest Version)
SECTION 1: EXCEL BASICS & NAVIGATION (Questions 1–20)
1. What is the keyboard shortcut to go to cell A1 from anywhere in a worksheet?
A) Ctrl + Home
B) Ctrl + End
C) Alt + A1
D) F5 + Enter
Answer: A) Ctrl + Home
Rationale: Ctrl + Home moves the cursor to cell A1. Ctrl + End goes to the last used cell. F5
opens Go To but requires typing A1.
2. To switch between open workbooks, which shortcut is most efficient?
A) Alt + Tab
, B) Ctrl + Tab
C) Ctrl + F6
D) Both B and C
Answer: D) Both B and C
Rationale: Ctrl + Tab and Ctrl + F6 both cycle through open workbooks in Excel. Alt + Tab
switches between all open applications.
3. Which setting ensures that formulas recalculate automatically when source data changes?
A) Manual calculation
B) Automatic calculation
C) Iterative calculation
D) Data Table refresh
Answer: B) Automatic calculation
Rationale: Automatic calculation (default) updates formulas instantly. Manual is used for
large models to prevent lag.
(Questions 4–20 continue in similar style – examples below)
4. What does F4 do when editing a cell reference in a formula?
A) Opens the function arguments
B) Toggles absolute/relative referencing
C) Repeats last action
D) Opens Find & Replace
Answer: B) Toggles absolute/relative referencing
Rationale: F4 cycles through $A$1, A$1, $A1, A1.
5. Which shortcut inserts a new worksheet?
A) Shift + F11
B) Alt + I + W
C) Ctrl + N
D) Both A and B
Answer: D) Both A and B
