In the Allow list box in the Data Validation dialog box the ____ option means that the cell will accept only text of a specified number of characters.
A)Custom
B)Text Length
C)Any Value
D)Specified Text

Question

Quizplus · Accepted Answer

The Text Length option in the Allow list box in the Data Validation dialog box allows the user to specify the number of characters that should be allowed in a cell. This option is useful when a specific field has a maximum limit for the number of characters, such as a phone number or zip code. The other options listed do not have this specific function.

In the Allow List Box in the Data Validation Dialog