In the Summary worksheet: $=$AVERAGEIFS$($Detail$!$A$1$:A$5,$Detail!B$1$:B$5,$Summary!C$3,$Detail D$1$:D$5,"*$Available$")$

Which of the following accurately describes the criteria$2$ argument defined as $"*$Available$"?$

Question $40$ options:

The function will search for any cells in the range B$1$:B$5$ on the Detail worksheet that contain the entry $*$Available$.$

The function will search for any cells in the range B$1$:B$5$ on the Detail worksheet that contain an entry where one character precedes the word Available.

The function will search for any cells in the range B$1$:B$5$ on the Detail worksheet where the word Available is included as part of the entry.

This is not a valid way to define any of the criteria arguments in a statistical IFS function.

The function will search for any number of contiguous cells $(2$ or more$)$ in the range B$1$:B$5$ on the Detail worksheet that contains the word Available.