USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To extend Data Validation, for example a Data Validation List, to cells that it is not applied to yet, I can:
|
|
I. Recreate the Data Validation list by selecting the existing cells as well as the additional cells and reapplying the Data Validation Criteria to it.
|
|
|
II. I can copy and paste a cell to which the Data Validation Criteria is applied, to additional cells.
|
|
|
Both option I and II are correct
|
|
|
Neither of the options listed are correct.
|
Explanation:
Detailed explanation-1: -Go to Data > Data Validation. On the Settings tab, click in the Source box, and then change your list items as needed.
Detailed explanation-2: -To quickly remove data validation for a cell, select it, and then go to Data > Data Tools > Data Validation > Settings > Clear All.
Detailed explanation-3: -They must keep the contents of the cells, but the data validation must be in the cell. To do this, you can copy cell A2, highlight the rest of the cells that need this validation type, and click Paste Special. There is an option for Validation. If you choose this option, ONLY the data validation is copied over.
There is 1 question to complete.