Lesson 1457 of 1524
Advanced Excel Spreadsheets: Statistical and Data Analysis
Data verification and the Data Validation tool can ensure the quality of data in your spreadsheets
Practice this chapterData verification and the Data Validation tool can ensure the quality of data in your spreadsheets There are four levels of measurement for data
Excel Data Tables can be used to quickly format information in a professional manner
data verification — process used to ensure that your data is accurate and reliable. data validation — process of ensuring that data values fall within a predetermined range. categorical data — data that is grouped into categories based on attributes or characteristics. continuous data — information that is measured and can take on an infinite set of values.
Worked example
What does “data verification” mean in Advanced Excel Spreadsheets: Statistical and Data Analysis?
- 1Use the wording this chapter gives for data verification.
- 2The book says: process used to ensure that your data is accurate and reliable.
- 3Do not use the meaning of data validation. That term means process of ensuring that data values fall within a predetermined range.
Result: process used to ensure that your data is accurate and reliable
Why. That is the meaning this chapter gives for data verification.
Do not swap data verification and data validation. data verification means process used to ensure that your data is accurate and reliable. data validation means process of ensuring that data values fall within a predetermined range.
Practice margin
This chapter
A fresh set from this chapter only. Choose 10 or 20. Multiple choice and fill-in, with no repeat inside the set.