Spreadsheets for data analysis – UGC NET Question

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.