课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Data validation for reasonable values

Data validation for reasonable values - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

开始一个月试用 购买团队方案

Data validation for reasonable values

“

- [Instructor] When you're tracking data that has manual inputs, it helps to put in some controls or preventions to avoid mistakes. Now, one thing we didn't make a mistake with was opening this school to help keep disco alive. All right, let's look at this data. We have survey result data. The scoring should be one through five for columns, D, E, F, and G. And in column H, there should be a Y or an N. That's all. Yes, no, no maybes or some long prose about the person's decision. And look again over at columns D through G, like right here, there's an R. Well, the R is near a four and a five. So a four or a five is likely what was supposed to be there. We don't know. Over here, a 33, probably meant to be a three, but here is what we can do. I'm going to highlight the data including the cells that we don't have any data for. Now, I'm going to go up to Data and Data Tools. Here's the data validation. Now for…

内容