Class 9 IT Unit 4 Electronic Spreadsheet questions answers
E. Short answer questions ( 50 words)
1. What do you call the document created in a spreadsheet application ?
Ans: Workbook.
2. What are the steps to create a new spreadsheet ?
Ans: The steps to create a new spreadsheet are as follows-
i. Click on File
ii. Click on New
iii. Click on Spreadsheet. A new Spreadsheet will open.
3. What is the difference between spreadsheet, worksheet and sheet ?
Ans: Spreadsheet is a long sheet of rows and columns on the computer screen to do data analysis and calculation.
Worksheet or sheet is the single sheet or page displayed in a spreadsheet application.
4. What is the default name of the worksheet ? How can it be renamed ?
Ans: The default name of the worksheet is Sheet 1 .
It can be renamed by the steps given below-
i. Right click on the sheet tab
ii. Click on Rename option.
iii. Enter a new name for the worksheet.
iv. click on OK button.
2nd method:
i. Click on Sheet Menu.
ii. Click on Rename option.
iii. iii. Enter a new name for the worksheet.
iv. click on OK button.
5. Write the steps to insert and delete the worksheet in Calc ?
Ans: The steps to insert the worksheet in Calc are-
i. Click on sheet Menu
ii. Click on Insert Sheet option. Insert Sheet dialog box will be displayed.
iii. In the dialog box, Specify the position of the new sheet.
iv. Enter the number of new sheets to be inserted.
To delete the worksheet,
i. Right click on a particular sheet which is to be deleted. A context menu will appear.
ii. Click on delete sheet option. The worksheet will be deleted.
6. What is an active cell ? How to delete the contents of an active cell ?
Ans : The cell which is selected or activated is called an active cell.
To delete the contents of an active cell, select the cell and press delete key on the keyboard.
7. What is relative and absolute cell address in the spreadsheet ?
Ans: The cell address which changes automatically when we copy it to another cell, is called relative cell address whereas the cell address which remains fixed or constant even if we copy it to another cell in a workshhet is called absolute cell address.
8. Explain any two operations performed on data in a spreadsheet .
Ans: The two operations performed on data in a spreadsheet are
i. Addition and ii. Subtraction
i. Addition operation is used to add two or more numbers in a spreadsheet. We can perform addition using sum function or using + operator in a spreasheet.
For example : =sum(cell address of the first number : cell address of the last number) OR
=(number1 + number 2 + number 3 +……)
ii. Subtraction operation is used to subtract numbers in a spreadsheet. We can perform subtracti onusing imsub function or using – operator in a spreadsheet.
For example : =imsub(cell address of the 1st number, cell address of the 2nd number) OR
=(number1 or cell address of the 1st number – number 2 or cell address of the 2nd number )
9. How do formulae work in a spreadsheet ?
Ans: Any expression that starts with an equal (=) sign is treated as a formula in a spreadsheet. Spreadsheet formulas work by taking input values from cells, applying operations, and then returning a result in the cell where the formula is typed.
10. Can you include more than one mathematical operators in a formula ?
Ans: Yes, we can include more than one mathematical operators in a formula.
11. How to make visible the desired toolbar in a spreadsheet ?
Ans: To make visible the desired toolbar in a spreadsheet,
Click on View Menu and then on toolbars option. A list will appear with all the toolbars. Click on the desired toolbar which we want to make visible.
12. Give the syntax and example of any three mathematical functions in a spreadsheet.
Ans: i. =Sum ( cell address of 1st number: cell address of last number)
ii. =round(number, number of digits)
iii.=sqrt(number)
13. Give the syntax and example of any three statistical functions in a spreadsheet.
Ans: =Average(cell address of 1st number or number itself: cell address of last number or number itself)
iii. = Min(cell address of 1st number or number itself: cell address of last number or number itself)
iv. = Max(cell address of 1st number or number itself: cell address of last number or number itself)
14. Give the syntax and example of any three decision making functions in a spreadsheet.
Ans: i. IF()
Syntax: =IF(logical_test, value_if_true, value_if_false)
Example:
To check if the value in A1 is greater than 30: If yes, It will display pass otherwise fail.
=IF(A1 > 30, “Pass”, “Fail”)
ii. AND()
Syntax : =AND(logical_test1, logical_test2, …)
Example:
To check if A1 is greater than 70 and B1 is less than 100:
=AND(A1 > 70, B1 < 100)
It will display True if both the conditions are true.
iii. OR()
Syntax : =OR(logical_test1, logical_test2, …)
Example:
To check if A1 is greater than 50 or B1 is equal to 100:
=OR(A1 > 50, B1 = 100)
It will display True of any of the conditions is true.
15. Give the syntax and example of any three date and time functions in a spreadsheet.
Ans: i. TODAY ()
It displays today’s date.
Syntax:
=TODAY ()
Example: =TODAY ()
Result: 20-11-2025
ii. NOW ()
It Returns the current date and time.
Syntax:
=NOW ()
Example: =NOW ()
Result 20-11-2025 8:30
iii. DATE ()
It creates a date from separate year, month, and day values.
Syntax:
=DATE (year, month, day)
Example:
To create the date 15 March 2025:
=DATE (2025, 3, 15)
16. Give the syntax and example of any three logical functions in a spreadsheet.
Ans: : i. IF()
Syntax: =IF(logical_test, value_if_true, value_if_false)
Example:
To check if the value in A1 is greater than 30: If yes, It will display pass otherwise fail.
=IF(A1 > 30, “Pass”, “Fail”)
ii. AND()
Syntax : =AND(logical_test1, logical_test2, …)
Example:
To check if A1 is greater than 70 and B1 is less than 100:
=AND(A1 > 70, B1 < 100)
It will display True if both the conditions are true.
iii. OR()
Syntax : =OR(logical_test1, logical_test2, …)
Example:
To check if A1 is greater than 50 or B1 is equal to 100:
=OR(A1 > 50, B1 = 100)
It will display True of any of the conditions is true.
17. Give the syntax and example of any three string functions in a spreadsheet.
Ans: i. LEFT()
It extracts characters from the left side of a text string.
Syntax:
=LEFT(te xt, number_of_characters)
Example:
=LEFT (“HELLO”, 2)
Result: HE
ii. RIGHT ()
It extracts characters from the right side of a text string.
Syntax:
=RIGHT (text, number_of_characters)
Example:
=RIGHT (“COMPUTER”, 3)
Result: TER
3. CONCATENATE () / CONCAT ()
It joins two or more text strings together.
Syntax:
=CONCATENATE (text1, text2, …)
Example:
=CONCAT (“Good “, “Morning”)
Result: Good Morning
18. Explain the advantages of drawing a chart in Calc.
Ans: The advantages of drawing a chart in Calc are-
i. It makes data easier to understand
ii. It helps identify trends and relationships
iii. It Saves time in data analysis
19. Explain in one line each of the various types of charts.
Ans: 1. Column Chart : It shows data as vertical bars to compare values across categories.
2. Bar Chart : It displays data as horizontal bars for easy comparison between items.
3. Line Chart : It shows trends over time by connecting data points with lines.
4. Pie Chart : It represents parts of a whole as slices of a circle.
5. Area Chart : It displays trends over time with filled-in areas under the line.
20. Write the steps to insert a chart in Calc.
Ans : The steps to insert a chart in Calc are-
i. Select the range of data
ii. Click on Insert -> Chart option
iii. Select the type of chart
iv. Select the chart
v. Click on finish.
21. Name and explain any five components of a chart in a spreadsheet package.
Ans: i. Chart title
ii. Axis title
iii. Legend
iv. Data Labels
v. Chart Area
*****
Hello students,
Welcome to my site www.elearnersmentor.com. I have been in teaching profession since 2004. Presently I am working as a vocational subject teacher(IT) in a reputed govt. higher secondary school. Read more