Class 9 · Information TechnologyNCERT 2026 Revised Syllabus
Chapter 4: Electronic Spreadsheet (17925CH04)
Short Answer Questions (50 words) — 21 questions with step-by-step answers.
Jump to:
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