EXCEL CRASH TEST BANK UPDATED
QUESTIONS AND ANSWERS FULL STUDY
SHEET
●● 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?
Answer: 784
●● During the month of May, how many postal codes bought more than
700 products by quantity?
Answer: 4
●● Over the entire analysis period, which sales rep gave the most
discounts by dollar amount? Enter the name as: Firstname Lastname.
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?
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)?
Answer: 16
●● Instructions: See question 7.
Which item number had the highest average sales price per unit (use a
simple average for calculation)?
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.
Answer: 74.6
●● Instructions: See question 7.
Which sales rep had the lowest average sales price / unit? Use a simple
average for calculation.
QUESTIONS AND ANSWERS FULL STUDY
SHEET
●● 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?
Answer: 784
●● During the month of May, how many postal codes bought more than
700 products by quantity?
Answer: 4
●● Over the entire analysis period, which sales rep gave the most
discounts by dollar amount? Enter the name as: Firstname Lastname.
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?
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)?
Answer: 16
●● Instructions: See question 7.
Which item number had the highest average sales price per unit (use a
simple average for calculation)?
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.
Answer: 74.6
●● Instructions: See question 7.
Which sales rep had the lowest average sales price / unit? Use a simple
average for calculation.
