EXCEL Crash Course Exam
2026 Latest Version | Wall Street Prep (WSP)
Excel Crash Course Questions & Answers |
Verified Study Guide | Complete Exam Prep
THIS EXAM INCLUDES:
• Latest WSP Excel Crash Course practice questions
• Verified answers with explanations
• Excel formulas and functions
• Lookup functions (VLOOKUP, XLOOKUP, INDEX-MATCH)
• IF, SUMIF, COUNTIF, and logical functions
• Financial modeling fundamentals
• Data analysis techniques
• Charts and visualization
• Spreadsheet formatting best practices
• Exam preparation tips
• Comprehensive review for the 2026 WSP Excel Crash Course
, Back to Course | Exit to Learning Dashboard
Review: Excel Crash Course Exam
Question 1
Instructions: For questions 1-5, use tab Q1-5 in the Exam Workbook. Complete the financial model using the assumptions
provided by filling in the blank cells highlighted in yellow. All dollar amounts (except price and cost per unit) should be rounded
to the nearest whole number, with commas separating 000s and no currency format. For example, if the answer is $1,234.567,
you would input 1,235. All percentages should be expressed with one decimal point.
What is forecasted revenue in Year 5?
95,412
124,950
151,252
161,197
Question 2
Instructions: See question 1.
What is forecasted gross profit as a % of revenue in Year 5?
59.2%
59.4%
60.0%
62.3%
Question 3
Instructions: See question 1.
What is Gross Profit in Year 5?
48,458
61,502
74,950
95,412
Question 4
Instructions: See question 1.
What is forecasted net income in Year 5?
36,119
38,052
40,770
54,360
Question 5
Instructions: See question 1.
What would forecasted net income in Year 5 be if the effective tax rate was changed to 30% for all years?
36,119
38,052
messages.downloaded_by
2026 Latest Version | Wall Street Prep (WSP)
Excel Crash Course Questions & Answers |
Verified Study Guide | Complete Exam Prep
THIS EXAM INCLUDES:
• Latest WSP Excel Crash Course practice questions
• Verified answers with explanations
• Excel formulas and functions
• Lookup functions (VLOOKUP, XLOOKUP, INDEX-MATCH)
• IF, SUMIF, COUNTIF, and logical functions
• Financial modeling fundamentals
• Data analysis techniques
• Charts and visualization
• Spreadsheet formatting best practices
• Exam preparation tips
• Comprehensive review for the 2026 WSP Excel Crash Course
, Back to Course | Exit to Learning Dashboard
Review: Excel Crash Course Exam
Question 1
Instructions: For questions 1-5, use tab Q1-5 in the Exam Workbook. Complete the financial model using the assumptions
provided by filling in the blank cells highlighted in yellow. All dollar amounts (except price and cost per unit) should be rounded
to the nearest whole number, with commas separating 000s and no currency format. For example, if the answer is $1,234.567,
you would input 1,235. All percentages should be expressed with one decimal point.
What is forecasted revenue in Year 5?
95,412
124,950
151,252
161,197
Question 2
Instructions: See question 1.
What is forecasted gross profit as a % of revenue in Year 5?
59.2%
59.4%
60.0%
62.3%
Question 3
Instructions: See question 1.
What is Gross Profit in Year 5?
48,458
61,502
74,950
95,412
Question 4
Instructions: See question 1.
What is forecasted net income in Year 5?
36,119
38,052
40,770
54,360
Question 5
Instructions: See question 1.
What would forecasted net income in Year 5 be if the effective tax rate was changed to 30% for all years?
36,119
38,052
messages.downloaded_by
