WSP-Excel Crash Course
Study online at https://quizlet.com/_fc0wm1
1. Instructions: See question 7. Your answer for this ques- 255,548.1
tion should be rounded to the nearest 1 decimal,
comma separating 000s, NOT written in currency for-
mat. 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?
2. During the three-month period of January through 784
March, what was the quantity of item 23 sold while
Fred Rubble was the Manager on duty?
3. During the month of May, how many postal codes 4
bought more than 700 products by quantity?
4. Over the entire analysis period, which sales rep gave Oliver Winslow
the most discounts by dollar amount? Enter the name
as: Firstname Lastname.
5. Instructions: See question 7. 17,439.6
In the previous question, you determined which sales
rep gave the most discounts by dollar amount. What
was that amount?
6. Instructions: See question 7. 16
Over the entire analysis period, which item code did
postal code 93930 spend the greatest dollars on (using
Sales Price Per Unit)?
7. 3
, WSP-Excel Crash Course
Study online at https://quizlet.com/_fc0wm1
Instructions: See question 7.
Which item number had the highest average sales
price per unit (use a simple average for calculation)?
8. Instructions: See question 7. 74.6
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 calcula-
tion.
9. Instructions: See question 7. Amy Adams
Which sales rep had the lowest average sales price /
unit? Use a simple average for calculation.
10. Instructions: See question 7. 30.7
What was that average sales price? Please enter your
answer to one decimal place. Do not include any sym-
bols. Use a simple average for calculation.
11. Instructions: See question 7. 5
Which item number had the greatest contribution to
overall gross profit? Please enter your answer as a
whole number only.
12. Instructions: See question 7. 8.3%
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).
Study online at https://quizlet.com/_fc0wm1
1. Instructions: See question 7. Your answer for this ques- 255,548.1
tion should be rounded to the nearest 1 decimal,
comma separating 000s, NOT written in currency for-
mat. 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?
2. During the three-month period of January through 784
March, what was the quantity of item 23 sold while
Fred Rubble was the Manager on duty?
3. During the month of May, how many postal codes 4
bought more than 700 products by quantity?
4. Over the entire analysis period, which sales rep gave Oliver Winslow
the most discounts by dollar amount? Enter the name
as: Firstname Lastname.
5. Instructions: See question 7. 17,439.6
In the previous question, you determined which sales
rep gave the most discounts by dollar amount. What
was that amount?
6. Instructions: See question 7. 16
Over the entire analysis period, which item code did
postal code 93930 spend the greatest dollars on (using
Sales Price Per Unit)?
7. 3
, WSP-Excel Crash Course
Study online at https://quizlet.com/_fc0wm1
Instructions: See question 7.
Which item number had the highest average sales
price per unit (use a simple average for calculation)?
8. Instructions: See question 7. 74.6
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 calcula-
tion.
9. Instructions: See question 7. Amy Adams
Which sales rep had the lowest average sales price /
unit? Use a simple average for calculation.
10. Instructions: See question 7. 30.7
What was that average sales price? Please enter your
answer to one decimal place. Do not include any sym-
bols. Use a simple average for calculation.
11. Instructions: See question 7. 5
Which item number had the greatest contribution to
overall gross profit? Please enter your answer as a
whole number only.
12. Instructions: See question 7. 8.3%
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).
