100% A+ ANSWER SHEET - WALL STREET PREP EXCEL CRASH
COURSE RETAKE EXAM ANSWER SHEET 110+Questions
**2026**With Verified and detailed Answers!!
WALL STREET PREP EXCEL CRASH COURSE – RETAKE EXAM
Section 1: Excel Basics & Navigation (Q1–15)
Q1. What is the keyboard shortcut to open the Go To dialog box?
• A) Ctrl + G
• B) Ctrl + H
• C) Ctrl + F
• D) F5
Answer: A and D (both Ctrl + G and F5)
Rationale: Ctrl+G and F5 both launch the Go To dialog, used to jump to specific cells or
named ranges.
Q2. To quickly select all cells containing data in a contiguous range from the active cell, you
press:
• A) Ctrl + A once
• B) Ctrl + A twice
• C) Ctrl + Shift + End
• D) Ctrl + *
,Answer: D (Ctrl + *)
Rationale: Ctrl + * selects the current region around the active cell. Ctrl+A once selects
entire sheet; twice selects all cells with data.
Q3. Which shortcut moves the cursor to the last used cell on a worksheet?
• A) Ctrl + End
• B) Ctrl + Home
• C) End + Home
• D) Ctrl + Page Down
Answer: A (Ctrl + End)
Rationale: Ctrl + End jumps to the intersection of the last row and column that contains
data.
Q4. To switch between open workbooks, the shortcut is:
• A) Ctrl + Tab
• B) Alt + Tab
• C) Ctrl + F6
• D) Both A and C
Answer: D (Both A and C)
Rationale: Ctrl+Tab cycles through Excel workbooks; Ctrl+F6 does the same. Alt+Tab
switches between all open applications.
Q5. Which key combination inserts the current date in a cell?
• A) Ctrl + ;
• B) Ctrl + Shift + ;
, • C) Ctrl + D
• D) Ctrl + :
Answer: A (Ctrl + ;)
Rationale: Ctrl + ; inserts today’s date static value. Ctrl + Shift + ; inserts current time.
Section 2: Formulas & Functions (Q16–35)
Q16. Which function returns the number of cells in a range that contain numbers?
• A) COUNTA
• B) COUNT
• C) COUNTBLANK
• D) COUNTIF
Answer: B (COUNT)
Rationale: COUNT counts numeric cells only. COUNTA counts non-blank cells (text &
numbers).
Q17. What does =IFERROR(VLOOKUP(A1,B:C,2,0),"Not Found") return if VLOOKUP results in
an error?
• A) 0
• B) #N/A
• C) "Not Found"
• D) Blank
Answer: C ("Not Found")
Rationale: IFERROR catches any error (#N/A, #VALUE!, etc.) and returns the second
argument.
COURSE RETAKE EXAM ANSWER SHEET 110+Questions
**2026**With Verified and detailed Answers!!
WALL STREET PREP EXCEL CRASH COURSE – RETAKE EXAM
Section 1: Excel Basics & Navigation (Q1–15)
Q1. What is the keyboard shortcut to open the Go To dialog box?
• A) Ctrl + G
• B) Ctrl + H
• C) Ctrl + F
• D) F5
Answer: A and D (both Ctrl + G and F5)
Rationale: Ctrl+G and F5 both launch the Go To dialog, used to jump to specific cells or
named ranges.
Q2. To quickly select all cells containing data in a contiguous range from the active cell, you
press:
• A) Ctrl + A once
• B) Ctrl + A twice
• C) Ctrl + Shift + End
• D) Ctrl + *
,Answer: D (Ctrl + *)
Rationale: Ctrl + * selects the current region around the active cell. Ctrl+A once selects
entire sheet; twice selects all cells with data.
Q3. Which shortcut moves the cursor to the last used cell on a worksheet?
• A) Ctrl + End
• B) Ctrl + Home
• C) End + Home
• D) Ctrl + Page Down
Answer: A (Ctrl + End)
Rationale: Ctrl + End jumps to the intersection of the last row and column that contains
data.
Q4. To switch between open workbooks, the shortcut is:
• A) Ctrl + Tab
• B) Alt + Tab
• C) Ctrl + F6
• D) Both A and C
Answer: D (Both A and C)
Rationale: Ctrl+Tab cycles through Excel workbooks; Ctrl+F6 does the same. Alt+Tab
switches between all open applications.
Q5. Which key combination inserts the current date in a cell?
• A) Ctrl + ;
• B) Ctrl + Shift + ;
, • C) Ctrl + D
• D) Ctrl + :
Answer: A (Ctrl + ;)
Rationale: Ctrl + ; inserts today’s date static value. Ctrl + Shift + ; inserts current time.
Section 2: Formulas & Functions (Q16–35)
Q16. Which function returns the number of cells in a range that contain numbers?
• A) COUNTA
• B) COUNT
• C) COUNTBLANK
• D) COUNTIF
Answer: B (COUNT)
Rationale: COUNT counts numeric cells only. COUNTA counts non-blank cells (text &
numbers).
Q17. What does =IFERROR(VLOOKUP(A1,B:C,2,0),"Not Found") return if VLOOKUP results in
an error?
• A) 0
• B) #N/A
• C) "Not Found"
• D) Blank
Answer: C ("Not Found")
Rationale: IFERROR catches any error (#N/A, #VALUE!, etc.) and returns the second
argument.
