USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Priscilla wants to ensure that in a Date column on her worksheet, dates that fall BEFORE 1 January 2015 cannot be entered. How can she achieve this?
|
|
She should select Date as a Data Validation Criteria. It will automatically adjust the dates allowed to be after 1 January 2015.
|
|
|
She should type 1 January 2015 into the first cell of the Date column and then select Date as a Data Validation Criteria.
|
|
|
She should select Date as a Data Validation Criteria. Select Greater than or equal to in the Data box and insert 1 January 2015 as the Start Date
|
|
|
She should select Date as a Data Validation Criteria. Select Less than or equal to in the Data box and insert 1 January 2015 as the Start Date.
|
Explanation:
Detailed explanation-1: -Priscilla wants to ensure that in a Date column on her worksheet, dates that fall BEFORE 1 January 2015 cannot be entered. How can she achieve this? She should select Date as a Data Validation Criteria. It will automatically adjust the dates allowed to be after 1 January 2015.
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: -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.
There is 1 question to complete.