WSP Excel Crash Course Exam Prep 2026–2027 | Updated
Practice Questions & Verified Answers
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 answers -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 answers -784
During the month of May, how many postal codes bought more than 700 products by quantity? - correct
answers -4
Over the entire analysis period, which sales rep gave the most discounts by dollar amount? Enter the
name as: Firstname Lastname. - correct 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? - correct answers -17,439.6
Instructions: See question 7.
1
, Over the entire analysis period, which item code did postal code 93930 spend the greatest dollars on
(using Sales Price Per Unit)? - correct answers -16
Instructions: See question 7.
Which item number had the highest average sales price per unit (use a simple average for calculation)? -
correct 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. - correct answers -74.6
Instructions: See question 7.
Which sales rep had the lowest average sales price / unit? Use a simple average for calculation. - correct
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. - correct answers -30.7
Instructions: See question 7.
2
Practice Questions & Verified Answers
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 answers -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 answers -784
During the month of May, how many postal codes bought more than 700 products by quantity? - correct
answers -4
Over the entire analysis period, which sales rep gave the most discounts by dollar amount? Enter the
name as: Firstname Lastname. - correct 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? - correct answers -17,439.6
Instructions: See question 7.
1
, Over the entire analysis period, which item code did postal code 93930 spend the greatest dollars on
(using Sales Price Per Unit)? - correct answers -16
Instructions: See question 7.
Which item number had the highest average sales price per unit (use a simple average for calculation)? -
correct 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. - correct answers -74.6
Instructions: See question 7.
Which sales rep had the lowest average sales price / unit? Use a simple average for calculation. - correct
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. - correct answers -30.7
Instructions: See question 7.
2
