WALL STREET PREP: EXCEL CRASH COURSE EXAM – QUESTIONS AND
ANSWERS | VERIFIED AND WELL DETAILED ANSWERS | PLUS RATIONALES |
DOWNLOAD AND PASS | LATEST EXAM UPDATE 2026/2027
Core Domains
• Excel Fundamentals and Interface Navigation
• Data Management and Manipulation (Sorting, Filtering, Validation)
• Formula Construction and Logic (IF, VLOOKUP, INDEX/MATCH)
• Financial Functions (NPV, IRR, PMT, FV)
• PivotTables and Data Summarization
• Charting and Data Visualization
• Advanced Lookup and Reference Functions
• What-If Analysis and Scenarios (Goal Seek, Solver, Data Tables)
• Macros, VBA, and Automation Basics
• Excel Best Practices, Efficiency, and Error Handling
Introduction
This comprehensive examination is designed to rigorously assess your proficiency in
Microsoft Excel, specifically within the demanding context of financial analysis and
business decision-making as taught in the Wall Street Prep Excel Crash Course. The
exam evaluates both foundational theoretical knowledge and practical, applied
skills through a series of multiple-choice and scenario-based questions. You will be
tested on your ability to navigate the Excel interface, construct logical and financial
formulas, manipulate and summarize large datasets, create impactful
visualizations, and apply advanced analytical tools. The emphasis is on real-world
application, requiring you to not only know the functions but also to make critical
decisions about which tool is most efficient and appropriate for a given business
problem. Successful completion of this exam demonstrates a professional-level
competency essential for careers in investment banking, corporate finance, and
other analytical fields.
,════════════════════════════════════
SECTION ONE: QUESTIONS 1 – 50
Question 1
What is the default behavior in Excel when you double-click the fill handle (the
small square at the bottom-right corner of a selected cell) after entering a
formula in a column that is adjacent to a dataset?
A. It copies the formula down to the last row of the adjacent dataset, but only if
the formula is in the first row of the column.
B. It fills the formula down to the last used row in the adjacent column,
automatically adjusting relative cell references.
C. It opens the "Flash Fill" options to automatically detect a pattern and fill the
remaining cells.
D. It creates a new table from the selected range of data.
🟢 Correct Answer: B. It fills the formula down to the last used row in the
adjacent column, automatically adjusting relative cell references.
🔴 Explanation: The fill handle is a powerful time-saving tool. Double-clicking it
initiates a "fill down" operation that copies the formula down the column until it
reaches the last row of data in the adjacent column to the left. Critically, it adjusts
relative cell references (e.g., A1 becomes A2, A3, etc.), making it ideal for quickly
applying a calculation to an entire dataset.
Question 2
Which of the following keyboard shortcuts opens the "Go To" dialog box,
allowing you to quickly navigate to a specific cell or range?
A. Ctrl + G
B. Ctrl + F
,C. F5
D. Both A and C
🟢 Correct Answer: D. Both A and C
🔴 Explanation: The "Go To" dialog box is a powerful navigation tool in Excel. It
can be accessed using the keyboard shortcut Ctrl + G (Go To) or the function key
F5. This allows a user to quickly jump to a named range, a specific cell reference,
or select special cells like blanks or constants, saving significant time in large
worksheets.
Question 3
A financial analyst is trying to calculate the Net Present Value (NPV) of a series of
cash flows. The cash flows are in cells B2:B6 for years 0 through 4, and the
discount rate is in cell C1. Which formula is correctly structured to calculate the
NPV of this stream, assuming the initial investment is in B2?
A. =NPV(C1, B2:B6)
B. =NPV(C1, B3:B6) + B2
C. =NPV(C1, B2:B6) + B2
D. =NPV(C1, B3:B6) - B2
🟢 Correct Answer: B. =NPV(C1, B3:B6) + B2
🔴 Explanation: The NPV function in Excel assumes that the first cash flow in the
range occurs at the end of the first period. Therefore, to properly calculate the net
present value where the initial investment (outflow) occurs at Time 0, the initial
investment should be excluded from the NPV function's range and then added
back to the result. Thus, =NPV(C1, B3:B6) + B2 is correct. An initial investment in
B2 would be a negative number.
Question 4
, What is the primary purpose of the "Data Validation" feature in Excel?
A. To check for spelling and grammar errors within cells.
B. To restrict the type of data or the values that can be entered into a cell.
C. To automatically create a drop-down list based on a defined range.
D. To highlight duplicate values in a selected range.
🟢 Correct Answer: B. To restrict the type of data or the values that can be
entered into a cell.
🔴 Explanation: Data Validation is a crucial tool for controlling user input and
maintaining data integrity. It allows you to set rules for what data can be entered
into a cell, such as whole numbers, decimal values, dates, or a list of specific
items. While it can create a drop-down list (Option C), the overarching purpose is
to restrict entry to valid data types or values (Option B).
Question 5
In a PivotTable, what is the function of the "Report Filter" area?
A. It determines the columns of the PivotTable.
B. It defines the granularity of the row labels.
C. It allows you to filter the entire PivotTable based on a selected field, displaying
results for a subset of the data.
D. It is used to calculate the values displayed in the body of the PivotTable.
🟢 Correct Answer: C. It allows you to filter the entire PivotTable based on a
selected field, displaying results for a subset of the data.
🔴 Explanation: The Report Filter area is a powerful tool for controlling the overall
scope of a PivotTable. By dragging a field into this area, you create a drop-down
or filter at the top of the PivotTable that lets you view the report for all items or
for a specific item (or multiple items) within that field. This is different from Row
ANSWERS | VERIFIED AND WELL DETAILED ANSWERS | PLUS RATIONALES |
DOWNLOAD AND PASS | LATEST EXAM UPDATE 2026/2027
Core Domains
• Excel Fundamentals and Interface Navigation
• Data Management and Manipulation (Sorting, Filtering, Validation)
• Formula Construction and Logic (IF, VLOOKUP, INDEX/MATCH)
• Financial Functions (NPV, IRR, PMT, FV)
• PivotTables and Data Summarization
• Charting and Data Visualization
• Advanced Lookup and Reference Functions
• What-If Analysis and Scenarios (Goal Seek, Solver, Data Tables)
• Macros, VBA, and Automation Basics
• Excel Best Practices, Efficiency, and Error Handling
Introduction
This comprehensive examination is designed to rigorously assess your proficiency in
Microsoft Excel, specifically within the demanding context of financial analysis and
business decision-making as taught in the Wall Street Prep Excel Crash Course. The
exam evaluates both foundational theoretical knowledge and practical, applied
skills through a series of multiple-choice and scenario-based questions. You will be
tested on your ability to navigate the Excel interface, construct logical and financial
formulas, manipulate and summarize large datasets, create impactful
visualizations, and apply advanced analytical tools. The emphasis is on real-world
application, requiring you to not only know the functions but also to make critical
decisions about which tool is most efficient and appropriate for a given business
problem. Successful completion of this exam demonstrates a professional-level
competency essential for careers in investment banking, corporate finance, and
other analytical fields.
,════════════════════════════════════
SECTION ONE: QUESTIONS 1 – 50
Question 1
What is the default behavior in Excel when you double-click the fill handle (the
small square at the bottom-right corner of a selected cell) after entering a
formula in a column that is adjacent to a dataset?
A. It copies the formula down to the last row of the adjacent dataset, but only if
the formula is in the first row of the column.
B. It fills the formula down to the last used row in the adjacent column,
automatically adjusting relative cell references.
C. It opens the "Flash Fill" options to automatically detect a pattern and fill the
remaining cells.
D. It creates a new table from the selected range of data.
🟢 Correct Answer: B. It fills the formula down to the last used row in the
adjacent column, automatically adjusting relative cell references.
🔴 Explanation: The fill handle is a powerful time-saving tool. Double-clicking it
initiates a "fill down" operation that copies the formula down the column until it
reaches the last row of data in the adjacent column to the left. Critically, it adjusts
relative cell references (e.g., A1 becomes A2, A3, etc.), making it ideal for quickly
applying a calculation to an entire dataset.
Question 2
Which of the following keyboard shortcuts opens the "Go To" dialog box,
allowing you to quickly navigate to a specific cell or range?
A. Ctrl + G
B. Ctrl + F
,C. F5
D. Both A and C
🟢 Correct Answer: D. Both A and C
🔴 Explanation: The "Go To" dialog box is a powerful navigation tool in Excel. It
can be accessed using the keyboard shortcut Ctrl + G (Go To) or the function key
F5. This allows a user to quickly jump to a named range, a specific cell reference,
or select special cells like blanks or constants, saving significant time in large
worksheets.
Question 3
A financial analyst is trying to calculate the Net Present Value (NPV) of a series of
cash flows. The cash flows are in cells B2:B6 for years 0 through 4, and the
discount rate is in cell C1. Which formula is correctly structured to calculate the
NPV of this stream, assuming the initial investment is in B2?
A. =NPV(C1, B2:B6)
B. =NPV(C1, B3:B6) + B2
C. =NPV(C1, B2:B6) + B2
D. =NPV(C1, B3:B6) - B2
🟢 Correct Answer: B. =NPV(C1, B3:B6) + B2
🔴 Explanation: The NPV function in Excel assumes that the first cash flow in the
range occurs at the end of the first period. Therefore, to properly calculate the net
present value where the initial investment (outflow) occurs at Time 0, the initial
investment should be excluded from the NPV function's range and then added
back to the result. Thus, =NPV(C1, B3:B6) + B2 is correct. An initial investment in
B2 would be a negative number.
Question 4
, What is the primary purpose of the "Data Validation" feature in Excel?
A. To check for spelling and grammar errors within cells.
B. To restrict the type of data or the values that can be entered into a cell.
C. To automatically create a drop-down list based on a defined range.
D. To highlight duplicate values in a selected range.
🟢 Correct Answer: B. To restrict the type of data or the values that can be
entered into a cell.
🔴 Explanation: Data Validation is a crucial tool for controlling user input and
maintaining data integrity. It allows you to set rules for what data can be entered
into a cell, such as whole numbers, decimal values, dates, or a list of specific
items. While it can create a drop-down list (Option C), the overarching purpose is
to restrict entry to valid data types or values (Option B).
Question 5
In a PivotTable, what is the function of the "Report Filter" area?
A. It determines the columns of the PivotTable.
B. It defines the granularity of the row labels.
C. It allows you to filter the entire PivotTable based on a selected field, displaying
results for a subset of the data.
D. It is used to calculate the values displayed in the body of the PivotTable.
🟢 Correct Answer: C. It allows you to filter the entire PivotTable based on a
selected field, displaying results for a subset of the data.
🔴 Explanation: The Report Filter area is a powerful tool for controlling the overall
scope of a PivotTable. By dragging a field into this area, you create a drop-down
or filter at the top of the PivotTable that lets you view the report for all items or
for a specific item (or multiple items) within that field. This is different from Row
