The following AVERAGEIF function was entered into a cell on an Excel worksheet: $=$AVERAGEIF$($Detail$!$A$2$:A$25,$Summary!A$2)$

Which of the following is true with regards to this function?

Responses

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.

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.

When the function finds a match to the criteria, the arithmetic mean will be calculated using the values in the range A$2$:A$25$ on the Detail worksheet.

When the function finds a match to the criteria, the arithmetic mean will be calculated using the values in the range A$2$:A$25$ 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 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 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 zero since the $[$average$\_$range$]$ argument has not been defined.