WSP-Excel Crash Course questions and
answers 2025\2026 A+ Grade
Instructions: See question 7. Your answer for this question should be rounded to the nearest 1 decimal,
comma separating 000s, NOT written in currency format. So if the answer is $10,500.658, you would
input 10,500.7.
In the previous question, you determined the total of Amy's sales over the analysis period. What was
her total profit?
- correct answer 255,548.1
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
During the month of May, how many postal codes bought more than 700 products by quantity?
- correct answer 4
Over the entire analysis period, which sales rep gave the most discounts by dollar amount? Enter the
name as: Firstname Lastname.
- correct answer 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?
- correct answer 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)?
- correct answer 16
Instructions: See question 7.
Which item number had the highest average sales price per unit (use a simple average for calculation)?
- correct answer 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.
- correct answer 74.6
Instructions: See question 7.
Which sales rep had the lowest average sales price / unit? Use a simple average for calculation.
- correct answer 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.
- correct answer 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.
- correct answer 5
answers 2025\2026 A+ Grade
Instructions: See question 7. Your answer for this question should be rounded to the nearest 1 decimal,
comma separating 000s, NOT written in currency format. So if the answer is $10,500.658, you would
input 10,500.7.
In the previous question, you determined the total of Amy's sales over the analysis period. What was
her total profit?
- correct answer 255,548.1
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
During the month of May, how many postal codes bought more than 700 products by quantity?
- correct answer 4
Over the entire analysis period, which sales rep gave the most discounts by dollar amount? Enter the
name as: Firstname Lastname.
- correct answer 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?
- correct answer 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)?
- correct answer 16
Instructions: See question 7.
Which item number had the highest average sales price per unit (use a simple average for calculation)?
- correct answer 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.
- correct answer 74.6
Instructions: See question 7.
Which sales rep had the lowest average sales price / unit? Use a simple average for calculation.
- correct answer 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.
- correct answer 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.
- correct answer 5
