EXCEL
100% A+ ANSWER SHEET - WALL STREET
PREP EXCEL CRASH COURSE RETAKE EXAM
ANSWER SHEET 48/48 **2024/2025**
📝 Exam Instructions & Formatting Guidelines
Section 1 – Based on Tab: Q1-4
Before answering, complete the model by filling in the required blank
cells in the workbook.
Answer format guidelines:
Round answers to the nearest whole number
Use commas to separate thousands
Do not use currency symbols (e.g., write 5,505,210 instead of
$5,505,210.50)
🔍 Section 1 Questions (Q1–Q4)
1. What is the forecast Revenue in 2017?
Answer: 13,642,021
2. What is the forecast Net Income in 2016?
Answer: 925,777
3. If Depreciation & Amortization as a % of Capital
Expenditures is changed to 30%, what is the Net Income in
2017?
Answer: 1,123,438
4. What is the EBITDA % Margin in 2018?
Answer: 17.1%
📊 Section 2 – Based on Tab: Q5–19
, EXCEL
For best results, use a Pivot Table to analyze the data. Adding extra
calculation columns may also help.
Answer format:
Round numerical data to the nearest 1 decimal place
Use commas to separate thousands
Do not include currency symbols
🔍 Section 2 Questions (Q5–Q19)
6. In the previous question, you identified the salesperson with
the highest cumulative quantity sold of a single item. What is
the item code of that item?
Answer provided in workbook.
7. What was the total profit for the postal code with the highest
profit in March?
Answer: 13,691.4
8. Which postal code bought the most quantity of item 13 in
April?
Answer: 93,558
9. How many units of item 13 were purchased by that postal code
in April?
Answer: 24
10. What is the total of Amy Adam’s sales during the analysis
period?
Answer: 492,153.8
11. What was Amy Adam’s total profit during the same
period?
Answer: 255,548.1
12. How many units of item 23 were sold while Fred Rubble
was the manager (January–March)?
Answer: 784
100% A+ ANSWER SHEET - WALL STREET
PREP EXCEL CRASH COURSE RETAKE EXAM
ANSWER SHEET 48/48 **2024/2025**
📝 Exam Instructions & Formatting Guidelines
Section 1 – Based on Tab: Q1-4
Before answering, complete the model by filling in the required blank
cells in the workbook.
Answer format guidelines:
Round answers to the nearest whole number
Use commas to separate thousands
Do not use currency symbols (e.g., write 5,505,210 instead of
$5,505,210.50)
🔍 Section 1 Questions (Q1–Q4)
1. What is the forecast Revenue in 2017?
Answer: 13,642,021
2. What is the forecast Net Income in 2016?
Answer: 925,777
3. If Depreciation & Amortization as a % of Capital
Expenditures is changed to 30%, what is the Net Income in
2017?
Answer: 1,123,438
4. What is the EBITDA % Margin in 2018?
Answer: 17.1%
📊 Section 2 – Based on Tab: Q5–19
, EXCEL
For best results, use a Pivot Table to analyze the data. Adding extra
calculation columns may also help.
Answer format:
Round numerical data to the nearest 1 decimal place
Use commas to separate thousands
Do not include currency symbols
🔍 Section 2 Questions (Q5–Q19)
6. In the previous question, you identified the salesperson with
the highest cumulative quantity sold of a single item. What is
the item code of that item?
Answer provided in workbook.
7. What was the total profit for the postal code with the highest
profit in March?
Answer: 13,691.4
8. Which postal code bought the most quantity of item 13 in
April?
Answer: 93,558
9. How many units of item 13 were purchased by that postal code
in April?
Answer: 24
10. What is the total of Amy Adam’s sales during the analysis
period?
Answer: 492,153.8
11. What was Amy Adam’s total profit during the same
period?
Answer: 255,548.1
12. How many units of item 23 were sold while Fred Rubble
was the manager (January–March)?
Answer: 784
