A workbook contains a list of houses and the months that they were sold in Florida. You are interested in determining the average price of sold houses in June in Ft. Lauderdale. What function is best suited for this calculation?

(A) AVERAGEIF(B) AVERAGEIFS (C) SUMIF (D) MAXIFS

In Microsoft Office Excel, AVERAGEIFS is a function that helps to determine the average of cells that follow different criteria. AVERAGEIFS is one of many functions under the "Statistic" category. The criteria for AVERAGEIFS can be words or range of numbers which allows more diverse analysis compared to other average functions.

Answer Link

A workbook contains a list of houses and the months that they were sold in Florida. You are interested in determining the average price of sold houses in June in Ft. Lauderdale. What function is best suited for this calculation? (A) AVERAGEIF(B) AVERAGEIFS (C) SUMIF (D) MAXIFS

Respuesta :

Otras preguntas

A workbook contains a list of houses and the months that they were sold in Florida. You are interested in determining the average price of sold houses in June in Ft. Lauderdale. What function is best suited for this calculation?

(A) AVERAGEIF(B) AVERAGEIFS (C) SUMIF (D) MAXIFS