Project: Data Validation & Error Checking System
Create the following dataset:
|
Employee |
Age |
Salary |
|
Calculation |
Data Status |
|
Amit |
32 |
35000 |
100/10 |
||
|
Neha |
28 |
42000 |
200/0 |
||
|
Rahul |
35 |
Text |
150/5 |
||
|
Priya |
30 |
48000 |
300/10 |
||
|
Simran |
27 |
39000 |
250/5 |
Required Checks
Salary Validation
=IF(ISNUMBER(C2),”Valid”,”Invalid”)
Email Check
=IF(ISBLANK(D2),”Missing”,”Available”)
Calculation Error Check
=IF(ISERROR(E2),”Error”,”Valid”)
Formula Check
=IF(ISFORMULA(E2),”Formula”,”Manual Entry”)
Overall Status
Combine multiple checks using IF, AND, and Information functions.
Final Challenge
Create a Data Quality Dashboard showing:
- Total records
- Missing values
- Invalid numbers
- Formula cells
- Error cells
- Valid records
- Records requiring correction
Use:
- ISBLANK
- ISNUMBER
- ISTEXT
- ISERROR
- ISNA
- ISFORMULA
- TYPE
- CELL
- IF