Question 33
Instructions: See Question 32.
Enter the number of items and total cost for class “Computers.” Enter your answer as the number of items
followed by total cost, comma separated with no spaces. For example: 10,$200,000
Question 34
Instructions: See Question 32.
Enter the number of items and total cost for class “Equipment.” Enter your answer as the number of items
followed by total cost, comma separated with no spaces. For example: 10,$200,000
Question 35
Instructions: See Question 32.
Enter the number of items and total cost for class “Tools.” Enter your answer as the number of items followed
by total cost, comma separated with no spaces. For example: 10,$200,000
,12/3/2020 Completed Exam | Wall Street Prep - Wall Street Prep
Question 36
Instructions: See Question 32.
Enter the number of items and total cost for class “Vehicles.” Enter your answer as the number of items
followed by total cost, comma separated with no spaces. For example: 10,$200,000
Question 37
A B C D
1 2015 2016 2017
2 Revenue 100 120 130
3 Expenses 34 55 75
4 Profit 66 65 55
5
6 User input Revenue
7 User input 2015
Identify the formula that outputs data from the table based on the user inputs in cells C6 and C7.
=OFFSET(A1,MATCH(C7,A2:A4),MATCH(C8,B1:D1))
=OFFSET(B1,MATCH(C6,A2:A4,0),MATCH(C7,B1:D1))
=OFFSET(A1,MATCH(C6,A2:A4,0),MATCH(C7,B1:D1))
=OFFSET(A1,MATCH(C8,B1:D1),MATCH(C7,A2:A4,0))
Question 38
1/10
, 12/3/2020 Completed Exam | Wall Street Prep - Wall Street Prep
Questions 38-39 use the fact pattern on tab Q38-39 in the Exam Workbook. You will enter a function for the
answer below. Start your formula with the = sign. Do not anchor cell references, i.e. there should be no dollar
signs (“$”) in your answer.
Write an HLOOKUP function that will output the correct Net Profit for whichever date is selected in cell H11. For
your answer to be scored correctly, please using C5:H8 as your table array and a hard coded number for the row
index number.
Review: Excel Crash Course Exam (Online)
Question 1
Instructions: Questions 1-4 use the financial model on tab Q1-4 in the Exam Workbook. Complete the model by
filling in the blank cells before answering the question below. Answers should be rounded to the nearest whole
number, comma separating 000s, NOT written in currency format. So if the answer is $5,505,210.50, you would
input 5,505,210. What is forecast Revenue in 2017?
Question 2
Instructions: See question 1.
What is forecast Net Income in 2016?
Question 3
Instructions: See question 1.
If Depreciation&Amortization as a % of Capital Expenditures is changed to 30%, what is Net Income in 2017?
Question 4
Instructions: See question 1. Format your answer to this question as a percentage, rounded to one decimal place.
So if your answer is 10.25%, you would input: 10.3% (include percentage sign).
2/10
Instructions: See Question 32.
Enter the number of items and total cost for class “Computers.” Enter your answer as the number of items
followed by total cost, comma separated with no spaces. For example: 10,$200,000
Question 34
Instructions: See Question 32.
Enter the number of items and total cost for class “Equipment.” Enter your answer as the number of items
followed by total cost, comma separated with no spaces. For example: 10,$200,000
Question 35
Instructions: See Question 32.
Enter the number of items and total cost for class “Tools.” Enter your answer as the number of items followed
by total cost, comma separated with no spaces. For example: 10,$200,000
,12/3/2020 Completed Exam | Wall Street Prep - Wall Street Prep
Question 36
Instructions: See Question 32.
Enter the number of items and total cost for class “Vehicles.” Enter your answer as the number of items
followed by total cost, comma separated with no spaces. For example: 10,$200,000
Question 37
A B C D
1 2015 2016 2017
2 Revenue 100 120 130
3 Expenses 34 55 75
4 Profit 66 65 55
5
6 User input Revenue
7 User input 2015
Identify the formula that outputs data from the table based on the user inputs in cells C6 and C7.
=OFFSET(A1,MATCH(C7,A2:A4),MATCH(C8,B1:D1))
=OFFSET(B1,MATCH(C6,A2:A4,0),MATCH(C7,B1:D1))
=OFFSET(A1,MATCH(C6,A2:A4,0),MATCH(C7,B1:D1))
=OFFSET(A1,MATCH(C8,B1:D1),MATCH(C7,A2:A4,0))
Question 38
1/10
, 12/3/2020 Completed Exam | Wall Street Prep - Wall Street Prep
Questions 38-39 use the fact pattern on tab Q38-39 in the Exam Workbook. You will enter a function for the
answer below. Start your formula with the = sign. Do not anchor cell references, i.e. there should be no dollar
signs (“$”) in your answer.
Write an HLOOKUP function that will output the correct Net Profit for whichever date is selected in cell H11. For
your answer to be scored correctly, please using C5:H8 as your table array and a hard coded number for the row
index number.
Review: Excel Crash Course Exam (Online)
Question 1
Instructions: Questions 1-4 use the financial model on tab Q1-4 in the Exam Workbook. Complete the model by
filling in the blank cells before answering the question below. Answers should be rounded to the nearest whole
number, comma separating 000s, NOT written in currency format. So if the answer is $5,505,210.50, you would
input 5,505,210. What is forecast Revenue in 2017?
Question 2
Instructions: See question 1.
What is forecast Net Income in 2016?
Question 3
Instructions: See question 1.
If Depreciation&Amortization as a % of Capital Expenditures is changed to 30%, what is Net Income in 2017?
Question 4
Instructions: See question 1. Format your answer to this question as a percentage, rounded to one decimal place.
So if your answer is 10.25%, you would input: 10.3% (include percentage sign).
2/10
