Explanation
Blank cells can affect calculations and reports.
First identify missing information.
Example
|
Customer |
City |
Product |
Sales |
|
Amit |
Sirsa |
Keyboard |
4000 |
|
Neha |
Mouse |
5000 |
|
|
Rahul |
Sirsa |
Monitor |
|
|
Priya |
Fatehabad |
Printer |
24000 |
Missing data:
- Neha → City
- Rahul → Sales
Possible Actions
Depending on the situation, you can:
- Enter the correct value
- Replace with an appropriate value
- Leave blank
- Remove the record if it is unusable
Do not automatically replace blanks with zero unless zero is actually correct.
Practice
Identify all missing values and decide how each should be handled.