USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Settings, Input Message, Error Alert
|
|
|
Dates & Times, Numbers and Text
|
|
|
Data, Data Criteria, Data Validation
|
|
|
Rows, Cells and Columns
|
Detailed explanation-1: -Select the cell you want to validate. Go to the Data tab > Data tools, and click on the Data Validation button. A data validation dialogue box will appear having 3 tabs-Settings, Input Message, and Error Alerts.
Detailed explanation-2: -Using Data Validation Dialog Box to Define Validation Rules. The Data Validation dialogue box contains three essential options/ tabs: Settings, Input Message, and Error Alert.
Detailed explanation-3: -Excel displays its Data Validation dialog box having 3 tabs settings, Input Message and Error alert.
Detailed explanation-4: -In Excel, data validation is found on the “Data” ribbon, under “Data Validation.” Once clicked, the data validation window will pop up. It will show three tabs: Settings, Input Message, and Error Alert.
Detailed explanation-5: -Click on the Data tab. Click on Data Validation in the Data Tools Group. A dialogue box will appear, with three tabs – Settings, Input Message and Error Alert.