Shirleychandler41idn
Answered

IDNLearn.com provides a platform for sharing and gaining valuable knowledge. Our community provides accurate and timely answers to help you understand and solve any issue.

ASAP ANSWER THIS PLSSSSSSSSSSSSSS

ASAP ANSWER THIS PLSSSSSSSSSSSSSS class=

Sagot :

Snor1axidn

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.
Your participation means a lot to us. Keep sharing information and solutions. This community grows thanks to the amazing contributions from members like you. Your questions are important to us at IDNLearn.com. Thanks for stopping by, and come back for more reliable solutions.