if you want to find the average of all the numbers greater than 10, which formula should you enter…

if you want to find the average of all the numbers greater than 10, which formula should you enter? =averageif(b2:b7,\ > 10\) =average(b2:b7,>10) =averageif(b2:b7,>10)

if you want to find the average of all the numbers greater than 10, which formula should you enter? =averageif(b2:b7,\ > 10\) =average(b2:b7,>10) =averageif(b2:b7,>10)

Answer

Explanation:

Step1: Recall AVERAGEIF function syntax

The AVERAGEIF function in Excel has the syntax =AVERAGEIF(range, criteria, [average_range]). Here the range is the set of cells to evaluate against the criteria, and the criteria is the condition. In this case, the range is B2:B7 and the criteria is ">10". The [average_range] is optional and if omitted, the range is used for averaging.

Answer:

=averageif(B2:B7,">10")