Validating formula results in excel 2016
By Peter Weverka In Excel 2016, you need to establish data-validation rules because by nature, people are prone to enter data incorrectly because the task of entering data is so dull. A data-validation rule is a rule concerning what kind of data can be entered in a cell.
When you select a cell that has been given a rule, an input message tells you what to enter, as shown here.
Data-validation rules are an excellent defense against sloppy data entry and that itchy feeling you get when you’re in the middle of an irksome task.
In a cell that records date entries, you can require dates to fall in a certain time frame.
In a cell that records text entries, you can choose an item from a list instead of typing it yourself.
I’m a manager at an engineering company, and I hired an out-of-work political science major to do data entry and other clerical stuff.
We don’t pay him a lot, but our deal is that he gets to learn about computers on our dime when he’s doing data entry.