UGC NET Questions (Paper – 1)

Statements A, B and D correctly present key capabilities of spreadsheets, whereas statement C is false. Spreadsheets support formulas, functions, chart creation and conditional formatting, which together enable rich analysis. Filtering and sorting data are also standard features, so claiming they can never be used for such tasks is incorrect. Therefore the combination A, B and D only is correct.

Option A:
Option A is correct because it identifies all the relevant true statements and excludes the incorrect one. It reflects how spreadsheets are commonly used in education and research for calculations, visualisation and highlighting patterns.

Option B:
Option B is incorrect because it includes only A and B as correct, omitting D. Conditional formatting described in D is a powerful tool for emphasising particular values and should be part of a complete answer.

Option C:
Option C is incorrect because it lists only B and D as correct and leaves out A. Statement A about formulas and functions is fundamental to understanding spreadsheets as analytical tools. Excluding it makes the option incomplete.

Option D:
Option D is incorrect because it treats all four statements as correct and accepts C. Since C denies the widely used filtering and sorting capabilities of spreadsheets, this combination cannot be accepted.

Statement B is the only wrong statement because dashboards do not replace the teacher’s responsibility to interpret data thoughtfully. A, C and D recognise that dashboards visualise indicators, enable filtering and still require careful reading to avoid misinterpretation. Teachers must combine dashboard information with contextual knowledge before acting. Therefore, the combination that selects only B as wrong is correct.

Option A:
Option A is incorrect because it groups A and B as wrong statements. A is true, since visualising attendance and performance is a primary function of educational dashboards. Including A among wrong statements misrepresents their purpose.

Option B:
Option B is correct because it isolates B, which wrongly implies that interpretation is no longer needed, and implicitly accepts A, C and D as accurate. It highlights that data tools supplement but do not replace professional judgement.

Option C:
Option C is incorrect because it lists B and C as wrong. C is true, as many dashboards support filtering by different variables to reveal trends, so treating it as wrong contradicts common features of analytics tools.

Option D:
Option D is incorrect because it groups B and D as wrong statements. While B is wrong, D correctly warns that misreading dashboards can lead to poor decisions, so this combination misclassifies a valid caution as incorrect.