13/01/2025 14:13 Completed Exam | Wall Street Prep
Excel Crash Course Exam Questions and
Answers With Verified Solutions and Study Guide
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
messages.downloaded_by
,13/01/2025 14:13 Completed Exam | Wall Street Prep
38,052
https://www.wallstreetprep.com/co mpleted-exam/?wsp_selection=9434&course_id=3843 1/14
messages.downloaded_by
, 13/01/2025 14:13 Completed Exam | Wall Street Prep
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?
Question 8
Instructions: See question 6
Which sales rep generated the lowest total sales in January 2023?
Question 9
Instructions: See question 6
Which product generated the highest total sales for Donna from January — March 2023?
Question 10
Instructions: See question 6
Which sales rep generated the highest total sales from Product 5 from January — March 2023?
Question 11
Instructions: See question 6
Which sales rep generated zero sales from Product 12 from January — March 2023?
Question 12
Instructions: See question 6
Which product generated the third highest quantity of products sold from January — March 2023?
Question 13
Instructions: See question 6
Which product generated the highest average price per unit from January — March 2023?
Question 14
https://www.wallstreetprep.com/completed-exam/?wsp_selection=9434&course_id=3843 2/14
messages.downloaded_by
Excel Crash Course Exam Questions and
Answers With Verified Solutions and Study Guide
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
messages.downloaded_by
,13/01/2025 14:13 Completed Exam | Wall Street Prep
38,052
https://www.wallstreetprep.com/co mpleted-exam/?wsp_selection=9434&course_id=3843 1/14
messages.downloaded_by
, 13/01/2025 14:13 Completed Exam | Wall Street Prep
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?
Question 8
Instructions: See question 6
Which sales rep generated the lowest total sales in January 2023?
Question 9
Instructions: See question 6
Which product generated the highest total sales for Donna from January — March 2023?
Question 10
Instructions: See question 6
Which sales rep generated the highest total sales from Product 5 from January — March 2023?
Question 11
Instructions: See question 6
Which sales rep generated zero sales from Product 12 from January — March 2023?
Question 12
Instructions: See question 6
Which product generated the third highest quantity of products sold from January — March 2023?
Question 13
Instructions: See question 6
Which product generated the highest average price per unit from January — March 2023?
Question 14
https://www.wallstreetprep.com/completed-exam/?wsp_selection=9434&course_id=3843 2/14
messages.downloaded_by
