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 = D1, 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?

UGC NET Paper I Exam 1 Mar 2023 Shift 1 Paper

Question : 31 of 50

Marks: +1, -0

Consider the following MS-Excel spreadsheet in which the population column represents the city's population in millions of people :

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?

Go to Question:

Prev Question

Next Question