Which of the following Characters are Wildcards in Excel? (Check All that Apply)

Question

Which of the following characters are wildcards in Excel? (Check all that apply)

1. #
2. *
3. ?
4. $
5. @

Answer

B. * and C. ?

Explanation

Wildcards are the characters we use to represent other characters in Excel, usually in a criterion that we write in a formula.

Here are the wildcard characters available in Excel and what we can use them for.

• * (Asterisk) = represents any characters in any amount
• (Question mark) = represents any one character
• (Tilde) = enables you to add a literal asterisk (*) or question mark (?)

From the answer choices, we have an asterisk (*) and a question mark (?) as wildcard characters we can use in Excel in B and C answer choices. Thus, the correct answers to the question are B and C.

Go back to the Compute Expert's excel quiz page