13/01/2025 Completed Exam | Wall Street
14:13 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.
messages.downloaded_
,13/01/2025 Completed Exam | Wall Street
14:13 Prep
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
https://www.wallstreetprep.com/co
mpleted-exam/? 1/14
wsp_selection=9434&course_id=3843
messages.downloaded_
, 13/01/2025 Completed Exam | Wall Street
14:13 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
messages.downloaded_
14:13 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.
messages.downloaded_
,13/01/2025 Completed Exam | Wall Street
14:13 Prep
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
https://www.wallstreetprep.com/co
mpleted-exam/? 1/14
wsp_selection=9434&course_id=3843
messages.downloaded_
, 13/01/2025 Completed Exam | Wall Street
14:13 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
messages.downloaded_
