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.

Chart creation in a spreadsheet involves selecting data and generating graphical representations such as bar charts or pie charts. This helps users visualise trends and comparisons more easily than raw numbers. ICT literacy includes understanding how to create and interpret such charts. Therefore, the appropriate term is chart creation.

Option A:
Option A is correct because creation describes the process of generating new charts from data, which is the focus of the stem.

Option B:
Option B, sorting, rearranges data according to certain criteria but does not produce graphs.

Option C:
Option C, filtering, temporarily hides certain rows to focus on subsets of data, again without generating visuals.

Option D:
Option D, validation, ensures that data entry follows rules and is not concerned with graphing.

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.

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.