WSP-Excel Crash Course
LATESTB 2025-2026
EXAM WITH QUESTIONS
AND CORRECT
VERIFIRD ANSWERS
GRADED A+
Over the entire analysis period, which sales rep gave the most discounts by dollar
amount? Enter the name as: Firstname Lastname. - ANSWERS-Oliver Winslow
Instructions: See question 7.
In the previous question, you determined which sales rep gave the most discounts by
dollar amount. What was that amount? - ANSWERS-17,439.6
Instructions: See question 7.
Over the entire analysis period, which item code did postal code 93930 spend the
greatest dollars on (using Sales Price Per Unit)? - ANSWERS-16
Instructions: See question 7.
Which item number had the highest average sales price per unit (use a simple average
for calculation)? - ANSWERS-3
Instructions: See question 7.
, For that item number, what was the average unit sales price? Please enter your answer
with numbers only, to one decimal place. Use a simple average for calculation. -
ANSWERS-74.6
Instructions: See question 7.
Which sales rep had the lowest average sales price / unit? Use a simple average for
calculation. - ANSWERS-Amy Adams
Instructions: See question 7.
What was that average sales price? Please enter your answer to one decimal place. Do
not include any symbols. Use a simple average for calculation. - ANSWERS-30.7
Instructions: See question 7.
Which item number had the greatest contribution to overall gross profit? Please enter
your answer as a whole number only. - ANSWERS-5
Instructions: See question 7.
What percentage of total gross profit did this item comprise? Enter as percentage as a
number with one decimal place (e.g., 18.1% is entered as 18.1). - ANSWERS-8.3%
Instructions: Questions 28-30 use the data table on tab Q28-30 in the Exam
Workbook(opens in a new tab).
How many companies in the S&P 500 list have a Market Cap of at least $20Bn AND
Revenue of at least $15Bn? - ANSWERS-145
Instructions: See question 28.
How many constituents of the S&P 500 have a Market Cap of at least $30Bn OR
Revenue of at least $17Bn? - ANSWERS-311
Instructions: See question 28.
How many constituents of the S&P 500 are listed on the New York Stock Exchange?
Please enter your answer as a whole number only. - ANSWERS-386
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.
LATESTB 2025-2026
EXAM WITH QUESTIONS
AND CORRECT
VERIFIRD ANSWERS
GRADED A+
Over the entire analysis period, which sales rep gave the most discounts by dollar
amount? Enter the name as: Firstname Lastname. - ANSWERS-Oliver Winslow
Instructions: See question 7.
In the previous question, you determined which sales rep gave the most discounts by
dollar amount. What was that amount? - ANSWERS-17,439.6
Instructions: See question 7.
Over the entire analysis period, which item code did postal code 93930 spend the
greatest dollars on (using Sales Price Per Unit)? - ANSWERS-16
Instructions: See question 7.
Which item number had the highest average sales price per unit (use a simple average
for calculation)? - ANSWERS-3
Instructions: See question 7.
, For that item number, what was the average unit sales price? Please enter your answer
with numbers only, to one decimal place. Use a simple average for calculation. -
ANSWERS-74.6
Instructions: See question 7.
Which sales rep had the lowest average sales price / unit? Use a simple average for
calculation. - ANSWERS-Amy Adams
Instructions: See question 7.
What was that average sales price? Please enter your answer to one decimal place. Do
not include any symbols. Use a simple average for calculation. - ANSWERS-30.7
Instructions: See question 7.
Which item number had the greatest contribution to overall gross profit? Please enter
your answer as a whole number only. - ANSWERS-5
Instructions: See question 7.
What percentage of total gross profit did this item comprise? Enter as percentage as a
number with one decimal place (e.g., 18.1% is entered as 18.1). - ANSWERS-8.3%
Instructions: Questions 28-30 use the data table on tab Q28-30 in the Exam
Workbook(opens in a new tab).
How many companies in the S&P 500 list have a Market Cap of at least $20Bn AND
Revenue of at least $15Bn? - ANSWERS-145
Instructions: See question 28.
How many constituents of the S&P 500 have a Market Cap of at least $30Bn OR
Revenue of at least $17Bn? - ANSWERS-311
Instructions: See question 28.
How many constituents of the S&P 500 are listed on the New York Stock Exchange?
Please enter your answer as a whole number only. - ANSWERS-386
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.
