Wall Street Prep Excel Crash Course Exam 2025 | 200+ High-Yield
Practice Questions with Answers & Rationales | Verified Q&A for
Spreadsheet, Formula, Chart, and Function Mastery | Ideal for
Investment Banking & Financial Modeling
QUESTION 1
Which function calculates the Internal Rate of Return for a series of cash flows?
A) NPV
B) PMT
C) IRR (correct)
D) FV
Rationale: The IRR function is specifically designed to calculate the internal rate of
return for a series of cash flows.
QUESTION 2
What does the VLOOKUP function do?
A) Looks up a value vertically in a table and returns a corresponding value.
B) Looks up a value vertically in a table and returns a value from another column.
(correct)
C) Calculates the present value of cash flows.
D) Searches for a value horizontally in a table.
Rationale: VLOOKUP is used to search for a value in the first column of a table and
return a value from a specified column in the same row.
QUESTION 3
How can you handle errors in a formula?
A) Use IF
B) Use VLOOKUP
C) Use MATCH
D) Use IFERROR (correct)
Rationale: IFERROR is designed to catch and handle errors in formulas, allowing you to
specify a return value if an error occurs.
QUESTION 4
What is the purpose of a PivotTable?
A) To create charts
B) To summarize and analyze large datasets (correct)
,C) To perform calculations
D) To format cells
Rationale: PivotTables are specifically used to summarize and analyze large datasets.
QUESTION 5
Which function would you use to calculate loan payments?
A) NPV
B) PMT (correct)
C) IRR
D) FV
Rationale: The PMT function calculates the amount of loan payments based on
constant payments and a constant interest rate.
QUESTION 6
What does nesting functions in Excel allow you to do?
A) Increase file size
B) Perform more complex calculations (correct)
C) Create charts
D) Sort data
Rationale: Nesting functions allows for the combination of multiple functions to
perform more complex calculations.
QUESTION 7
What does the INDEX function return?
A) The position of a value in a range
B) A logical test result
C) A calculated value
D) A value from a specified position in a range (correct)
Rationale: The INDEX function returns a value from a specified position in a range.
QUESTION 8
What is the purpose of the MATCH function?
A) To return a value from a specified position
B) To find the position of a value in a range (correct)
,C) To calculate a loan payment
D) To concatenate text
Rationale: The MATCH function is used to find the relative position of a value in a range,
making option B the correct choice.
QUESTION 9
Which tool would you use to create a summary report from a large dataset?
A) Charts
B) Data Validation
C) PivotTable (correct)
D) Conditional Formatting
Rationale: PivotTables are specifically designed for summarizing and analyzing large
datasets, so option C is correct.
QUESTION 10
What function would you use to create a dynamic range of data for a dropdown list?
A) IF
B) VLOOKUP
C) Data Validation (correct)
D) CONCATENATE
Rationale: Data Validation is used to create dropdown lists and enforce data entry
rules, making option C the correct answer.
QUESTION 11
Which function can be used to combine text from different cells?
A) IF
B) VLOOKUP
C) MID
D) CONCATENATE (correct)
Rationale: The CONCATENATE function (or the & operator) is used to join text from
different cells into a single cell.
QUESTION 12
What does the Solver tool in Excel do?
, A) Creates charts
B) Validates data
C) Generates random numbers
D) Finds an optimal solution for a formula (correct)
Rationale: The Solver tool is used to find the optimal value for a formula in a cell,
subject to constraints on other cells.
QUESTION 13
Which of the following is a benefit of using named ranges?
A) Increases file size
B) Makes formulas more complex
C) Improves formula readability (correct)
D) Limits data entry
Rationale: Named ranges make formulas easier to read and understand, improving
overall clarity, thus option C is correct.
QUESTION 14
What does the function =SUM(A1:A10) do?
A) Counts the number of cells
B) Finds the average of values
C) Adds all the values in the range A1 to A10 (correct)
D) Returns the maximum value
Rationale: The SUM function adds all the values in the specified range, making option C
correct.
QUESTION 15
Which feature allows you to visually highlight important data?
A) Filtering
B) Conditional Formatting (correct)
C) Sorting
D) Data Validation
Rationale: Conditional Formatting allows you to apply formatting to cells based on
certain criteria, making option B the correct answer.
QUESTION 16
What does the function =AVERAGE(B1:B10) calculate?
Practice Questions with Answers & Rationales | Verified Q&A for
Spreadsheet, Formula, Chart, and Function Mastery | Ideal for
Investment Banking & Financial Modeling
QUESTION 1
Which function calculates the Internal Rate of Return for a series of cash flows?
A) NPV
B) PMT
C) IRR (correct)
D) FV
Rationale: The IRR function is specifically designed to calculate the internal rate of
return for a series of cash flows.
QUESTION 2
What does the VLOOKUP function do?
A) Looks up a value vertically in a table and returns a corresponding value.
B) Looks up a value vertically in a table and returns a value from another column.
(correct)
C) Calculates the present value of cash flows.
D) Searches for a value horizontally in a table.
Rationale: VLOOKUP is used to search for a value in the first column of a table and
return a value from a specified column in the same row.
QUESTION 3
How can you handle errors in a formula?
A) Use IF
B) Use VLOOKUP
C) Use MATCH
D) Use IFERROR (correct)
Rationale: IFERROR is designed to catch and handle errors in formulas, allowing you to
specify a return value if an error occurs.
QUESTION 4
What is the purpose of a PivotTable?
A) To create charts
B) To summarize and analyze large datasets (correct)
,C) To perform calculations
D) To format cells
Rationale: PivotTables are specifically used to summarize and analyze large datasets.
QUESTION 5
Which function would you use to calculate loan payments?
A) NPV
B) PMT (correct)
C) IRR
D) FV
Rationale: The PMT function calculates the amount of loan payments based on
constant payments and a constant interest rate.
QUESTION 6
What does nesting functions in Excel allow you to do?
A) Increase file size
B) Perform more complex calculations (correct)
C) Create charts
D) Sort data
Rationale: Nesting functions allows for the combination of multiple functions to
perform more complex calculations.
QUESTION 7
What does the INDEX function return?
A) The position of a value in a range
B) A logical test result
C) A calculated value
D) A value from a specified position in a range (correct)
Rationale: The INDEX function returns a value from a specified position in a range.
QUESTION 8
What is the purpose of the MATCH function?
A) To return a value from a specified position
B) To find the position of a value in a range (correct)
,C) To calculate a loan payment
D) To concatenate text
Rationale: The MATCH function is used to find the relative position of a value in a range,
making option B the correct choice.
QUESTION 9
Which tool would you use to create a summary report from a large dataset?
A) Charts
B) Data Validation
C) PivotTable (correct)
D) Conditional Formatting
Rationale: PivotTables are specifically designed for summarizing and analyzing large
datasets, so option C is correct.
QUESTION 10
What function would you use to create a dynamic range of data for a dropdown list?
A) IF
B) VLOOKUP
C) Data Validation (correct)
D) CONCATENATE
Rationale: Data Validation is used to create dropdown lists and enforce data entry
rules, making option C the correct answer.
QUESTION 11
Which function can be used to combine text from different cells?
A) IF
B) VLOOKUP
C) MID
D) CONCATENATE (correct)
Rationale: The CONCATENATE function (or the & operator) is used to join text from
different cells into a single cell.
QUESTION 12
What does the Solver tool in Excel do?
, A) Creates charts
B) Validates data
C) Generates random numbers
D) Finds an optimal solution for a formula (correct)
Rationale: The Solver tool is used to find the optimal value for a formula in a cell,
subject to constraints on other cells.
QUESTION 13
Which of the following is a benefit of using named ranges?
A) Increases file size
B) Makes formulas more complex
C) Improves formula readability (correct)
D) Limits data entry
Rationale: Named ranges make formulas easier to read and understand, improving
overall clarity, thus option C is correct.
QUESTION 14
What does the function =SUM(A1:A10) do?
A) Counts the number of cells
B) Finds the average of values
C) Adds all the values in the range A1 to A10 (correct)
D) Returns the maximum value
Rationale: The SUM function adds all the values in the specified range, making option C
correct.
QUESTION 15
Which feature allows you to visually highlight important data?
A) Filtering
B) Conditional Formatting (correct)
C) Sorting
D) Data Validation
Rationale: Conditional Formatting allows you to apply formatting to cells based on
certain criteria, making option B the correct answer.
QUESTION 16
What does the function =AVERAGE(B1:B10) calculate?
