Wsp Excel Crash Course ACTUAL EXAM QUESTIONS
AND CORRECT ANSWERS 2025
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.
students for leadership and management roles in various industries. It focuses on critical thinking, decision-making, problem-solving, and understanding organizational processes. A typical business program might cover
topics like accounting, finance, marketing, management, economics, e
In the previous question, you determined the total of Amy's sales over the
analysis period. What was her total profit? - (answer)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? - (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.
students for leadership and management roles in various industries. It focuses on critical thinking, decision-making, problem-solving, and understanding organizational processes. A typical business program might cover
topics like accounting, finance, marketing, management, economics, e
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.
AND CORRECT ANSWERS 2025
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.
students for leadership and management roles in various industries. It focuses on critical thinking, decision-making, problem-solving, and understanding organizational processes. A typical business program might cover
topics like accounting, finance, marketing, management, economics, e
In the previous question, you determined the total of Amy's sales over the
analysis period. What was her total profit? - (answer)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? - (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.
students for leadership and management roles in various industries. It focuses on critical thinking, decision-making, problem-solving, and understanding organizational processes. A typical business program might cover
topics like accounting, finance, marketing, management, economics, e
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.
