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