Test Index

UGC NET Paper I Exam 1 Mar 2023 Shift 1 Paper

© examsnet.com

Question : 31

Total: 50

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?

0
6
12
18

Go to Question:

Prev Question

Next Question