SolveNCERT
SolveNCERT
HomeSolutionsInformation TechnologyCh 4
Class 9 · Information TechnologyNCERT 2026 Revised Syllabus

Chapter 4: Electronic Spreadsheet (17925CH04)

IT Code 402

Chapter code: 17925ch04 · Book: IT Code 402 · Class 9 Information Technology

Find complete NCERT solutions for Class 9 Information Technology, IT Code 402 Chapter 4. Every question has a clear, step-by-step answer for chapter code 17925CH04.

Jump to:

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) Row and columns changed at destination
  2. b.(b) Row changes at destination
  3. c.(c) Columns 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 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.

Fill in the Blanks(10 questions)

1

The column immediately next to column 'Z' is ________.

School Level Solution

Ans.
AA
2

The default extension of a workbook created using a LibreOffice Calc spreadsheet is ________.

School Level Solution

Ans.
.ods
3

The spreadsheet feature used to continue the series is called as ________.

School Level Solution

Ans.
Fill handle
4

The formula '=MIN(C1:C5)' stored in cell C6 when copied to cell D6 changes to ________.

School Level Solution

Ans.
=MIN(D1:D5)
5

The formula in cell A2 is =B2+C3. On copying this formula to cell C2, C2 will change to ________.

School Level Solution

Ans.
=D2+E3
6

The cell address of the cell formed by the intersection of the ninth column and the eighth row will be ________.

School Level Solution

Ans.
I8
7

$A1$B2 is an example of ________ referencing in spreadsheet software.

School Level Solution

Ans.
mixed
8

Numbers entered into a cell are automatically ________ aligned.

School Level Solution

Ans.
right
9

If A1:A5 contain the numbers 16, 10, 3, 25 and 6 then =Average(A1:A5;60) will display ________.

School Level Solution

Ans.
20
10

In ________ referencing, the reference changes rows and columns automatically when it is copied to a new cell.

School Level Solution

Ans.
Relative

True or False(5 questions)

1

A cell is a combination of row and column.

School Level Solution

Ans.
False
2

A spreadsheet is also called as worksheet.

School Level Solution

Ans.
True
3

There are 'n' number of sheets in a spreadsheet.

School Level Solution

Ans.
False
4

In a spreadsheet, we can change the column width and row height.

School Level Solution

Ans.
True
5

$A1$B2 is an example of mixed referencing.

School Level Solution

Ans.
True

Solve the Following in a Spreadsheet(5 questions)

1

Cell A1 contains the number 10 and B1 contains 5. What will be the contents of cell C1, if the formula =A1+B1*2^3 is entered in cell C1?

School Level Solution

Ans.
Following BODMAS order: 2^3=8, B18=58=40, then A1+40 = 10+40 = 50. So cell C1 will show 50.
2

The contents of Cell A1, B1, C1 and D1 are 5, –25, 30 and –35, respectively. What will be the value displayed in cell E1 which contains the formula =MIN(A1:D1).

School Level Solution

Ans.
MIN(A1:D1) finds the smallest value among 5, –25, 30 and –35. The smallest value is –35, so cell E1 will display –35.
3

Cell D5 contains the formula =$B$5+C5 and this formula is copied to cell E5, what will be the copied formula in cell E5?

School Level Solution

Ans.
=$B$5+D5 — the absolute reference $B$5 stays fixed, while the relative reference C5 changes to D5 as the column shifts by one.
4

Cell D5 contains the formula =$B5 + C5 and this formula is copied to cell E5, what will be the copied formula in cell E5?

School Level Solution

Ans.
=$B5+D5 — the column part of$B5 (mixed reference) stays fixed at B, and the relative reference C5 changes to D5.
5

Cell D5 contains the formula =$B5 + C$5 and this formula is copied to cell E6, what will be the copied formula in cell E6?

School Level Solution

Ans.
=$B6+D$5 — in $B5 the column B is fixed but row changes to 6; in C$5 the row 5 is fixed but column changes to D.

Short Answer Questions (50 words)(21 questions)

1

What do you call the document created in a spreadsheet application?

School Level Solution

Ans.
A document created in a spreadsheet application is called a workbook, which contains one or more worksheets (also called spreadsheets) made up of rows, columns and cells.
2

What are the steps to create a new spreadsheet?

School Level Solution

Ans.
Open LibreOffice Calc → click File → New → Spreadsheet (or press Ctrl+N). A new blank worksheet named Sheet1 opens, ready for entering data.
3

What is the difference between spreadsheet, worksheet and sheet?

School Level Solution

Ans.
A spreadsheet is the entire application/file (workbook); a worksheet (or sheet) is a single page of that workbook made up of rows and columns where data is entered.
4

What is the default name of the worksheet? How can it be renamed?

School Level Solution

Ans.
The default name is Sheet1, Sheet2, etc. To rename, double-click the sheet tab at the bottom, type the new name, and press Enter.
5

Write the steps to insert and delete the worksheet in Calc.

School Level Solution

Ans.
Insert: Right-click the sheet tab → Insert Sheet → set position and name → OK. Delete: Right-click the sheet tab → Delete Sheet → confirm Yes.
6

What is an active cell? How to delete the contents of an active cell?

School Level Solution

Ans.
An active cell is the currently selected cell, shown with a thick border, ready to accept data. To delete its contents, select the cell and press the Delete key.
7

What is relative and absolute cell address in the spreadsheet?

School Level Solution

Ans.
A relative address (e.g. B2) changes automatically when a formula is copied to another cell. An absolute address (e.g. $B$2) stays fixed and does not change on copying.
8

Explain any two operations performed on data in a spreadsheet.

School Level Solution

Ans.
Sorting arranges data in ascending or descending order based on a chosen column. Filtering displays only rows meeting specific criteria while hiding the rest of the data temporarily.
9

How do formulae work in a spreadsheet?

School Level Solution

Ans.
A formula always begins with an '=' sign followed by cell references, values and operators. Calc computes the result automatically and updates it whenever the referenced cell values change.
10

Can you include more than one mathematical operators in a formula?

School Level Solution

Ans.
Yes, a single formula can include multiple mathematical operators, such as =A1+B1*C1-D1/2, and Calc evaluates it following the standard BODMAS order of operations.
11

How to make visible the desired toolbar in a spreadsheet?

School Level Solution

Ans.
Go to the View menu → Toolbars → click on the required toolbar name (e.g. Formatting, Drawing) to place a tick mark and display it on screen.
12

Give the syntax and example of any three mathematical functions in spreadsheet.

School Level Solution

Ans.
• SUM: =SUM(A1:A5) – adds values • ROUND: =ROUND(A1,2) – rounds to 2 decimals • ABS: =ABS(A1) – gives absolute value
13

Give the syntax and example of any three statistical functions in spreadsheet.

School Level Solution

Ans.
• AVERAGE: =AVERAGE(A1:A5) – mean value • MAX: =MAX(A1:A5) – largest value • MIN: =MIN(A1:A5) – smallest value
14

Give the syntax and example of any three decision making functions in spreadsheet.

School Level Solution

Ans.
• IF: =IF(A1>50,"Pass","Fail") • AND: =AND(A1>0,B1>0) • OR: =OR(A1>0,B1>0)
15

Give the syntax and example of any three date and time functions in spreadsheet.

School Level Solution

Ans.
• TODAY: =TODAY() – current date • NOW: =NOW() – current date and time • DATE: =DATE(2024,1,26) – builds a date value
16

Give the syntax and example of any three logical functions in spreadsheet.

School Level Solution

Ans.
• NOT: =NOT(A1>10) • AND: =AND(A1>5,B1<20) • OR: =OR(A1="Yes",B1="Yes")
17

Give the syntax and example of any three string functions in spreadsheet.

School Level Solution

Ans.
• UPPER: =UPPER(A1) – converts to capital letters • LOWER: =LOWER(A1) – converts to small letters • LEN: =LEN(A1) – counts number of characters
18

Explain the advantages of drawing a chart in Calc.

School Level Solution

Ans.
Charts present numerical data visually, making trends, comparisons and patterns easier to understand at a glance than plain rows of numbers, and make reports more presentable.
19

Explain in one line each the various types of charts.

School Level Solution

Ans.
• Bar chart – compares values using horizontal/vertical bars • Pie chart – shows proportion of a whole • Line chart – shows trend over time • Area chart – shows volume of change over time
20

Write the steps to insert a chart in Calc.

School Level Solution

Ans.
Select the data range → click Insert menu → Chart → choose chart type in the wizard → set data range/series → add titles → click Finish to insert the chart.
21

Name and explain any five components of a chart in a spreadsheet package.

School Level Solution

Ans.
• Chart title – name of the chart • X-axis – shows categories • Y-axis – shows values • Legend – identifies data series by colour • Data series – the actual plotted values

Practical Exercise — How to Do(10 questions)

1

Cell addresses: first row–first column, first column–last row, first row–last column, seventh column–tenth row, tenth column–nineteenth row; in which row/column does LK89 sit? How should you answer?

School Level Solution

Ans.
Read addresses as Letters (column) + Number (row): A1; last row is 1048576 (A1048576); last column is XFD (XFD1); G = 7th letter → G10; J = 10th → J19. LK89 sits in row 89, column LK.
2

Range questions: first/last cell and A1-style range of Range1/Range2/Range3, name of row-wise and column-wise ranges, and cell count of Range3. How should you read them off the worksheet figure?

School Level Solution

Ans.
A range is top-left : bottom-right (e.g., B2:D5). A range along a row is called a row range; along a column, a column range. Count = rows × columns (e.g., 3 rows × 4 cols = 12 cells). Read each Range off Fig. 4.x the same way.
3

Evaluate by operator precedence, then verify in Calc: 8-4/2, 55+8, 3+54, 2^5+8, 3+2^2, 5+62^2, 8/44, -4/2+2, 1+2^2-2, 4*3/2. What are the results and the rule?

School Level Solution

Ans.
Apply ^ first, then ×/÷ left-to-right, then +/−: 8−2=6; 25+8=33; 3+20=23; 32+8=40; 3+4=7; 5+24=29; 2×4=8; −2+2=0; 1+4−2=3; 12/2=6. Type each with = first in Calc to verify.
4

Figure worksheets (Fig. 4.12, 4.17, 4.18): build each sheet, enter different values in the input cells (A2–C2 / B1 / B1–B2) and observe the formula columns. What should you watch?

School Level Solution

Ans.
Build the sheet exactly as figured with formulas referencing input cells. Change one input at a time and watch dependent results recalculate automatically — this live linkage is the point of the observation.
5

Functions drill (Fig. 4.22, HARMAN’s marks in 3 subjects): total in E2, average in F2, copy down; highest/lowest/count in Hindi (B7/B8/B9) and extend to English/Maths. Which formulas apply?

School Level Solution

Ans.
E2: =SUM(B2:D2); F2: =AVERAGE(B2:D2); drag the fill handle down to copy relatively. B7: =MAX(B2:B6); B9: =MIN(B2:B6); B8: =COUNT(B2:B6). Repeat MAX/MIN across the English and Maths columns.
6

Fill Handle drills (Fig. 4.30–4.33): drag days, months, natural/even/odd numbers to row 15; then =SUM(C2:G2) in H2 and =AVERAGE(C2:G2) in I2 dragged to row 11. What is the technique?

School Level Solution

Ans.
Click the seed cell(s) (select two cells for even/odd patterns) and drag the fill-handle square to row 15. For marks: type =SUM(C2:G2) in H2, =AVERAGE(C2:G2) in I2, then drag both down — references shift per row automatically.
7

Salary + range drills (Fig. 4.35/4.36 gross salary to row 11 with H12 total; Fig. 4.43 ranges, B8 totals, G3 totals, F3→F4 copy, averages; Harman science max/min/count/average in B9–B12). What is the method?

School Level Solution

Ans.
Enter D2–H2 formulas once, fill down to row 11, total in H12 with =SUM. For ranges: name the top-left:bottom-right cells; B8 total via addresses or =SUM; copy F3→F4 by drag or paste; B9–B12 via MAX/MIN/COUNT/AVERAGE down each subject column.
8

Explore tasks: count Save-As formats; 7 rainbow sheets (Violet… with matching tab colours); auto-fill negatives; two-date drag + monthly calendar; add your name to the dictionary. How?

School Level Solution

Ans.
Save As and count the format dropdown entries; reopen one to verify. + new sheets ×7, rename VIBGYOR, right-click tab → colour each. Drag negatives and 15-08-2013 + next date down 10 for series/calendar. Right-click your name → Add to Dictionary.
9

Project drills: implement a superstore-style shopping bill; your 6-subject marks sheet (total, average, %); Khushi/Diya/Kushaal list sorted by Class then name; August-birth filter. How?

School Level Solution

Ans.
Bill: item/rate/qty/amount table + =SUM total. Marks: six subjects, =SUM, =AVERAGE, % = total÷600×100. Friends list: Data → Sort by Class, then Name. August filter: Data → AutoFilter on Month-of-Birth = August.
10

Notes + validation + marksheet + charts: Help-based sorting/filtering notes; DOB 1–31 validation; school marksheet with % and grade; newspaper 3D pie; Y=3X+1 line chart; monthly bills comparison. What are the key steps?

School Level Solution

Ans.
Read Help on Sort/Filter/Validity into notes. DOB column: Data → Validity → Whole numbers 1–31. Marksheet: =AVERAGE, % and =IF grade slabs. Charts: select data → Insert → Chart (pie for newspapers, line for Y=3X+1, column/line for bills) and conclude which fits best (trends → line, shares → pie).

Other Chapters

12345