WALL STREET PREP EXCEL CRASH COURSE EXAM TEST
BANK ACTUAL 2026/2027 PRACTICE QUESTIONS AND
STUDY GUIDE ACCURATE EXAM COMPLETE APPROVED
QUESTIONS WITH WELL ELABORATED SOLUTIONS AND
DETAILED RATIONALES (100% CORRECT VERIFIED
ANSWERS) CURRENTLY UPDATED VERSION 2026 EDITION
|GUARANTEED SUCCESS A+ |INSTANT DOWNLOAD PDF
|JUST RELEASED
Question 1
What is the keyboard shortcut to open a file in Excel?
A) Ctrl + N
B) Ctrl + O
C) Ctrl + F12
D) Both B and C
Correct Answer: D) Both B and C
Rationale: Both Ctrl + O and Ctrl + F12 open the "Open File"
dialog box in Excel. Ctrl + N creates a new workbook rather than
opening an existing file. Ctrl + F opens the Find dialog. Knowing
multiple shortcuts for the same action is valuable as some users
prefer one over the other depending on hand positioning.
,Question 2
What is the keyboard shortcut to "Save As" a workbook in Excel?
A) Ctrl + S
B) F12
C) Ctrl + Shift + S
D) Alt + F4
Correct Answer: B) F12
Rationale: F12 opens the "Save As" dialog box directly. Ctrl + S
performs a standard Save. Ctrl + Shift + S is often used for "Save
As" in other applications but not the primary Excel shortcut. Alt +
F4 closes the application.
Question 3
Which shortcut allows you to edit the active cell directly?
A) F2
B) F4
C) F5
,D) Enter
Correct Answer: A) F2
Rationale: Pressing F2 allows you to edit the contents of the
selected cell without clicking into the formula bar. F4 toggles
absolute references, and F5 opens the "Go To" dialog. This
shortcut is essential for efficient formula editing in financial
models.
Question 4
To toggle between relative, absolute, and mixed references in a
formula, you select the cell reference and press:
A) F2
B) F4
C) F9
D) Ctrl + '
Correct Answer: B) F4
Rationale: F4 cycles through the reference states (e.g., A1 → $A$1
→A
, 1
→
1→A1). This is essential for locking cells when copying formulas
across rows or columns in financial models.
Question 5
What is the keyboard shortcut for Paste Special?
A) Ctrl + V
B) Ctrl + Alt + V
C) Alt + E + S
D) Both B and C
Correct Answer: D) Both B and C
Rationale: Both Alt + E + S (legacy shortcut) and Ctrl + Alt + V
open the Paste Special dialog box. In modern Excel versions, Ctrl
+ Alt + V then pressing V pastes values—a critical shortcut for
breaking links and pasting formula results as static values.
Question 6
To select an entire row in Excel, the shortcut is:
BANK ACTUAL 2026/2027 PRACTICE QUESTIONS AND
STUDY GUIDE ACCURATE EXAM COMPLETE APPROVED
QUESTIONS WITH WELL ELABORATED SOLUTIONS AND
DETAILED RATIONALES (100% CORRECT VERIFIED
ANSWERS) CURRENTLY UPDATED VERSION 2026 EDITION
|GUARANTEED SUCCESS A+ |INSTANT DOWNLOAD PDF
|JUST RELEASED
Question 1
What is the keyboard shortcut to open a file in Excel?
A) Ctrl + N
B) Ctrl + O
C) Ctrl + F12
D) Both B and C
Correct Answer: D) Both B and C
Rationale: Both Ctrl + O and Ctrl + F12 open the "Open File"
dialog box in Excel. Ctrl + N creates a new workbook rather than
opening an existing file. Ctrl + F opens the Find dialog. Knowing
multiple shortcuts for the same action is valuable as some users
prefer one over the other depending on hand positioning.
,Question 2
What is the keyboard shortcut to "Save As" a workbook in Excel?
A) Ctrl + S
B) F12
C) Ctrl + Shift + S
D) Alt + F4
Correct Answer: B) F12
Rationale: F12 opens the "Save As" dialog box directly. Ctrl + S
performs a standard Save. Ctrl + Shift + S is often used for "Save
As" in other applications but not the primary Excel shortcut. Alt +
F4 closes the application.
Question 3
Which shortcut allows you to edit the active cell directly?
A) F2
B) F4
C) F5
,D) Enter
Correct Answer: A) F2
Rationale: Pressing F2 allows you to edit the contents of the
selected cell without clicking into the formula bar. F4 toggles
absolute references, and F5 opens the "Go To" dialog. This
shortcut is essential for efficient formula editing in financial
models.
Question 4
To toggle between relative, absolute, and mixed references in a
formula, you select the cell reference and press:
A) F2
B) F4
C) F9
D) Ctrl + '
Correct Answer: B) F4
Rationale: F4 cycles through the reference states (e.g., A1 → $A$1
→A
, 1
→
1→A1). This is essential for locking cells when copying formulas
across rows or columns in financial models.
Question 5
What is the keyboard shortcut for Paste Special?
A) Ctrl + V
B) Ctrl + Alt + V
C) Alt + E + S
D) Both B and C
Correct Answer: D) Both B and C
Rationale: Both Alt + E + S (legacy shortcut) and Ctrl + Alt + V
open the Paste Special dialog box. In modern Excel versions, Ctrl
+ Alt + V then pressing V pastes values—a critical shortcut for
breaking links and pasting formula results as static values.
Question 6
To select an entire row in Excel, the shortcut is:
