02 Sep 2024- Morning Shift- UGC NET Paper 1

Total Questions: 50

31. Consider the following snapshot of MS-Excel worksheet:

ABCD
17DayQuantitySales Amount (₹)
18Monday1234
19Tuesday3144
20Wednesday6367
21Thursday5674
22Friday81099
23Saturday3233

In cell D18, the value returned by the function
=SUMIFS(C18:C23, B18:B23, ">3", C18:C23, ">500") is ____.

Correct Answer: (3) 1773

32. In the context of Computer Networks, which of the following best describes the transmission of a message using packet switching?

Correct Answer: (1) Data packets may follow different routes and may arrive at different times in different order

33. Which of the following statements is true about Number system?

Correct Answer: (3) (1011)₂ + (1001)₂ = (20)₁₀

34. Which of the following statements about Read Only Memory (ROM) are correct?

A. The contents of the memory remain intact even when the power to the ROM is turned off
B. ROM is often used to store the start-up instructions when the computer is first switched on
C. As the ROM becomes full, the processor has to continually access the hard disk
D. ROM is a volatile memory

Choose the correct answer from the options given below:

Correct Answer: (1) A and B only

35. Which of the following statements is true about computers?

Correct Answer: (4) The size of a computer monitor is measured diagonally across the screen

36. Which one of the following is used as a reference to measure the Global Warming Potential (GWP) of a greenhouse gas?

Correct Answer: (1) Carbon dioxide (CO₂)

37. Sustainable Development Goal 7 is related to

Correct Answer: (3) Affordable and Clean energy

38. Toxic substances that damage kidneys are called as

Correct Answer: (4) Nephrotoxic

39. Montreal Protocol is related to protection of

Correct Answer: (4) Stratospheric ozone layer

40. Which of the following are examples of organic pollutants in water?

A. Salts
B. Pesticides
C. Dioxins
D. Bases
E. Pigments

Choose the correct answer from the options given below:

Correct Answer: (4) B, C and E only