Consider the following MS-Excel spreadsheet in which the population column represents the city's population in millions of people :
| A | B | C | D | E | F | |
| 1. | City | State | Population | Haryana | MP | UP |
| 2. | Patiala | Panjab | 8.34 | |||
| 3. | Sonipat | Haryana | 3.86 | |||
| 4. | Noida | UP | 2.71 | |||
| 5. | Indore | MP | 2.16 | |||
| 6. | Mandi | HP | 1.49 | |||
| 7. | Sagar | MP | 1.38 | |||
| 8. | Panipat | Haryana | 1.39 | |||
| 9. | Gwalior | MP | 1.24 |
Suppose the formula - IF($B2 = D$1, $A2, 0) is entered into cell D2 and then the cell D2 is copied and pasted to D2 : F9. How many cells in the range D2 : F9 contains 0?
1
0
2
6
3
12
4
18