← Excel Data Cleanup
Lesson 2 of 4
Handle missing values
Fill only fields with an explicit business default.
Do the work
- Distinguish a missing number from a real zero.
- For these exercises the policy sets missing region to Unknown.
- A missing amount becomes 0 only where the exercise explicitly says so.
See the method
Before: an empty region does not mean East.
Practice independently
Exercise 1
Apply region defaults
Open practice →Exercise 2Prepare an explicitly defaulted quantity
Open practice →Take it further
In real work ask for the missing-value policy before inventing defaults.