**Electronic Spreadsheet Class 9 Solutions**

**Electronic Spreadsheet Class 9 Solutions**

**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**

**Electronic Spreadsheet Class 9 Solutions**

## 6) Which of the following type of package does Calc refer to?

**(a) Spreadsheet **

**(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**

## 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**

**Ans. We can calculate the total of values by all the methods given above (a, b, c, d)**

## 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 occur.**

## 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**

**Electronic Spreadsheet Class 9 Solutions**

## 11) A function should start with *______*.

*______***(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**

**Electronic Spreadsheet Class 9 Solutions**

**B. Fill in the blanks**

**1) **The column immediately next to column “Z” is **AA**.

**2) **The default extension of a workbook created using a LibreOffice Calc spreadsheet is** .ods.**

**3) **The spreadsheet feature used to continue the series is called as** Fill Handle.**

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

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

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

**7) **$A1$B2 is an example of **mixed** referencing in spreadsheet software**.**

**8) **Numbers entered into a cell are automatically** right **aligned.

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

**10) **In **relative** referencing, the reference changes rows and columns automatically when it is copied to a new cell**.**

**Electronic Spreadsheet Class 9 Solutions**

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

**1) **A cell is a combination of row and column**.** **(False)**

**2) **A spreadsheet is also called as worksheet. **(True)**

**3) **There are ‘n’ number of sheets in a spreadsheet**.** **(False)**

**4) **In a spreadsheet, we can change the column width and row height. **(True)**

**5) **$A1$B2 is an example of mixed referencing**.** **(True)**

**Electronic Spreadsheet Class 9 Solutions**

**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?

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

**Ans. -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?

**Ans. =$B$5+D5**

## 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?

**Ans.** **=$B5 + 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?

**Ans. =$B5 + D$5**

**Electronic Spreadsheet Class 9 Solutions**

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

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

**Ans. The document created in a spreadsheet application is called Workbook.**

## Q2. What are the steps to create a new spreadsheet?

**Ans. New Spreadsheet can be created in following ways :**

**Method 1 : **

**Click on File.****Click on New.****Click on Spreadsheet.****New spreadsheet will open**

**Method 2 :**

**Press Ctrl + N to open new spreadsheet.**

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

**Ans. Spreadsheet is a computer application which helps in :**

**Tabulation of data****Simple mathematical calculations****Complex calculations using formula and functions****Arranging data in ascending and descending order (sorting)****Filtering the required data****Check the validity of data**

**Worksheet : A Worksheet or sheet is a single page in Spreadsheet Application. Each sheet can have many individual cells arranged in rows and columns. The sheet tab shows its default name as Sheet1, Sheet2 etc.**

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

**Ans. Default name of Worksheet is Sheet1. It can be renamed as follows**

**Right click on Sheet tab.****Select Rename option from context menu.****Type the name and click OK.**

**OR**

**Select Rename option from Sheet menu.****Type the name and click OK.**

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

**Ans. Steps to insert worksheet are :**

**Select Insert Sheet option from sheet menu.****Specify the position(Before or After current sheet) and number of sheets in Insert sheet dialog box.****Click OK**

**Steps to delete the worksheet are :**

**Right Click on a sheet tab which you want to delete.****Select Delete Sheet option from the context menu.****Click Yes on Confirmation box.**

**OR**

**Click on a sheet tab which you want to delete.****Select Delete Sheet option from the Sheet menu****Click Yes on Confirmation box.**

**Electronic Spreadsheet Class 9 Solutions**

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

**Ans. The currently selected cell is called an active cell. To delete the contents of an active cell, press delete button from the keyboard.**

## Q7. What is relative and absolute cell address in the spreadsheet?

**Ans. A Cell address which changes when we copy it from one cell and paste it on another cell is called relative cell address. for example =B2**

**A Cell address which does not changes when we copy it from one cell and paste it on another cell is called absolute cell address. for example =$B$2**

## Q8. Explain any two operations performed on data in a spreadsheet.

**Ans. Any two operations performed on data in a spreadsheet are :**

**a) Addition : LibreOffice Calc uses plus(+) Operator for addition of two or more than two numbers. for example =B1+C1.**

**b) Subtraction : LibreOffice Calc uses minus(-) Operator for subtraction of two numbers. for example =B1 – C1.**

## Q9. How do formulae work in a spreadsheet?

**Ans. 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. for example = A1 + B1 adds the values of cell A1 and B1**

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

**Ans. Yes we can include more than one mathematical operators in a formula for example = (A1 + B1) – C1**

**Electronic Spreadsheet Class 9 Solutions**

## Q11. How to make visible the desired toolbar in a spreadsheet?

**Ans. Steps to make visible the desired toolbar in a spreadsheet are :**

**Select Toolbar option from the view menu.****Click on the desired toolbar from the list of toolbars**.

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

**Ans. Following are the three mathematical functions**.

Function Name | Syntax | Example |

SUM | SUM(Number1,Number2,…..) | =SUM(3, 6, 5) Result : 14 |

POWER | POWER(Base, Exponent) | =POWER(2,3)Result : 8 =POWER(3, 2) Result : 9 |

SQRT | SQRT(Number) | =SQRT(16)Result : 4 =SQRT(25) Result : 5 |

**Electronic Spreadsheet Class 9 Solutions**

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

**Ans. Following are the three statistical functions in spreadsheet :**

Function Name | Syntax | Example |

AVERAGE | AVERAGE(Number1,Number2,….)It returns the average of the number entered as argument | =AVERAGE(3, 6, 9)Result : 6 |

MAX | MAX(Number1,Number2,……)It returns the largest of the numberentered as argument | =MAX(3, 56, 45)Result : 56 |

MIN | MIN(Number1,Number2,……)It returns the smallest of the numberentered as argument | =MIN(13, 56, 45)Result : 13 |

COUNT | COUNT(Number1,Number2,……)It returns how many numbers are given/passed as argument. | =COUNT(3, 56, 45)Result : 3 |

**Electronic Spreadsheet Class 9 Solutions**

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

**Ans. Following are the three decision making functions in spreadsheet.**

Function Name | Syntax | Example |

IF | IF(Test, Then Value, Otherwise Value) | =IF(3>7, “Hello”, “Bye”)Result : Bye |

IFERROR | IFERROR(Value, Alternative Value)It returns value, if there is no error in value else Alternative Value | =IFERROR(7, 2+3)Result : 7 |

IFS | IFS(Test1, Result1, Test2, Result2 …)It checks one or more conditions and returns avalue corresponding to the first true conditions | =IFS(35 > 6,True, 9 > 45,False)Result : True ie 1 |

**Electronic Spreadsheet Class 9 Solutions**

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

**Ans. Following are the three date and time functions in spreadsheet :**

Function Name | Syntax | Example |

NOW | NOW( )It returns the current date and time of the computer | =NOW( )Result : (current date and time) |

TODAY | TODAY( )It returns the current date of the computer | =TODAY( )Result : (current date ) |

EASTERSUNDAY | (Year)=EASTERSUNDAYIt Returns the date of Easter Sunday in a given year | =EASTERSUNDAY(06/17/2021)Result : 04/04/21 |

**Electronic Spreadsheet Class 9 Solutions**

**Electronic Spreadsheet Class 9 Solutions**

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

Function Name | Syntax | Example |

NOT | NOT(Logical Value)It negates the truth. If the condition is True, it return False and Vice Versa | =NOT(78 > 72)Result : False |

AND | AND(Logical Value 1, 2Logical Value ……)It returns True, if all conditions/arguments are True | =AND(35 > 6, 90 > 45)Result : True |

OR | OR(Logical Value 1, 2Logical Value ……)It returns True, if any of the given conditions/arguments are True | =OR(35 > 6, 9 > 45)Result : True |

**Electronic Spreadsheet Class 9 Solutions**

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

**Ans. Following are the three string functions in spreadsheet.**

Function Name | Syntax | Example |

LEN | LEN(Text )It returns the length of the text/string | =LEN(“Spreadsheet” )Result : 11 |

LOWER | LOWER(Text )It converts the text into Lower Case | =LOWER(“RAMAN”)Result : raman |

UPPER | (Text)=UPPERIt converts the text into Upper Case | =UPPER(“raman”)Result : RAMAN |

**Electronic Spreadsheet Class 9 Solutions**

## Q18. Explain the advantages of drawing a chart in Calc.

**Ans. Advantages of drawing a chart in Calc are :**

**It summarizes large data into graphical form.****It gives better understanding of trends or comparison to audience.****It easily compares two or more data values.**

## Q19. Explain in one line each the various types of charts.

**Ans. Various types of charts are**

Type | Purpose |

Column Chart | Comparing classes of data items in group. This type shows a bar chart with vertical bars. The height of each bar is proportional to its value |

Bar Chart | Comparing classes of data items in group. This type shows abar chart with horizontal bars. The length of each bar is proportional to its value |

Line Chart | A line chart shows values as points on the y axis. The x axis shows categories. |

Pie Chart | A pie chart shows values as circular sectors of the total circle. The length of the arc, or the area of each sector, is proportional to its value. |

XY Scatter Chart | An XY chart is based on one data series. Each value pair (x|y) is shown as a point in a coordinate system. |

**Electronic Spreadsheet Class 9 Solutions**

## Q20. Write the steps to insert a chart in Calc.

**Ans. 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**

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

**Ans. 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**

**Electronic Spreadsheet Class 9 Solutions**

**Electronic Spreadsheet Class 9 Solutions**

**Electronic Spreadsheet Class 9 Solutions**

**Disclaimer : I tried to give you the correct “Electronic Spreadsheet Class 9 Solutions**”

**, but if you feel that there is/are mistakes in “**“.

**Electronic Spreadsheet Class 9 Solutions**” given above, you can directly contact me at csiplearninghub@gmail.com. Book and Study material available on CBSE official website are used as an idea to create above “**Electronic Spreadsheet Class 9 Solutions****All the answers of**

**“**“**Electronic Spreadsheet Class 9 Solutions****are in reference with LibreOffice**.

**Important Links of Class IX**

**Unit 1 : Introduction to IT–ITeS Industry BOOK SOLUTIONS**

**Unit 1 : Introduction to IT–ITeS Industry NOTES**

**Unit 3 : Digital Documentation NOTES**

**Unit 3 : Digital Documentation BOOK SOLUTIONS**

**Unit 3 : Digital Documentation MCQ**