FUNDAMENTALS OF COMPUTER

Previous

USING MICROSOFT EXCEL

USING DATA VALIDATION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which Tab in MS-Excel is used to access data validation for a cell or cell range?
A
Charts
B
Data
C
Formulas
D
Tables
Explanation: 

Detailed explanation-1: -On the Data tab, in the Data Tools group, click Data Validation. On the Settings tab, in the Allow box, select List. In the Source box, type your list values, separated by commas.

Detailed explanation-2: -You can use data validation to restrict the type of data or values that users enter into cells. For example, you might use data validation to calculate the maximum allowed value in a cell based on a value elsewhere in the workbook.

Detailed explanation-3: -Step 2: Set the Data Validation Rule After the data validation dialogue box is displayed, we need to go to the Settings tab to define validation criteria. We can provide the desired values, cell references, or formulas in the validation criteria.

There is 1 question to complete.
Previous