Answer: B) SUM(B4:B8)/SUM(C4:C8)
Explanation:
A) MAX(B4:B8)/SUM(C4:C8)
Explanation:
- [tex]$MAX(B4:B8)[/tex] calculates the maximum value in the range B4:B8
- [tex]$SUM(C4:C8)[/tex] calculates the sum of the values in the range C4:C8
Why it isn't correct:
- This formula divides the maximum sales value by the total number of sales reps. This does not give the average sales per sales rep; it gives a skewed value based on the highest sales figure.
B) SUM(B4:B8)/SUM(C4:C8)
Explanation:
- [tex]$SUM(B4:B8)[/tex] calculates the total sales in the range B4:B8
- [tex]$SUM(C4:C8)[/tex] calculates the total number of sales reps in the range C4:C8
Why it is correct:
- This formula correctly divides the total sales by the total number of sales reps, giving the average sales per sales rep for the entire company.
C) AVERAGE(B4:B8)/SUM(C4:C8)
Explanation:
- [tex]$AVERAGE(B4:B8)[/tex] calculates the average sales value in the range B4:B8
- [tex]$SUM(C4:C8)[/tex] calculates the total number of sales reps in the range C4:C8
Why it isn't correct:
- This formula divides the average sales value by the total number of sales reps. This does not give the average sales per sales rep; it gives a value that does not make sense in this context.
D) SUM(B4:B8)/MIN(MAX(C4:C8))
Explanation:
- [tex]$SUM(B4:B8)[/tex] calculates the total sales in the range B4:B8
- [tex]$MIN(MAX(C4:C8))[/tex] is an incorrect operation. [tex]$MAX(C4:C8)[/tex] calculates the maximum value in the range C4:C8, and then [tex]$MIN[/tex] of a single value is just that value itself.
Why it isn't correct:
- This formula divides the total sales by the maximum number of sales reps, which does not make sense. Furthermore, the use of [tex]$MIN[/tex] and [tex]$MAX[/tex] together is redundant this problem.
