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.

Statements A, B, C, E and F all describe typical and useful aspects of spreadsheet use in education, while D is incorrect. Spreadsheets do organise data in tabular form, can calculate and recalculate values and can generate charts. Clear labels improve interpretation, and careless copying of formulas is a common source of mistakes. It is false to claim that spreadsheets can never exchange data with other tools, so D must be excluded, leaving A, B, C, E and F as the correct set.

Option A:
Option A is correct because it includes every true statement and excludes the single false one. It recognises both the strengths of spreadsheets and a common pitfall related to formula handling. This combination therefore matches the complete set of correct statements.

Option B:
Option B is incorrect because it omits E and F, ignoring readability and error risks. While A, B and C are accurate, they do not cover all aspects of good spreadsheet practice mentioned in the question. Hence this option is incomplete.

Option C:
Option C is incorrect because it leaves out A, which refers to the basic tabular structure that underpins spreadsheet work. Even though B, C, E and F are true, excluding A means the fundamental organisational role of spreadsheets is not acknowledged.

Option D:
Option D is incorrect because it omits B, thereby failing to recognise the importance of automatic recalculation using formulas. Without B, the computational power of spreadsheets is underrepresented, making the combination incomplete.