SolveNCERT
SolveNCERT
Class 9 · Information TechnologyNCERT 2026 Revised Syllabus

Chapter 4: Electronic Spreadsheet (17925CH04)

Multiple Choice Questions — 14 questions with step-by-step answers.

Multiple Choice Questions(14 questions)

1

Which of the following technique can be used to allow only date value in cell?

  1. a.(a) Data formatting
  2. b.(b) Data sorting
  3. c.(c) Data filtering
  4. d.(d) Data validation

School Level Solution

Ans.
(d) Data validation restricts cell entries to a specific type, such as dates only.
2

Which of the following options when selected deletes all data validation?

  1. a.(a) Delete formatting
  2. b.(b) Delete all
  3. c.(c) Delete formula
  4. d.(d) Delete me

School Level Solution

Ans.
(b) Delete all removes all data validation rules from a cell.
3

We can replace multiple occurrences of a word using which of the following facilities of Calc?

  1. a.(a) Find and replace
  2. b.(b) By replace only
  3. c.(c) By copy command
  4. d.(d) By preview command

School Level Solution

Ans.
(a) Find and replace lets you replace multiple occurrences of a word at once.
4

What is the name of mechanism to arrange the data in a particular order?

  1. a.(a) Sorting
  2. b.(b) Searching
  3. c.(c) Filtering
  4. d.(d) Validating

School Level Solution

Ans.
(a) Sorting arranges data in ascending or descending order.
5

What is the name of mechanism to filter out unnecessary data?

  1. a.(a) Sorting
  2. b.(b) Searching
  3. c.(c) Filtering
  4. d.(d) Validating

School Level Solution

Ans.
(c) Filtering is the mechanism used to display only the required data and filter out unnecessary records.
6

Which of the following type of package does Calc refer to?

  1. a.(a) Spreadsheet
  2. b.(b) Double sheet
  3. c.(c) Multi-sheet
  4. d.(d) Cannot determine

School Level Solution

Ans.
As per the answer key given in the source material, the correct answer is (d) Cannot determine.
7

Which of the following is an extension of a worksheet created in Calc?

  1. a.(a) .ods
  2. b.(b) .odd
  3. c.(c) .xls
  4. d.(d) .obj

School Level Solution

Ans.
(a) .ods is the default extension of a LibreOffice Calc worksheet.
8

How can one calculate the total of values entered in a worksheet column?

  1. a.(a) By manual entry
  2. b.(b) By auto-sum
  3. c.(c) By formula
  4. d.(d) By sum function

School Level Solution

Ans.
(d) By sum function — the SUM function totals values in a column.
9

If we move a cell containing a formula having reference to another cell, what will happen to the cell numbers used in the formula?

  1. a.(a) The cell row and columns are changed at destination.
  2. b.(b) The cell row change at destination.
  3. c.(c) The cell columns are changed at destination.
  4. d.(d) No change will occur

School Level Solution

Ans.
(c) The cell columns are changed at destination when a formula cell is moved.
10

What is the correct way to enter a function in Calc?

  1. a.(a) Directly typing function name in a cell
  2. b.(b) Using function wizard or selecting from toolbar
  3. c.(c) Both (a) and (b)
  4. d.(d) Depends on the function

School Level Solution

Ans.
(d) Depends on the function — some functions are simple enough to type directly, others need the wizard.
11

A function should start with ______.

  1. a.(a) '=' sign
  2. b.(b) alphabets
  3. c.(c) numbers
  4. d.(d) All of these

School Level Solution

Ans.
(a) '=' sign — every function/formula in Calc starts with an equal sign.
12

Which of the following option is used to print a chart?

  1. a.(a) Insert → Chart
  2. b.(b) File → View
  3. c.(c) File → Print
  4. d.(d) View → Chart

School Level Solution

Ans.
(c) File → Print is the command used to print the chart; Insert → Chart is used to create a chart.
13

How many axes does charts in Calc have?

  1. a.(a) Two
  2. b.(b) Three
  3. c.(c) Two or three
  4. d.(d) Four

School Level Solution

Ans.
(a) Two — the X-axis and the Y-axis.
14

The chart preview can be seen in ______.

  1. a.(a) Page preview
  2. b.(b) Chart preview
  3. c.(c) Export chart
  4. d.(d) All of these

School Level Solution

Ans.
(d) All of these options can show a chart preview.

Other Chapters