If Denise specifies Jan as a search criterion Excel will loc

If Denise specifies Jan? as a search criterion, Excel will locate all of the following records except?
a. Janet
b. Jane
c. Jani
d. Jany

Solution

Answer: Here all given 4 records are starting with Jan, thus if you are searching for Jan as search criterion in excel, it will find all the given 4 records : Janet, Jane, Jani and Jany