Excel Crash Course Exam Questions and
Answers Verified Solutions Latest
Update
Question:
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
Question:
During the month of May, how many postal codes bought more than 700 products by
quantity?
Answer:
4
Question:
Over the entire analysis period, which sales rep gave the most discounts by dollar
amount? Enter the name as: Firstname Lastname.
Answer:
Oliver Winslow
Question:
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
, Question:
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
Question:
Instructions: See question 7. Which item number had the highest average sales price
per unit (use a simple average for calculation)?
Answer:
3
Question:
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
Question:
Instructions: See question 7. Which sales rep had the lowest average sales price / unit?
Use a simple average for calculation.
Answer:
Amy Adams
Question:
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.
Answer:
30.7
Answers Verified Solutions Latest
Update
Question:
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
Question:
During the month of May, how many postal codes bought more than 700 products by
quantity?
Answer:
4
Question:
Over the entire analysis period, which sales rep gave the most discounts by dollar
amount? Enter the name as: Firstname Lastname.
Answer:
Oliver Winslow
Question:
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
, Question:
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
Question:
Instructions: See question 7. Which item number had the highest average sales price
per unit (use a simple average for calculation)?
Answer:
3
Question:
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
Question:
Instructions: See question 7. Which sales rep had the lowest average sales price / unit?
Use a simple average for calculation.
Answer:
Amy Adams
Question:
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.
Answer:
30.7
