shirleychandler41
Answered

Explore Westonci.ca, the leading Q&A site where experts provide accurate and helpful answers to all your questions. Our platform offers a seamless experience for finding reliable answers from a network of experienced professionals. Explore comprehensive solutions to your questions from knowledgeable professionals across various fields on our platform.

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.
Thanks for stopping by. We are committed to providing the best answers for all your questions. See you again soon. Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. Thank you for using Westonci.ca. Come back for more in-depth answers to all your queries.