Question 1 of 10
The question mark wildcard character (?) replaces exactly one character in text.
Of the fruits below, how many would match with "Le?on"?
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Apple | |||
| 2 | Lemon | |||
| 3 | Pineapple | |||
| 4 | Melon | |||
| 5 | Watermelon | |||
| 6 | Strawberry | |||
| 7 | Blueberry | |||
| 8 | Cherry |
Wildcard Characters - Free Excel Practice Online
This free, interactive exercise teaches you Wildcard Characters in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Text Search Functions track and works right in your browser - no Excel install, no download, and no signup.
Practising Wildcard Characters this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.
What you'll practice in this Wildcard Characters lesson
- In Excel, Wildcard characters are used to replace certain text in functions that search for matching text.The question mark wildcard character (?) replaces exactly one character in text.Of the fruits below, how many would match with "Le?on"?
- The asterisk mark wildcard character (*) replaces any number of characters (even 0) in text.Of the fruits below, how many would match with "A*e"?
- Of the fruits below, how many would match with "*pple"?
- Of the fruits below, how many would match with "*berry"?
- Of the fruits below, how many would match with "*erry"?
- Of the fruits below, how many would match with "????berry"?
- Of the fruits below, how many would match with "????n"?
- Of the fruits below, how many would match with "A*"?
- Of the fruits below, how many would match with "*"?
- Of the fruits below, how many would match with "?????"?
Wildcard Characters practice - FAQ
How do I practice Wildcard Characters in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the Wildcard Characters exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this Wildcard Characters lesson?
This lesson covers Wildcard Characters as part of the Text Search Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.