The following AVERAGIF 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?

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 one of the arguments has not been defined.

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 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 reference used to define the criteria argument.