What is the formula for the average price of the current inventory of brushes located in the tools department, given the following columns?

- Column A: Department
- Column B: Tool Name
- Column C: Price

A) =AVERAGEIFS(C2:C25, A2:A25, "Tools", B2:B25, "Brushes")
B) =AVERAGEIFS(A2:C25, A2:A25, "Tools", B2:B25, "Brushes")
C) =AVERAGEIFS(A2:C25, A2:A25, "Brushes", B2:B25, "Tools")
D) =AVERAGEIFS(A2:A25, B2:B25, "Brushes", C2:C25, "Tools")

The formula to calculate the average price for brushes in the tools department is '=AVERAGEIFS(C2:C25, A2:A25, "Tools", B2:B25, "Brushes")', using the AVERAGEIFS function in Excel.

Explanation:

The correct formula to calculate the average price of the current inventory of brushes located in the tools department, given that Column A is the department, Column B is the tool name, and Column C is the price, is =AVERAGEIFS(C2:C25, A2:A25, "Tools", B2:B25, "Brushes"). This formula applies the AVERAGEIFS function, which calculates the average of cells that meet multiple criteria. In this case, the criteria are that the department must be "Tools" and the tool name must be "Brushes". The function will average the prices listed in Column C that correspond to entries in Column A with "Tools" and entries in Column B with "Brushes".

Learn more about the AVERAGEIFS formula here:

https://brainly.com/question/27490522

#SPJ11