WALL STREET PREP: EXCEL CRASH COURSE KNOWLEDGE CHECK QUESTIONS AND
CORRECT ANSWERS (VERIFIED ANSWERS) PLUS RATIONALES 2026 Q&A | INSTANT
DOWNLOAD PDF
,Core Domains
Excel Keyboard Shortcuts and Navigation
Cell Referencing and Formulas
Lookup Functions (VLOOKUP, XLOOKUP)
Logical Functions (IF, IFS)
Financial Modeling Fundamentals
Data Formatting and Display
Worksheet Management
Data Analysis Tools
*
Introduction
,This comprehensive assessment evaluates mastery of essential Excel skills critical for finance professionals
and investment banking analysts. The exam tests foundational theory, applied professional knowledge,
regulatory compliance in financial modeling, ethics and professional standards, and real-world scenario
decision-making. Through 100 multiple-choice questions spanning keyboard efficiency, formula construction,
lookup functions, logical operations, and financial modeling techniques, candidates demonstrate their
ability to build accurate models, analyze data efficiently, and make sound analytical judgments. The
scenario-based structure emphasizes practical application over rote memorization, ensuring candidates can
translate Excel knowledge into professional financial analysis capabilities.
*
Section One: Questions 1–100
Question 1
What is the primary advantage of using keyboard shortcuts over mouse navigation in Excel for finance
professionals?
A. Keyboard shortcuts are easier to learn for beginners
B. Keyboard shortcuts provide faster execution and reduce hand movement
C. Keyboard shortcuts work only on Windows computers
D. Keyboard shortcuts eliminate the need for formulas
🟢 B. Keyboard shortcuts provide faster execution and reduce hand movement
, 🔴 RATIONALE: Keyboard shortcuts enable finance professionals to execute commands significantly faster
than mouse navigation while minimizing physical hand movement, which is critical when building complex
financial models requiring hundreds of operations.
Question 2
Which keyboard shortcut opens a new workbook in Excel?
A. Ctrl + O
B. Ctrl + P
C. Ctrl + N
D. Ctrl + S
🟢 C. Ctrl + N
🔴 RATIONALE: Ctrl + N (or Cmnd N on Mac) is the standard keyboard shortcut for opening a new workbook,
while Ctrl + O opens a file, Ctrl + P prints, and Ctrl + S saves.
Question 3
What does the Name Box in Excel display?
A. The current formula in the active cell
B. The name of the workbook
C. What cell you are currently in
D. The total sum of selected cells
🟢 C. What cell you are currently in
CORRECT ANSWERS (VERIFIED ANSWERS) PLUS RATIONALES 2026 Q&A | INSTANT
DOWNLOAD PDF
,Core Domains
Excel Keyboard Shortcuts and Navigation
Cell Referencing and Formulas
Lookup Functions (VLOOKUP, XLOOKUP)
Logical Functions (IF, IFS)
Financial Modeling Fundamentals
Data Formatting and Display
Worksheet Management
Data Analysis Tools
*
Introduction
,This comprehensive assessment evaluates mastery of essential Excel skills critical for finance professionals
and investment banking analysts. The exam tests foundational theory, applied professional knowledge,
regulatory compliance in financial modeling, ethics and professional standards, and real-world scenario
decision-making. Through 100 multiple-choice questions spanning keyboard efficiency, formula construction,
lookup functions, logical operations, and financial modeling techniques, candidates demonstrate their
ability to build accurate models, analyze data efficiently, and make sound analytical judgments. The
scenario-based structure emphasizes practical application over rote memorization, ensuring candidates can
translate Excel knowledge into professional financial analysis capabilities.
*
Section One: Questions 1–100
Question 1
What is the primary advantage of using keyboard shortcuts over mouse navigation in Excel for finance
professionals?
A. Keyboard shortcuts are easier to learn for beginners
B. Keyboard shortcuts provide faster execution and reduce hand movement
C. Keyboard shortcuts work only on Windows computers
D. Keyboard shortcuts eliminate the need for formulas
🟢 B. Keyboard shortcuts provide faster execution and reduce hand movement
, 🔴 RATIONALE: Keyboard shortcuts enable finance professionals to execute commands significantly faster
than mouse navigation while minimizing physical hand movement, which is critical when building complex
financial models requiring hundreds of operations.
Question 2
Which keyboard shortcut opens a new workbook in Excel?
A. Ctrl + O
B. Ctrl + P
C. Ctrl + N
D. Ctrl + S
🟢 C. Ctrl + N
🔴 RATIONALE: Ctrl + N (or Cmnd N on Mac) is the standard keyboard shortcut for opening a new workbook,
while Ctrl + O opens a file, Ctrl + P prints, and Ctrl + S saves.
Question 3
What does the Name Box in Excel display?
A. The current formula in the active cell
B. The name of the workbook
C. What cell you are currently in
D. The total sum of selected cells
🟢 C. What cell you are currently in
