WSP-Excel Crash Course| Complete Questions and
Answers | Graded A+ for a perfect 100% score
1. During the month of May, how many postal codes bought more
than 700 products by quantity? - Correct Answer ✅💯4
2. During the three-month period of January through March, what
was the quantity of item 23 sold while Fred Rubble was the
Manager on duty? - Correct Answer ✅💯784
3. In the last question, you wrote an VLOOKUP function to show
whatever 2018 metric is referenced in cell H11. Do you need to
include a range lookup parameter to get the correct answer? -
Correct Answer ✅💯Yes, the formula needs an exact match in
the range lookup parameter to work correctly
4. Instructions: Enter any keys that must be pressed together with a
"+" between them; for example, the shortcut for 'Copy' should
be input as Ctrl+C, while the shortcut for 'Open file' is input Alt
f o.
5. What is a shortcut to clear the comments of the cell only. Note:
there may be more than one answer. Please input only one
answer - Correct Answer ✅💯Alt h e a
6. Instructions: Questions 28-30 use the data table on tab Q28-30
in the Exam Workbook(opens in a new tab).
7. How many companies in the S&P 500 list have a Market Cap of
at least $20Bn AND Revenue of at least $15Bn? - Correct
Answer ✅💯145
8. Instructions: Questions 31-32 use the comp set on tab Q31-32 in
the Exam Workbook(opens in a new tab). Answers should be
rounded to the nearest 1 decimal followed by an x to designate
that it's a multiple. So if the answer is 14.765 you would input
14.8x.
, 9. What are the mean and median Next 12 Months PE Ratios of the
group? Enter your answer as the mean multiple followed by the
median multiple, comma separated with no spaces. For example:
25.5x,15.8x - Correct Answer ✅💯19.9x
10. Instructions: Questions 33-37 use the data table on tab
Q33-37 in the Exam Workbook(opens in a new tab). You will be
asked to determine the "Number of Items," and "Total Cost" for
item classes. Total cost SHOULD be in currency format,
rounded to the nearest whole dollar amount, so if the answer is
$500.78, you should input $501.
11. Enter the number of items and total cost for class
"Buildings." Enter your answer as the number of items followed
by total cost, comma separated with no spaces. - Correct Answer
✅💯37,$184,800
12. Instructions: Questions 41-42 use the fact pattern on tab
Q41-42 in the Exam Workbook(opens in a new tab). 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.
13. Write a VLOOKUP function that will output the correct
result for whichever 2018 income statement line item 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
column index number. - Correct Answer
✅💯=VLOOKUP(h11,C5:H8,6,)
14. Instructions: Questions 43-44 use the fact pattern on tab
Q43-44 in the Exam Workbook(opens in a new tab). Answers
below are rounded to the nearest dollar amount.
Answers | Graded A+ for a perfect 100% score
1. During the month of May, how many postal codes bought more
than 700 products by quantity? - Correct Answer ✅💯4
2. During the three-month period of January through March, what
was the quantity of item 23 sold while Fred Rubble was the
Manager on duty? - Correct Answer ✅💯784
3. In the last question, you wrote an VLOOKUP function to show
whatever 2018 metric is referenced in cell H11. Do you need to
include a range lookup parameter to get the correct answer? -
Correct Answer ✅💯Yes, the formula needs an exact match in
the range lookup parameter to work correctly
4. Instructions: Enter any keys that must be pressed together with a
"+" between them; for example, the shortcut for 'Copy' should
be input as Ctrl+C, while the shortcut for 'Open file' is input Alt
f o.
5. What is a shortcut to clear the comments of the cell only. Note:
there may be more than one answer. Please input only one
answer - Correct Answer ✅💯Alt h e a
6. Instructions: Questions 28-30 use the data table on tab Q28-30
in the Exam Workbook(opens in a new tab).
7. How many companies in the S&P 500 list have a Market Cap of
at least $20Bn AND Revenue of at least $15Bn? - Correct
Answer ✅💯145
8. Instructions: Questions 31-32 use the comp set on tab Q31-32 in
the Exam Workbook(opens in a new tab). Answers should be
rounded to the nearest 1 decimal followed by an x to designate
that it's a multiple. So if the answer is 14.765 you would input
14.8x.
, 9. What are the mean and median Next 12 Months PE Ratios of the
group? Enter your answer as the mean multiple followed by the
median multiple, comma separated with no spaces. For example:
25.5x,15.8x - Correct Answer ✅💯19.9x
10. Instructions: Questions 33-37 use the data table on tab
Q33-37 in the Exam Workbook(opens in a new tab). You will be
asked to determine the "Number of Items," and "Total Cost" for
item classes. Total cost SHOULD be in currency format,
rounded to the nearest whole dollar amount, so if the answer is
$500.78, you should input $501.
11. Enter the number of items and total cost for class
"Buildings." Enter your answer as the number of items followed
by total cost, comma separated with no spaces. - Correct Answer
✅💯37,$184,800
12. Instructions: Questions 41-42 use the fact pattern on tab
Q41-42 in the Exam Workbook(opens in a new tab). 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.
13. Write a VLOOKUP function that will output the correct
result for whichever 2018 income statement line item 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
column index number. - Correct Answer
✅💯=VLOOKUP(h11,C5:H8,6,)
14. Instructions: Questions 43-44 use the fact pattern on tab
Q43-44 in the Exam Workbook(opens in a new tab). Answers
below are rounded to the nearest dollar amount.
