WALL STREET PREP: EXCEL CRASH COURSE FORMULAS EXPLAINED QUESTIONS AND ANSWERS ALREADY
GRADED A+. 100% Verified Solutions | Updated Per Latest Guidelines | Graded A+
Core Domains
Keyboard Shortcuts & Productivity
Logical & Conditional Functions (IF, IFS, IFERROR, AND, OR, Nested IF)
Lookup & Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, OFFSET, INDIRECT)
Date & Time Functions (EDATE, EOMONTH, YEARFRAC, DATE, DAY, MONTH, YEAR)
Mathematical & Aggregation Functions (SUM, SUMIF, SUMIFS, AVERAGEIF, MIN, MAX, ABS, CEILING, FLOOR,
SUMPRODUCT)
Financial Functions (PV, FV, NPV, XNPV, IRR, XIRR, GOAL SEEK)
Data Analysis & Table Features (Pivot Tables, Data Tables, Sensitivity Analysis, Scenario Analysis)
Advanced Techniques & Efficiency (Dynamic Referencing, Macro-Based Shortcuts, Forms & Toggles)
This comprehensive assessment evaluates the foundational Excel knowledge and professional competencies
required for successful completion of the Wall Street Prep Excel Crash Course examination. The assessment tests
understanding of essential Excel formulas, keyboard shortcuts, financial modeling functions, data analysis
techniques, and productivity tools used in investment banking, corporate finance, and accounting. Questions are
presented in a multiple-choice format with scenario-based elements that emphasize real-world application,
,financial modeling best practices, and professional efficiency standards. This guide prepares candidates for
certification by testing both theoretical knowledge and practical judgment essential for finance professionals.
SECTION ONE
Questions 1–100
Question 1
What is the keyboard shortcut to open the Open File dialog box in Excel?
A. Ctrl + N
B. Ctrl + O
C. Ctrl + F12
D. Both B and C
🟢 Correct Answer:
D. Both B and C
🔴 RATIONALE:
,Both Ctrl + O and Ctrl + F12 open the Open File dialog box in Excel. Ctrl + N creates a new workbook, not open
an existing one. Knowing multiple shortcut options for common tasks improves workflow efficiency in financial
modeling environments.
Question 2
Which workbook calculation setting is recommended for Excel in a financial modeling environment?
A. Manual
B. Automatic
C. Automatic Except for Data Tables
D. Manual Except for Data Tables
🟢 Correct Answer:
C. Automatic Except for Data Tables
🔴 RATIONALE:
The recommended setting for financial modeling is "Automatic Except for Data Tables." This setting ensures that
all formulas recalculate automatically except for data tables, which can slow down workbook performance.
Manual calculation is generally not recommended as it increases the risk of outdated calculations.
, Question 3
What is the keyboard shortcut to open the Format Cells dialog box?
A. Ctrl + F
B. Ctrl + Shift + F
C. Ctrl + 1
D. Alt + Enter
🟢 Correct Answer:
C. Ctrl + 1
🔴 RATIONALE:
Ctrl + 1 is the keyboard shortcut to open the Format Cells dialog box in Excel. Ctrl + F opens the Find dialog,
Ctrl + Shift + F opens the Font tab of Format Cells, and Alt + Enter inserts a line break within a cell. Mastering
Ctrl + 1 is essential for efficient cell formatting in financial models.
Question 4
What is the keyboard shortcut to freeze panes within a worksheet?
A. Alt + W + F + F
B. Alt + W + S
GRADED A+. 100% Verified Solutions | Updated Per Latest Guidelines | Graded A+
Core Domains
Keyboard Shortcuts & Productivity
Logical & Conditional Functions (IF, IFS, IFERROR, AND, OR, Nested IF)
Lookup & Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, OFFSET, INDIRECT)
Date & Time Functions (EDATE, EOMONTH, YEARFRAC, DATE, DAY, MONTH, YEAR)
Mathematical & Aggregation Functions (SUM, SUMIF, SUMIFS, AVERAGEIF, MIN, MAX, ABS, CEILING, FLOOR,
SUMPRODUCT)
Financial Functions (PV, FV, NPV, XNPV, IRR, XIRR, GOAL SEEK)
Data Analysis & Table Features (Pivot Tables, Data Tables, Sensitivity Analysis, Scenario Analysis)
Advanced Techniques & Efficiency (Dynamic Referencing, Macro-Based Shortcuts, Forms & Toggles)
This comprehensive assessment evaluates the foundational Excel knowledge and professional competencies
required for successful completion of the Wall Street Prep Excel Crash Course examination. The assessment tests
understanding of essential Excel formulas, keyboard shortcuts, financial modeling functions, data analysis
techniques, and productivity tools used in investment banking, corporate finance, and accounting. Questions are
presented in a multiple-choice format with scenario-based elements that emphasize real-world application,
,financial modeling best practices, and professional efficiency standards. This guide prepares candidates for
certification by testing both theoretical knowledge and practical judgment essential for finance professionals.
SECTION ONE
Questions 1–100
Question 1
What is the keyboard shortcut to open the Open File dialog box in Excel?
A. Ctrl + N
B. Ctrl + O
C. Ctrl + F12
D. Both B and C
🟢 Correct Answer:
D. Both B and C
🔴 RATIONALE:
,Both Ctrl + O and Ctrl + F12 open the Open File dialog box in Excel. Ctrl + N creates a new workbook, not open
an existing one. Knowing multiple shortcut options for common tasks improves workflow efficiency in financial
modeling environments.
Question 2
Which workbook calculation setting is recommended for Excel in a financial modeling environment?
A. Manual
B. Automatic
C. Automatic Except for Data Tables
D. Manual Except for Data Tables
🟢 Correct Answer:
C. Automatic Except for Data Tables
🔴 RATIONALE:
The recommended setting for financial modeling is "Automatic Except for Data Tables." This setting ensures that
all formulas recalculate automatically except for data tables, which can slow down workbook performance.
Manual calculation is generally not recommended as it increases the risk of outdated calculations.
, Question 3
What is the keyboard shortcut to open the Format Cells dialog box?
A. Ctrl + F
B. Ctrl + Shift + F
C. Ctrl + 1
D. Alt + Enter
🟢 Correct Answer:
C. Ctrl + 1
🔴 RATIONALE:
Ctrl + 1 is the keyboard shortcut to open the Format Cells dialog box in Excel. Ctrl + F opens the Find dialog,
Ctrl + Shift + F opens the Font tab of Format Cells, and Alt + Enter inserts a line break within a cell. Mastering
Ctrl + 1 is essential for efficient cell formatting in financial models.
Question 4
What is the keyboard shortcut to freeze panes within a worksheet?
A. Alt + W + F + F
B. Alt + W + S
