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

Which of the following accurately explains the output of this function?

The function will produce an error output since one of the required arguments has not been defined.

the range $C2$:$C30$ on the Summary worksheet

the range $C2$:$C30$ on the Detail worksheet

The output of the function will be the value in cell B$2$ on Detail worksheet.

The output of the function will be the value in cell B$2$ on the Summary worksheet.