High School

What is the formula for the average price of the current inventory of brushes when Column A is the department, Column B is the tool name, and Column C is the price?

A) =AVERAGE(C2:C14, "Brushes")

B) =AVERAGEIF(C2:C25, B2:B25, "Brushes")

C) =AVERAGEIF(A2:B14, "Brushes", C2:C14)

D) =AVERAGEIF(B2:B14, "Brushes", C2:C14)

Answer :

Final answer:

The formula for the average price of the current inventory of brushes when Column A is the department, Column B is the tool name, and Column C is the price is option D) =AVERAGEIF(B2:B14,"Brushes",C2:C14).

Explanation:

The formula for the average price of the current inventory of brushes when Column A is the department, Column B is the tool name, and Column C is the price is option D) =AVERAGEIF(B2:B14,"Brushes",C2:C14).



This formula uses the AVERAGEIF function, which allows you to calculate the average based on a specific condition. In this case, the condition is that the tool name in Column B is "Brushes". The function looks in Column B for the specified condition and calculates the average of the corresponding prices in Column C.



For example, if you have seven brushes listed in the inventory with prices of $10, $15, $12, $18, $20, $17, and $14, the formula would calculate the average as (10 + 15 + 12 + 18 + 20 + 17 + 14) / 7 = $15.71.

Learn more about average price of current inventory of brushes here:

https://brainly.com/question/35915707

#SPJ11