The following AVERAGIFS function was entered into a worksheet:

$=$AVERAGEIFS$($F$6$:F$18,$ B$6$:B$18,$ B$3,$ C$6$:C$18,$ "stock"$)$

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

a$.$ The function will search for any cells in the range C$6$:C$18$ that contain the entry "stock."

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

c$.$ The function will search for any cells in the range C$6$:C$18$ that contain an entry where one character precedes the word stock.

d$.$ The function will search for any cells in the range $C6$:$C18$ where the word stock is included as part of the entry.