EXCEL CRASH COURSE EXAM FROM WALL STREET PREP QUESTIONS AND CORRECT
ANSWERS (VERIFIED ANSWERS) PLUS RATIONALES 2026 Q&A | INSTANT DOWNLOAD PDF.
Core Domains
Excel Fundamentals, Interface, and Navigation
Keyboard Shortcuts and Productivity
Cell References and Formula Construction
Core Functions and Logical Operations
Lookup and Reference Functions
Financial Functions and Modeling
Data Analysis, PivotTables, and Charts
Formatting, Printing, and Model-Building Best Practices
Introduction
The Wall Street Prep Excel Crash Course Examination assesses the proficiency of finance
professionals in using Microsoft Excel for financial modeling and analysis. It evaluates knowledge
across keyboard shortcuts, formula construction, logical and lookup functions, financial functions,
data analysis, and model-building best practices. The assessment employs multiple-choice and
scenario-based questions to test real-world application and decision-making. Emphasis is placed
on efficiency, accuracy, and professional modeling standards. This exam ensures candidates are
prepared to build robust financial models used in investment banking, private equity, and
corporate finance.
Section One: Questions 1–100
1. In Excel, what type of cell reference remains constant when a formula is copied to another
cell?
A. Relative reference
B. Mixed reference
C. Circular reference
D. Absolute reference
🟢 D. Absolute reference
,🔴 RATIONALE: An absolute reference (e.g., $A$1) locks both the column and row so it does
not change when copied.
2. Which of the following represents a mixed cell reference in Excel?
A. A1
B. $A$1
C. A$1
D. #REF!
🟢 C. A$1
🔴 RATIONALE: A mixed reference locks either the row (A1)orthecolumn(A1), but not both.
3. According to Excel's order of operations, which calculation is performed first in the formula
= 6 + 3 * 2 ^ 2?
A. 6 + 3
B. 3 * 2
C. 2 ^ 2
D. 6 + 12
🟢 C. 2 ^ 2
🔴 RATIONALE: Exponentiation (^) has higher precedence than multiplication (*) and addition
(+), so 2 ^ 2 is calculated first.
4. What is the result of the formula =ROUND(3.14159, 2)?
A. 3.14
B. 3.142
C. 3.1
D. 3
🟢 A. 3.14
🔴 RATIONALE: The ROUND function rounds a number to a specified number of digits; here,
3.14159 rounded to 2 decimal places is 3.14.
5. Which function counts only the cells that contain numbers in a given range?
, A. COUNTA
B. COUNTBLANK
C. COUNT
D. LEN
🟢 C. COUNT
🔴 RATIONALE: The COUNT function tallies only numeric values, whereas COUNTA includes all
non-blank cells.
6. What does the AVERAGE function return if applied to a range containing the values 10, 20,
blank, and text?
A. 15
B. 10
C. Error
D. 30
🟢 A. 15
🔴 RATIONALE: AVERAGE ignores blank cells and text, so it calculates (10 + 20) / 2 = 15.
7. Which function returns TRUE only if all its arguments are TRUE?
A. OR
B. NOT
C. XOR
D. AND
🟢 D. AND
🔴 RATIONALE: The AND function evaluates to TRUE only when every condition provided is
TRUE.
8. What is the output of =IF(5 > 3, "Yes", "No")?
A. FALSE
B. TRUE
C. Yes
D. No
ANSWERS (VERIFIED ANSWERS) PLUS RATIONALES 2026 Q&A | INSTANT DOWNLOAD PDF.
Core Domains
Excel Fundamentals, Interface, and Navigation
Keyboard Shortcuts and Productivity
Cell References and Formula Construction
Core Functions and Logical Operations
Lookup and Reference Functions
Financial Functions and Modeling
Data Analysis, PivotTables, and Charts
Formatting, Printing, and Model-Building Best Practices
Introduction
The Wall Street Prep Excel Crash Course Examination assesses the proficiency of finance
professionals in using Microsoft Excel for financial modeling and analysis. It evaluates knowledge
across keyboard shortcuts, formula construction, logical and lookup functions, financial functions,
data analysis, and model-building best practices. The assessment employs multiple-choice and
scenario-based questions to test real-world application and decision-making. Emphasis is placed
on efficiency, accuracy, and professional modeling standards. This exam ensures candidates are
prepared to build robust financial models used in investment banking, private equity, and
corporate finance.
Section One: Questions 1–100
1. In Excel, what type of cell reference remains constant when a formula is copied to another
cell?
A. Relative reference
B. Mixed reference
C. Circular reference
D. Absolute reference
🟢 D. Absolute reference
,🔴 RATIONALE: An absolute reference (e.g., $A$1) locks both the column and row so it does
not change when copied.
2. Which of the following represents a mixed cell reference in Excel?
A. A1
B. $A$1
C. A$1
D. #REF!
🟢 C. A$1
🔴 RATIONALE: A mixed reference locks either the row (A1)orthecolumn(A1), but not both.
3. According to Excel's order of operations, which calculation is performed first in the formula
= 6 + 3 * 2 ^ 2?
A. 6 + 3
B. 3 * 2
C. 2 ^ 2
D. 6 + 12
🟢 C. 2 ^ 2
🔴 RATIONALE: Exponentiation (^) has higher precedence than multiplication (*) and addition
(+), so 2 ^ 2 is calculated first.
4. What is the result of the formula =ROUND(3.14159, 2)?
A. 3.14
B. 3.142
C. 3.1
D. 3
🟢 A. 3.14
🔴 RATIONALE: The ROUND function rounds a number to a specified number of digits; here,
3.14159 rounded to 2 decimal places is 3.14.
5. Which function counts only the cells that contain numbers in a given range?
, A. COUNTA
B. COUNTBLANK
C. COUNT
D. LEN
🟢 C. COUNT
🔴 RATIONALE: The COUNT function tallies only numeric values, whereas COUNTA includes all
non-blank cells.
6. What does the AVERAGE function return if applied to a range containing the values 10, 20,
blank, and text?
A. 15
B. 10
C. Error
D. 30
🟢 A. 15
🔴 RATIONALE: AVERAGE ignores blank cells and text, so it calculates (10 + 20) / 2 = 15.
7. Which function returns TRUE only if all its arguments are TRUE?
A. OR
B. NOT
C. XOR
D. AND
🟢 D. AND
🔴 RATIONALE: The AND function evaluates to TRUE only when every condition provided is
TRUE.
8. What is the output of =IF(5 > 3, "Yes", "No")?
A. FALSE
B. TRUE
C. Yes
D. No
