WSP-Excel Crash Course Exam with accurate || || || || || ||
detailed solutions ||
Instructions: See question 7. Your answer for this question should be rounded to the nearest 1
|| || || || || || || || || || || || || || || ||
decimal, comma separating 000s, NOT written in currency format. 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? - ✔✔255,548.1
|| || || || ||
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
|| || || || || || || || ||
Instructions: See question 7. || || ||
Which item number had the greatest contribution to overall gross profit? Please enter your answer
|| || || || || || || || || || || || || ||
as a whole number only. - ✔✔5
|| || || || || || ||
Instructions: See question 7. || || ||
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). - ✔✔8.3%
|| || || || || || || || || || ||
detailed solutions ||
Instructions: See question 7. Your answer for this question should be rounded to the nearest 1
|| || || || || || || || || || || || || || || ||
decimal, comma separating 000s, NOT written in currency format. 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? - ✔✔255,548.1
|| || || || ||
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
|| || || || || || || || ||
Instructions: See question 7. || || ||
Which item number had the greatest contribution to overall gross profit? Please enter your answer
|| || || || || || || || || || || || || ||
as a whole number only. - ✔✔5
|| || || || || || ||
Instructions: See question 7. || || ||
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). - ✔✔8.3%
|| || || || || || || || || || ||
