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.