# Class 9 Information Technology 402 Unit 4 Electronic Spreadsheet NCERT Book Solution

### Unit 4 Electronic Spreadsheet Class 9 Book Solution

#### A. Multiple Choice Questions

1. Which of the following technique can be used to allow only date value in cell?
(a) Data formatting
(b) Data sorting
(c) Data filtering
(d) Data validation

2. Which of the following options when selected deletes all data validation?
(a) Delete formatting
(b) Delete all
(c) Delete formula
(d) Delete me

3. We can replace multiple occurrences of a word using which of the following facilities of Calc?
(a) Find and replace
(b) By replace only
(c) By copy command
(d) By preview command

4. What is the name of mechanism to arrange the data in a particular order?
(a) Sorting
(b) Searching
(c) Filtering
(d) Validating

5. What is the name of mechanism to filter out unnecessary data?
(a) Sorting
(b) Searching
(c) Filtering
(d) Validating

6. Which of the following type of package does Calc refer to?
(b) Double sheet
(c) Multi-sheet
(d) Cannot determine

7. Which of the following is an extension of a worksheet created in Calc?
(a) .ods
(b) .odd
(c) .xls
(d) .obj

##### Unit 4 Electronic Spreadsheet Class 9 Book Solution

8. How can one calculate the total of values entered in a worksheet column of?
(a) By manual entry
(b) By auto-sum
(c) By formula
(d) By sum function

Note: All options are possible.

9. If we move a cell containing a formula having reference to another cell in the worksheet what will happen to the cell numbers used in the formula?
(a) The cell row and columns are changed at destination.
(b) The cell row change at destination.
(c) The cell columns are changed at destination.
(d) No change will scour.

Answer: (a) The cell row and columns are changed at destination.

10. What is the correct way to enter a function in Calc?
(a) Directly typing function name in a cell
(b) Using function wizard or selecting from toolbar
(c) Both (a) and (b)
(d) Depends on the function

Answer: (c) Both (a) and (b)

##### Unit 4 Electronic Spreadsheet Class 9 Book Solution

(a) ‘=’ sign
(b) alphabets
(c) numbers
(d) All of the these

12. Which of the following option is used to print a chart?
(a) Insert → Chart
(b) File → View
(c) File → Print
(d) View → Chart

13. How many axes does charts in Calc have?
(a) Two
(b) Three
(c) Two or three
(d) Four

14. The chart preview can be seen in________________.
(a) Page preview
(b) Chart preview
(c) Export chart
(d) All of these

#### B. Fill in the blanks

1. The column immediately next to column “Z” is _______.

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

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

4. The formula “=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to _______.

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

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

7. \$A1\$B2 is an example of _________ referencing in spreadsheet software.

8. Numbers entered into a cell are automatically ________ aligned.

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

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

#### C. State whether the following statements are True or False

1. A cell is a combination of row and column.

2. A spreadsheet is also called as worksheet.

3. There are ‘n’ number of sheets in a spreadsheet.

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

5. \$A1\$B2 is an example of mixed referencing.

#### D. Solve the following in a spreadsheet

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?

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).

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?

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?

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?

#### E. Short answer questions (50 words)

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

2. What are the steps to create a new spreadsheet?

OR

Click on New icon in standard toolbar

OR

Click on File > New > Spreadsheet

3. What is the difference between spreadsheet, worksheet and sheet?

Answer: Spreadsheet:- Spreadsheet is a long sheet of rows and columns on the computer screen to do data analysis and calculation. In other words, a spreadsheet is a grid which interactively manages and organises data in rows and columns. It is also called as Electronic Spreadsheet.

Worksheet: The collection of Sheet is known as Worksheet. It is also known as spreadsheet.

Sheet:- Sheet is the actual page/document where you suppose to work. A sheet can have many individual cells arranged in rows and columns.

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

Answer: The default name of worksheet are Sheet1, Sheet2, Sheet3, …

To rename a sheet :

Right click on sheet tab > Select Rename option from context menu > Type the name and press Enter.

Method 2 :

Select the menu Sheet -> Rename Sheet > Type new name and press enter key.

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

• Right click on Sheet tab and select Insert Sheet OR Select Sheet -> Insert Sheet option
• Specify the position before or after current sheet, and number of sheets in insert sheet dialog box.
• Click on Ok

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

Answer: The cell which is ready to take data from the user is called the Active Cell.

This selected or activated cell is always highlighted, with a thick border. The address of the active cell is displayed in the name box.

To delete content from the active cell, press the delete button.

Answer: Referencing is the way to refer the formula or function
from one cell to the next cell along the row or column.

In Relative Referencing, when you drag any formula in any row or column in any direction, the formula gets copied in the new cell with the relative reference i.e it changes accordingly. Syntax of Relative referencing: ColumnName_RowNumber

Example: A1, B9, D156

8. Explain any two operations performed on data in a spreadsheet.

Comparison means comparing two values to find which value is equal, greater, smaller, etc.

Concatenation means adding two strings, by concatenating one string at the ends of another.

9. How do formulae work in a spreadsheet?

Answer: Any expressions that begins with an equals ‘=’ is treated as formula.

In the expression, the ‘=’ followed by values, cell address and functions are called as formula.

When a formula is entered in a cell in a worksheet the value of the
equation is displayed in the cell and the formula is shown in the formula bar.

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

11. How to make visible the desired toolbar a spreadsheet?

Answer: Select View -> Toolbars -> Required Toolbar name, to open the toolbar in a spreadsheet.

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

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

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

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

Answer: Three data and time functions

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

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

17. Explain the advantages of drawing a chart in Calc.

• (a) Easy to present and comprehend.
• (b) Easy to compare
• (c) Easy to analyse
• (d) An effective tool to communicate.

18. Explain in one line each the various types of charts.

.

19. Write the steps to insert a chart in Calc.

Answer: Steps to insert a chart in Calc are :

• Select the range of data.
• Click on Insert menu → Chart
• Select the type of chart.
• Click Finish

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

Answer: Components of a chart in a spreadsheet are : (Write any five)

• Chart Area of the Chart
• Plot Area of the Chart
• Data Points that are plotted in the chart
• Horizontal and Vertical Axis in the chart
• Legend of the chart
• Chart and Axis Title used in the chart
• Data Label for identifying details of data point in the chart