shirleychandler41
Answered

At Westonci.ca, we provide clear, reliable answers to all your questions. Join our vibrant community and get the solutions you need. Connect with professionals on our platform to receive accurate answers to your questions quickly and efficiently. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.

ASAP ANSWER THIS PLSSSSSSSSSSSSSS

ASAP ANSWER THIS PLSSSSSSSSSSSSSS class=

Sagot :

Snor1ax

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.
Thank you for visiting. Our goal is to provide the most accurate answers for all your informational needs. Come back soon. We hope you found what you were looking for. Feel free to revisit us for more answers and updated information. Get the answers you need at Westonci.ca. Stay informed by returning for our latest expert advice.