Excel Crash Course Exam from Wall
Street Prep | Comprehensive
Questions & Answers Guide A+ Exam
Prep
• 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? -
✓✓784
• During the month of May, how many postal codes bought more than
700 products by quantity? -✓✓4
• Over the entire analysis period, which sales rep gave the most
discounts by dollar amount? Enter the name as: Firstname Lastname. -
✓✓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? -✓✓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)? -✓✓16
• Instructions: See question 7.
Which item number had the highest average sales price per unit (use a
simple average for calculation)? -✓✓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. -✓✓74.6
• Instructions: See question 7.
Which sales rep had the lowest average sales price / unit? Use a simple
average for calculation. -✓✓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. -✓✓30.7
Street Prep | Comprehensive
Questions & Answers Guide A+ Exam
Prep
• 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? -
✓✓784
• During the month of May, how many postal codes bought more than
700 products by quantity? -✓✓4
• Over the entire analysis period, which sales rep gave the most
discounts by dollar amount? Enter the name as: Firstname Lastname. -
✓✓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? -✓✓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)? -✓✓16
• Instructions: See question 7.
Which item number had the highest average sales price per unit (use a
simple average for calculation)? -✓✓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. -✓✓74.6
• Instructions: See question 7.
Which sales rep had the lowest average sales price / unit? Use a simple
average for calculation. -✓✓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. -✓✓30.7
