Class 9 · Information TechnologyNCERT 2026 Revised Syllabus
Chapter 4: Electronic Spreadsheet (17925CH04)
Multiple Choice Questions — 14 questions with step-by-step answers.
Jump to:
Multiple Choice Questions(14 questions)
1
Which of the following technique can be used to allow only date value in cell?
- a.(a) Data formatting
- b.(b) Data sorting
- c.(c) Data filtering
- 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?
- a.(a) Delete formatting
- b.(b) Delete all
- c.(c) Delete formula
- 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?
- a.(a) Find and replace
- b.(b) By replace only
- c.(c) By copy command
- 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?
- a.(a) Sorting
- b.(b) Searching
- c.(c) Filtering
- 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?
- a.(a) Sorting
- b.(b) Searching
- c.(c) Filtering
- 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?
- a.(a) Spreadsheet
- b.(b) Double sheet
- c.(c) Multi-sheet
- 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?
- a.(a) .ods
- b.(b) .odd
- c.(c) .xls
- 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?
- a.(a) By manual entry
- b.(b) By auto-sum
- c.(c) By formula
- 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?
- a.(a) The cell row and columns are changed at destination.
- b.(b) The cell row change at destination.
- c.(c) The cell columns are changed at destination.
- 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?
- a.(a) Directly typing function name in a cell
- b.(b) Using function wizard or selecting from toolbar
- c.(c) Both (a) and (b)
- 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 ______.
- a.(a) '=' sign
- b.(b) alphabets
- c.(c) numbers
- 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?
- a.(a) Insert → Chart
- b.(b) File → View
- c.(c) File → Print
- 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?
- a.(a) Two
- b.(b) Three
- c.(c) Two or three
- d.(d) Four
School Level Solution
Ans.
(a) Two — the X-axis and the Y-axis.
14
The chart preview can be seen in ______.
- a.(a) Page preview
- b.(b) Chart preview
- c.(c) Export chart
- d.(d) All of these
School Level Solution
Ans.
(d) All of these options can show a chart preview.