Microsoft Excel 2013: 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 Excel can 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. Can I set up Excel to prevent me from making this type of error?

• I’m entering a long list of numbers. Can 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 ...