EXCEL CRASH COURSE EXAM 259
CERTIFICATION EVALUATION 2026 FULL
QUESTIONS WITH SOLUTIONS
◉ 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. Answer: Amy Adams
◉ Instructions: See question 7.
CERTIFICATION EVALUATION 2026 FULL
QUESTIONS WITH SOLUTIONS
◉ 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. Answer: Amy Adams
◉ Instructions: See question 7.
