194k views
4 votes
When specifying criteria in the Custom AutoFilter dialog box, use the _________ wildcard to specify a single character.

a. ?b. *c. 'd. Both a. and b.

User Addisonj
by
5.0k points

1 Answer

4 votes

Answer:

Answer is option a. ?

Step-by-step explanation:

Wild card also called wild character or wildcard character is a symbol that is used to replace or depict one or more characters. It is also used to locate specific item in data. It is sometimes used in file searches so that the full name does not need to be typed.

Examples of wildcard are

  • * specify one or more characters.
  • [ ] matches characters with in the brackets.
  • # matches or specifies single numeric character.
  • - symbol specify range of characters (in ascending order).
  • ! symbol does not include the characters inside the brackets.

? wild card which shows a question mark (?) represents a single character. This symbol matches a single character in a certain position.

For example

  • t?ll matches tall, tell, and till.
  • l?nd finds land and lend.
  • l??d matches above example and also the following words like lord, loud, load, lard, lead, lied, laid, laud.
User Dan Morton
by
5.4k points