0
It is important to be as accurate as possible in entering the data. Anything that can be done to help that is beneficial. So being able to validate what is entered is important. The amount of errors made can be reduced. So validation is supplied in spreadsheets to assist that process.
Wiki User
∙ 9y ago
Wiki User
∙ 14y agoTesting cell input against a pre-defined criteria to ensure the entry meets specific criteria.
Wiki User
∙ 14y agoValidation means that the contents of a cell need to be evaluated to see if they meet a pre-determined criteria before being saved in that cell.
Anonymous
Definition - What does Data Validation mean?
Data validation is a process that ensures the delivery of clean and clear data to the programs, applications and services using it. It checks for the integrity and validity of data that is being inputted to different software and its components. Data validation ensures that the data complies with the requirements and quality benchmarks.
Data validation is also known as input validation
Add your answer:
Earn +20 pts
In Microsoft Excel what is the meaning of Data Validity?
In Excel, you can set validation rules on a cell to ensure the data meets specified conditions before Excel will accept the entry.
Can a person complete calculations in Microsoft Excel 2003?
Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.
What is data menu in Microsoft Excel?
Data menu is that on that we can sort,filter,subtotals,validation,text to columns,pivot tables and pivot chart report
Who are the creators of Microsoft Excel?
Microsoft excel was created by Microsoft
How do you launch Microsoft Excel?
Programs->Microsoft Office->Microsoft Excel
What is the spreadsheet program in Microsoft office 2007?
I believe the only Microsoft program used to create spreadsheets is Microsoft Excel.
Who created Microsoft Excel?
Microsoft Excel was created by Microsoft Corporation. It was first released in 1985.
Is there any hidden game in Excel 2003?
There are no hidden games in Microsoft Excel after Microsoft Excel 2000, so there are none in Microsoft Excel 2003.
In Excel data validation features do not ensure that the data you enter into a cell or range of cells is within limits?
Yes, you can set ranges using validation options in Excel.
How can set a validity condition in Excel file?
Use data validation and require a specific entry in the cell. See related links for various options for data validation in Excel.
Why are the validation error messages important on Microsoft Excel?
They tell the user that they have entered incorrect data and should tell them what they have done wrong and what is acceptable. Without the messages, the user will not know what the problem is.
What is the difference between Microsoft Excel 2003 and Microsoft Word?
Microsoft Excel is a worksheet. Microsoft Word is a word processor.
