Microsoft® Excel® 2010: Data Analysis and Business Modeling

Chapter 40. Validating Data

Questions answered in this chapter:

• I’m entering scores from professional basketball games into Excel. I know that a team scores from 50 to 200 points per game. I once entered 1,000 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 ...