Question

To restrict the type of data and the values while entering data in a cell, use _______________
option.​

Answer 1

Answer:

DATA VALIDATION.

Explanation:

TO RESTRICT THE TYPE OF DATA AND THE VALUES WHILE ENTERING DATA IN A CELL, USE DATA VALIDATION OPTION.

Answer 2

Data validation is the method used to restrict the type and value of the data.

• To assure that the output of a calculation is correct, the user needs to enter the correct data type and size.
• If the type or value is wrong it will directly affect the quality of the result.
• Several checkings have been done on the data before submission.
• Data validation method helps the user to validate the data he entered as the input for the calculation.