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 and D accurately describe key capabilities of spreadsheet software, while statement C is false. Spreadsheets are designed to arrange data in tabular form, support formulas and functions and enable what-if analysis. They also provide tools for generating charts and graphs from tabular data, so claiming that charts cannot be generated is incorrect. Thus, the combination A, B and D only is correct.

Option A:
Option A is incorrect because it includes only A and B and omits D. Although A and B are true, D is also correct in highlighting the role of spreadsheets in data analysis and scenario testing. Leaving out a true statement makes this option incomplete.

Option B:
Option B is incorrect because it selects B and D only and omits A. Statement A is fundamental, describing the tabular structure of spreadsheets. Any answer that excludes this essential property fails to capture the full set of correct statements.

Option C:
Option C is correct because it groups A, B and D together and excludes C. It recognises that spreadsheets offer tables, functions and analytical tools. By leaving out the false statement denying chart creation, it accurately reflects spreadsheet features.

Option D:
Option D is incorrect because it treats all four statements as correct, thereby accepting C. Since C misrepresents spreadsheet capabilities regarding chart generation, the entire combination becomes invalid.