Spreadsheet functions in analysis – UGC NET Question

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.