You can add ..... to ensure that the correct information is being entered. For example, you can restrict a selection to only allow 3 digits to be entered if a column is meant to record an area code.

WORKBOOK THEMES

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

You can add ____ to ensure that the correct information is being entered. For example, you can restrict a selection to only allow 3 digits to be entered if a column is meant to record an area code.

A	Ascending
B	Data validation
C	delimiter
D	header row

Explanation:

Detailed explanation-1: -Data validation is a feature in Excel which is used to control what users can enter into a cell. It allows you to dictate specific rules. It also allows users to display a custom message if users try to enter invalid data.

Detailed explanation-2: -In the Data Validation dialog box, go to the Settings tab, select Custom in the Allow drop-down list, enter formula =$A$1="yes” into the Formula box, then uncheck the Ignore blank box. And finally click the OK button.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

WORKBOOK THEMES