Which of the following Characters are Wildcards in Excel? (Check All that Apply)
Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> Excel Quiz >> 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)- #
- *
- ?
- $
- @
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