Question

What is meant by 'Data Validation'? Give two examples, when cell will give error, if the value does not meet the condition.

Accepted Answer

Data validation is a feature to define restrictions on type of data entered into a cell. Example 1 We can prevent duplicate entries in a range on the worksheet (Figure 2.50) i.e. suppose we check duplicate employee number or duplicate product code in the asset ledger or duplicate account code for the same item entered by user it shows the error. Example 2 We can limit the sum value for a range which will cause error if sum of the values exceeds the given total, i.e. suppose the total amount of budget is fixed and sum of the distribution of the amount for different items in the range exceeds then it shows the error.

Marking-scheme solution

More from Spreadsheet