Question

Which of the following technique can be used to allow only date value in cell? Data formatting, data sorting,data filltering, data validation.

Answer 1

Data validation technique is used to allow only date values in cell.

Explanation :

Data validation is a feature in Excel used to control what a user can enter into a cell. For example, you could use data validation to make sure a value is a number between 1 and 6, make sure a date occurs in the next 30 days, or make sure a text entry is less than 25 characters.

Answer 2

Data validation is the correct answer for the above question.

Explanation:

The data validation techniques are used to validate the data which is stored on the cell of the Worksheet of the MS-Excel. It is techniques that alter the user to use valid data which is defined on the property of MS-Excel worksheet by the user of that worksheet. When a user wants to use this technique then firstly he needs to specify the valid data on the property of the worksheet.

The above question asked about that technique which is used to enter that data which is allowed by the user of the worksheet. So the answer is Data validation techniques which are defined above. Hence Data validation is the correct answer, while the other option is not correct because--

• Data formatting is used to customize the data in terms of color or font.
• Data sorting is used to sort the data in terms of ascending or descending order.
• Data filtering is used to filter the data and give that result which the user demands.

Learn More:

• Data validation :https://brainly.in/question/5548549