UGC NET Questions (Paper – 1)

Spreadsheet software provides a grid of cells where users can enter labels, numbers and formulas that automatically compute results. It supports functions for financial analysis, statistics and data visualisation through charts. This makes it essential for tasks such as budgeting and data analysis. Thus, the type of software described in the stem is a spreadsheet.

Option A:
Option A, word processing, focuses on text formatting and document composition and lacks the specialised calculation and grid features central to spreadsheets.

Option B:
Option B is correct because Excel and similar tools are classic examples of spreadsheet software used for numerical analysis and tabular data management.

Option C:
Option C, presentation, software is designed to create slide shows and visual aids rather than detailed numerical computations.

Option D:
Option D, graphics, software concentrates on image creation and editing and does not provide the structured cell based environment mentioned.

Visual communication depends on images,symbols and graphic representations to convey meaning. Diagrams,charts and pictures help learners see relationships and structures at a glance. In the classroom,these tools enhance the visual aspect of communication. Therefore visual is the correct completion.

Option A:
Visual elements support learners who understand better through seeing,improving retention and clarity,so this option aligns well with the situation.

Option B:
Auditory communication focuses on sound and spoken words rather than images,so it is not the main aspect strengthened in the stem.

Option C:
Tactile communication would rely on touch or hands-on materials,which the question does not mention.

Option D:
Mass communication is not defined by the presence of charts but by audience size and media reach.

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.