USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Under the Insert tab on the Ribbon, in the Text group.
|
|
Under the Review tab on the Ribbon, in the Changes group.
|
|
Under the Data tab on the Ribbon, in the Data Tools group.
|
|
All of the options listed above are correct.
|
Detailed explanation-1: -4) The correct answer is c. In the Data Tools group, click on the Data Validation button and select the Error Alert tab.
Detailed explanation-2: -You can provide your own error message and also allow people to type their own values. Here’s how: Select the cells you want. Click Data Validation. Click the Error Alert tab and check the box.
Detailed explanation-3: -To find the cells on the worksheet that have data validation, on the Home tab, in the Editing group, click Find & Select, and then click Data Validation.
Detailed explanation-4: -Open the Data Validation dialog box (Data tab > Data Validation). On the Settings tab, select List in the Allow box.
Detailed explanation-5: -Creating an Error Message Then go to Data Tab>Data Tools Group>Data Validation i.e click on the Data tab and go to Data Tools and click Data Validation. Data Validation is a feature in Excel that is used by users to control the input cell values be it text, date, or numbers.