SolveNCERT
SolveNCERT
HomeSolutionsInformation TechnologyCh 4Short Answer Questions (50 words)
Class 9 · Information TechnologyNCERT 2026 Revised Syllabus

Chapter 4: Electronic Spreadsheet (17925CH04)

Short Answer Questions (50 words) — 21 questions with step-by-step answers.

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

Other Chapters