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,"????$LT$")$

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

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

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

The function will search for any four contiguous cells in the range $H6$:$H18$ on the Detail worksheet that contains the letters LT$.$

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 contains an entry with six characters where the last two characters are the letters LT$.$