averageif

The following AVERAGIF function was entered into a cell on an Excel worksheet: =AVERAGEIF(Detail!A2:A25,Summary!A2) Which of the following is true with regards to this function? When the function finds a match to the criteria, the arithmetic mean will be calculated using the values in the range A2:A25 on the Detail worksheet. The output of the function will be an error since one of the arguments has not been defined. The output of the function will be an error since the absolute reference is missing from the cell reference used to define the criteria argument. The output of the function will be zero since the [average_range] argument has not been defined. The output of the function will be an error since the absolute reference is missing from the cell range used to define the range argument