WALL STREET PREP: EXCEL CRASH COURSE RETAKE
EXAM 100% A+ ANSWER SHEET & PRACTICE EXAM
80+ Questions | Latest 2026 Version | Verified
Answers & Rationales
PART 1: FORMULAS & FUNCTIONS (Questions 1-45)
Format: Definition, Correct Answer, and Application Rationale.
1. Average Function
Answer: An Excel function that adds a group of values, and then divides the result by the number of
values in the group.
Rationale: This is the fundamental definition of =AVERAGE(). It differs from MEDIAN as it calculates the
arithmetic mean.
2. IF Statement Function
Answer: A function that returns one value when a condition you specify evaluates to true and a
different value if it evaluates to false.
Rationale: The structure is =IF(Logical_Test, [Value_if_True], [Value_if_False]). Essential for creating
binary logic in financial models (e.g., if EBITDA is positive, pay bonus, else 0).
3. Nested IF Statement Function
Answer: An IF function with various IF functions written within each other.
Rationale: Used for evaluating multiple conditions sequentially. However, modern best practice often
suggests replacing deep nesting with IFS or XLOOKUP.
4. IFS Function
Answer: A function that resolves the "chunkiness" of nested IF statements by allowing for multiple
conditions in a single function.
Rationale: Structure: =IFS(Condition1, Value1, Condition2, Value2,...). Easier to read than nested IFs.
, 5. IFERROR Function
Answer: A function that returns a value you specify if the formula evaluates to an error; otherwise, it
returns the result of the formula.
Rationale: Crucial for cleaning up models to prevent #DIV/0! or #N/A from breaking downstream
calculations.
6. & (Ampersand) Function
Answer: A function that concatenates (joins) cells with a text string.
Rationale: Example: =A1 & " " & B1 joins the value of A1 and B1 with a space.
7. EOMONTH Function
Answer: A function that outputs the last day of the month based on a specified start date and number
of months.
Rationale: Syntax: =EOMONTH(Start_Date, Months). Essential for creating dynamic date headers in
monthly forecasting models .
8. EDATE Function
Answer: Similar to EOMONTH, but returns the exact same day number from the start date, after the
specified number of months.
Rationale: Useful for calculating maturity dates or anniversary dates.
9. ISNUMBER Function
Answer: A function that tests if a cell contains a number, returning TRUE or FALSE.
Rationale: Often used within an IF statement to validate data before performing a calculation.
10. ISTEXT Function
Answer: A function that evaluates if there is text inside a cell, outputting TRUE or FALSE.
Rationale: Useful for data cleansing and ensuring lookup values are formatted correctly.
11. YEARFRAC Function
Answer: A function that returns the proportion of the year between two given dates.
Rationale: Syntax includes an optional basis (e.g., 0 for US 30/360, 1 for Actual/Actual). Critical for
calculating accurate depreciation or interest accruals .
12. DATE Function
Answer: A function that combines distinct year, month, and day elements into a single date serial
number.
Rationale: Prevents broken links when date components are sourced from different cells.
13. DAY Function
Answer: Returns the day portion of a date (a number between 1 and 31).
Rationale: Extracts the day from a serial date number.
EXAM 100% A+ ANSWER SHEET & PRACTICE EXAM
80+ Questions | Latest 2026 Version | Verified
Answers & Rationales
PART 1: FORMULAS & FUNCTIONS (Questions 1-45)
Format: Definition, Correct Answer, and Application Rationale.
1. Average Function
Answer: An Excel function that adds a group of values, and then divides the result by the number of
values in the group.
Rationale: This is the fundamental definition of =AVERAGE(). It differs from MEDIAN as it calculates the
arithmetic mean.
2. IF Statement Function
Answer: A function that returns one value when a condition you specify evaluates to true and a
different value if it evaluates to false.
Rationale: The structure is =IF(Logical_Test, [Value_if_True], [Value_if_False]). Essential for creating
binary logic in financial models (e.g., if EBITDA is positive, pay bonus, else 0).
3. Nested IF Statement Function
Answer: An IF function with various IF functions written within each other.
Rationale: Used for evaluating multiple conditions sequentially. However, modern best practice often
suggests replacing deep nesting with IFS or XLOOKUP.
4. IFS Function
Answer: A function that resolves the "chunkiness" of nested IF statements by allowing for multiple
conditions in a single function.
Rationale: Structure: =IFS(Condition1, Value1, Condition2, Value2,...). Easier to read than nested IFs.
, 5. IFERROR Function
Answer: A function that returns a value you specify if the formula evaluates to an error; otherwise, it
returns the result of the formula.
Rationale: Crucial for cleaning up models to prevent #DIV/0! or #N/A from breaking downstream
calculations.
6. & (Ampersand) Function
Answer: A function that concatenates (joins) cells with a text string.
Rationale: Example: =A1 & " " & B1 joins the value of A1 and B1 with a space.
7. EOMONTH Function
Answer: A function that outputs the last day of the month based on a specified start date and number
of months.
Rationale: Syntax: =EOMONTH(Start_Date, Months). Essential for creating dynamic date headers in
monthly forecasting models .
8. EDATE Function
Answer: Similar to EOMONTH, but returns the exact same day number from the start date, after the
specified number of months.
Rationale: Useful for calculating maturity dates or anniversary dates.
9. ISNUMBER Function
Answer: A function that tests if a cell contains a number, returning TRUE or FALSE.
Rationale: Often used within an IF statement to validate data before performing a calculation.
10. ISTEXT Function
Answer: A function that evaluates if there is text inside a cell, outputting TRUE or FALSE.
Rationale: Useful for data cleansing and ensuring lookup values are formatted correctly.
11. YEARFRAC Function
Answer: A function that returns the proportion of the year between two given dates.
Rationale: Syntax includes an optional basis (e.g., 0 for US 30/360, 1 for Actual/Actual). Critical for
calculating accurate depreciation or interest accruals .
12. DATE Function
Answer: A function that combines distinct year, month, and day elements into a single date serial
number.
Rationale: Prevents broken links when date components are sourced from different cells.
13. DAY Function
Answer: Returns the day portion of a date (a number between 1 and 31).
Rationale: Extracts the day from a serial date number.
