Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition

Chapter 35. Validating Data

• I’m entering scores from professional basketball games into Excel. I know that a team scores from 50 through 200 points per game. I once entered 1000 points instead of 100 points, which messed up my analysis. Is there a way to have Excel prevent me from making this type of error?

• I’m entering the date and amount of my business expenses for a new year. Early in the year, I often enter the previous year in the Date field by mistake. Is there a way I can set up Excel to prevent me from making this type of error?

• I’m entering a long list of numbers. Can I have Excel warn me if I enter a nonnumeric value?

• My assistant needs to enter state abbreviations when she enters dozens and dozens of sales transactions. Can we set up a ...