Spreadsheets for data analysis – UGC NET Question

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.