100% A+ ANSWER SHEET - WALL STREET PREP EXCEL CRASH
COURSE RETAKE EXAM ANSWER SHEET 48/48 **2025**
Return 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
40,770
54,360
Question 6
Instructions: Questions 6-15 use the data on tab Q6-15 in the Exam Workbook. We recommend you analyze this data with the aid of a pivot table. You may also benefit from adding additional calculation
columns to the dataset.
Which product generated the highest total sales from January – March 2023?
Question 7
Instructions: See question 6
Which sales rep generated the highest total sales from January – March 2023?
https://www.wallstreetprep.com/completed-exam/?wsp_selection=U434&assigned=true Page 1 of 12
, 100% A+ ANSWER SHEET - WALL STREET PREP EXCEL CRASH
COURSE RETAKE EXAM ANSWER SHEET 48/48 **2025**
Question 8
https://www.wallstreetprep.com/completed-exam/?wsp_selection=U434&assigned=true Page 2 of 12
COURSE RETAKE EXAM ANSWER SHEET 48/48 **2025**
Return 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
40,770
54,360
Question 6
Instructions: Questions 6-15 use the data on tab Q6-15 in the Exam Workbook. We recommend you analyze this data with the aid of a pivot table. You may also benefit from adding additional calculation
columns to the dataset.
Which product generated the highest total sales from January – March 2023?
Question 7
Instructions: See question 6
Which sales rep generated the highest total sales from January – March 2023?
https://www.wallstreetprep.com/completed-exam/?wsp_selection=U434&assigned=true Page 1 of 12
, 100% A+ ANSWER SHEET - WALL STREET PREP EXCEL CRASH
COURSE RETAKE EXAM ANSWER SHEET 48/48 **2025**
Question 8
https://www.wallstreetprep.com/completed-exam/?wsp_selection=U434&assigned=true Page 2 of 12
