USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which feature do you use to restrict the entry of a cell to a certain date range?
|
|
Data Validation
|
|
|
Format Cell
|
|
|
Data Form
|
|
|
Data Table
|
|
|
Error Checking
|
Explanation:
Detailed explanation-1: -Select the cells where you want to restrict data entry. On the Data tab, click Data Validation > Data Validation.
Detailed explanation-2: -To do this, first select the cells you want to restrict. Then, go to Data > Data Tools > Data Validation. In the Allow box, select “Date” from the drop-down menu. Then, in the Data box, enter the minimum and maximum dates you want to allow.
Detailed explanation-3: -On the Excel Ribbon, click the Data tab, and click Data Validation. From the Allow drop down, select Date. From the Data drop down, select Between. Click in the Start Date box, and click cell E1, where the Start Date is entered.
There is 1 question to complete.