ASAP ANSWER THIS PLSSSSSSSSSSSSSS

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.