Which of the following is true about the criteria cell entry: LIKE [Enter the first character of the company name:] & "*"?
A) [Enter the first character of the company name:] is the parameter prompt.
B) & is the wildcard.
C) "*" is the second parameter prompt.
D) All of the above.

Question

Quizplus · Accepted Answer

The criterion cell entry is using the LIKE operator to match the first character of the company name. "[Enter the first character of the company name:]" is the parameter prompt asking the user to input the character to match. The "*" is actually the wildcard character that is concatenated to the input value to look for any string that starts with that character. Therefore, only statement A is true.

Which of the Following Is True About the Criteria Cell