The following COUNTIFS function was entered into a cell on an Excel worksheet:

$=$COUNTIFS$($Detail$!$F$6$:F$18,$Summary!A$7,$Detail!!H$6$:H$18,$"stock"$)$

Which of the following is true with regards to the criteria$2$ argument which is defined with "kstock"?

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

The function will search for any cells in the range $H6$:$H18$ on the Detail worksheet that contain an entry where one character precedes the word stock.

The function will search for any cells in the range $H6$:$H18$ on the Detail worksheet where the word stock is included as part of the entry.

The function will search for any number of contiguous cells $(2$ or more$)$ in the range H$6$:H$18$ on the Detail worksheet that contains the word stock.

The function will search for any cells in the range $H6$:$H18$ on the Detail worksheet that contain the entry $*$stock$.$