DATABASE FUNDAMENTALS
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: -Open the Data Validation dialog box (Data tab > Data Validation). On the Settings tab, select List in the Allow box. In the Source box, type the items of your Excel validation list, separated by commas. For example, to limit the user input to three choices, type Yes, No, N/A.
There is 1 question to complete.