**Electronic Spreadsheet Class 9 Questions and Answers**

## Q1. What do you mean by Spreadsheet/Electronic Spreadsheet?

**Ans. A spreadsheet is a grid which interactively manages and organises data in rows and columns. It is also called as Electronic Spreadsheet.**

## Q2. Write three uses of spreadsheet.

**Ans. Spreadsheet is used for:**

**Managing financial and accounting documents.****Creating data reports, generating invoices.****Data analysis from scientific and statistical researches.**

## Q3. List any four activities which can be done accurately or efficiently on Libre Office Calc.

**Ans. Four activities are :**

**Filtering the required data.****Calculations using formula and functions.****Check the validity of data.****Arranging data in ascending and descending order.**

## Q4. Write any three Spreadsheet software.

**Ans. Three Spreadsheet software are :**

**Microsoft Excel****LibreOffice Calc****OpenOfficeCalc****Apple Inc. Numbers**

## Q5. In which operating system Libre Office installed by default?

**Ans. Linux(Ubuntu)**

## Q6. Name any three components of Libre Office.

**Ans. Three components of Libre Office are:**

**LibreOffice Calc****LibreOffice Writer****LibreOffice Impress**

## Q7. How to start the LibreOffice Calc in Windows?

**Ans. Steps to start the LibreOffice Calc in Windows are:**

**Double click the shortcut of LibreOffice on the Desktop.**

**OR**

**Click the window menu, select LibreOffice application, then click LibreOffice Calc**.

## Q8. How to start the LibreOffice Calc in Linux?

**Ans. In Ubuntu Linux, find the Calc icon on application launcher or search it by clicking on â€œShow Application” and then click on icon.**

## Q9. Name any seven parts of User interface of Libre Office Calc.

**Ans. Seven parts of User interface of Libre Office Calc are:**

**Quick Access Tool bar****Title bar****Ribbon****Control Buttons****Name Box****Formula bar****Formatting Tool bar****Zoom Control****Column Heading****Row Heading.**

## Q10. Identify the following components of LibreOffice Calc Interface.

**Ans. Name of Components are**

**A – Name Box****B – Vertical Scroll Bar****C – Zoom Control****D – Quick Access Tool Bar****E – Status Bar****F – Formula Bar**

**Electronic Spreadsheet Class 9 Questions and Answers**

## Q11. Name the bar which is located at the top of the Libre Office Calc window.

**Ans. Title bar**

## Q12. ______________ bar shows the name of the current spreadsheet.

**Ans. Title**

## Q13. What is the default name of the first file opened in Libre Office Calc?

**Ans. Untitled 1**

## Q14. Name any four items/options available on Menu bar.

**Ans. Four items/options available on Menu bar are : (write any four)**

**File****Edit****Insert****View****Format****Styles**

## Q15. Name and explain in brief any two toolbars which provide a wide range of common commands and functions in Libre Office Calc.

**Ans. Two toolbars are :**

**1. Standard Toolbar : The standard tool bar shows the icons for most common operations, such as editing, arranging, filtering, etc.**

**2. Formatting Toolbar : It includes buttons for font selection, size of text, alignment, cell value formatting and indentation, etc.**

**Electronic Spreadsheet Class 9 Questions and Answers**

## Q16. What do you mean by Tooltip?

**Ans. When we place the mouse cursor over any icon, it displays a small box called a tooltip. It gives a brief explanation of the icon function.**

## Q17. What do you mean by Worksheet in Calc?

**Ans. The worksheet in Calc is also referred to as spreadsheet. Each sheet can have many individual cells arranged in rows and columns.**

## Q18. Differentiate between Row and Column.

**Ans. Differences are:**

Row | Column |

The horizontal lines in worksheet are called rows | The vertical lines in worksheet are called columns |

Row headings are represented by numbers like 1, 2, 3 etc. | Column headings are shown by Capital Alphabet like A, B, C etc. |

## Q19. Name the basic element or building block of spreadsheet.

**Ans. Cell**

## Q20. What do you mean by Cell?

**Ans. The intersection of a row and column is called a cell.**

**Electronic Spreadsheet Class 9 Questions and Answers**

## Q21. What do you mean by Active Cell?

**Ans. The selected cell is called Active Cell. It is always highlighted, with a thick border. The address of the active cell is displayed in the name box.**

## Q22. Write the cell address of the following

**First row and first column â€¦â€¦â€¦..****First column and last row â€¦â€¦â€¦â€¦****First row and last column â€¦â€¦â€¦..****Last column first row â€¦â€¦..****Seventh column and tenth row â€¦â€¦.****Tenth column and nineteenth row â€¦â€¦..****The cell address LK89 is situated in row numberâ€¦…… and column letter â€¦…..**

**Ans. **

**A1****A1048576****AMJ1****AMJ1****G10****J19****89 and LK**

## Q23. Write the shortcut to move the cell to the end of the data range in a particular direction.

**Ans. Ctrl + Arrow Keys**

## Q24. Write the shortcut to move the cell pointer to A1 position.

**Ans. Ctrl + Home**

## Q25. Write the shortcut to move the cell pointer to bottom right cell of the data range.

**Ans. Ctrl + End**

## Q26. What do you mean by Range of cells?

**Ans. A block of adjacent cells in a worksheet which is highlighted or selected is called a range of cells**. **for example A1 : C3**

## Q27. Identify the following range of cells as Row range, Column range, Row and Column range.

**A1 : A7****A1 : D1****A3 : D7****B4 : B12****C9 : J9**

**Ans. **

**A1 : A7 – – – – – Column Range****A1 : D1 – – – – – Row Range****A3 : D7 – – – – – Row and Column Range****B4 : B12 – – – – – Column Range****C9 : J9 – – – – – Row Range**

**Electronic Spreadsheet Class 9 Questions and Answers**

## Q28. Answer the questions based on the following worksheet.

**What is the address of the first cell represented by Range1?****What is the address of the last cell represented by Range1?****Write the cell range represented by Range1.****Write the cell range represented by Range 2.****What is the name of the cell range along a row?****What is the name of the cell range along a column?****Write the cell range represented by Range 3.****Give the number of cells in the cell range represented by Range 3.**

Ans. 1. B5 2. D5 3. B5 : D5 4. F5 : F11 5. Range 1 6. Range 2 7. B7 : C12 8. 12

## Q29. Name the three types of data that can be entered in a cell.

**Ans. Three types of data that can be entered in a cell are :**

**Label****Values****Formulae**

## Q30. What do you mean by Formula in Calc?

**Ans. Any expressions that begins with an equals to sign (â€˜=â€™) is treated as formula. for example =A1 + B1**

## Q31. Evaluate the expression = (5*4)^2

**Ans. 400**

## Q32. Evaluate the following equations using operator precedence and then test the result in the spreadsheet.

**8-4/2****5*5+8****3+5*4****2^5+8****3+2^2****5+6*2^2****8/4*4****-4/2+2****1+2^2-2****4*3/2**

Ans. 1. 6 2. 33 3. 23 4. 40 5. 7 6. 29 7. 8 8. 0 9. 3 10. 6

**Electronic Spreadsheet Class 9 Questions and Answers**

## Q33. If you forgot to put the â€˜=â€™ before the formula, it will be treated as a ________________

**Ans. Label**

## Q34. Identify the correct formula from the following :

**=A1 + B1****B2 = C1 * 2****B1 + C1*4****=A1 = D3**

**Ans. Correct formula is = A1 + B1**

## Q35. Write the steps to insert a column before any column.

**Ans. To insert a column before any column, position the cursor on any cell of the column before which you want to insert the column and selectSheet â†’ Insert Columns â†’ Columns â†’ Columns left**

## Q36. What do you mean by Function in Calc?

**Ans. A function is a predefined formula which help to do mathematical, statistical operations.**

## Q37. Explain the following functions with examples:

**sum****average****max****min****count**

**Ans. **

**1. Sum : This function adds the values contained in a range of cells. for example = sum(A1 : A5) will add all the values of cell A1, A2, A3, A4 and A5.**

**2. Average : This function finds out the average of the values contained in a range of cell. for example =average(A1 : A5) will return the average of values present in cell A1, A2, A3, A4 and A5. **

**3. Max : This function return the largest value contained in a range of cells. for example =max(A1 : A5) will return the largest value present in cell A1, A2, A3, A4 and A5. **

**4. Min : This function return the smallest value contained in a range of cells. for example =min(A1 : A5) will return the smallest value present in cell A1, A2, A3, A4 and A5. **

**5. Count : This function counts the number of non-empty cells within a range of cells. for example =count(A1 : A5) will return 5, if all cells contain some any value.**

**Electronic Spreadsheet Class 9 Questions and Answers**

## Q38. Write the output of the following on the basis of the given screenshot.

**=SUM (A1,B1,C1)****=SUM(A1:C1)****=SUM(A1:C1,B2)****=SUM(B1:C2)****=SUM(A1:A3,C1:C3)****=AVERAGE (A1,B1,C1)****=AVERAGE (A1:C1)****=AVERAGE (A1:C1,B2)****=AVERAGE (B1:C2)****=AVERAGE (A1:A3,C1:C3)****=MAX(A1,B2,C1)****=MAX(A2:C2,B3)****=MAX(A1:C1)****=MAX(A1,B1:C2)****=MIN(A1,B2,C1)****=MIN(A2:C2,B3)****=MIN(A1:C1)****=MIN(A1,B1:C2)****=COUNT(A1,B1)****=COUNT(A1:C1)****=COUNT(A1:A4)****=COUNT(A1:C1,B2)****=COUNT(B1:C3)****=COUNT(A1:A3,C1:C3)**

Ans. 1. 17 2. 17 3. 24 4. 23 5. 37 6. 5.66 7. 5.66 8. 6.33 9. 5.75 10. 6.16 11. 7 12. 8 13. 7 14. 7 15. 5 16. 4 17. 5 18. 4 19. 2 20. 3 21. 3 22. 4 23. 6 24. 6

**Electronic Spreadsheet Class 9 Questions and Answers**

## Q39. Write the shortcut to open Format cell dialog box.

**Ans. Ctrl + 1**

## Q40. Write the steps to format a cell to the required number of decimal places.

**Ans. The steps to format a cell to the required number of decimal places are :**

**Select the range of cells.****Open the â€˜format cells dialogâ€™ box****Click the â€˜Numberâ€™ tab****Select the â€˜Numberâ€™****Change the decimal places as required****Click â€˜OKâ€™**

## Q41. Write the steps to format a range of cells as text.

**Ans. Steps to format a range of cells as text:**

**Select the range of cells****Open the â€˜format cells dialogâ€™ box****Click the Number tab****Select Text****Click â€˜OKâ€™****Enter numbers**

## Q42. Aman is writing telephone number along with STD code (starting from zero ‘0’). He noticed that the first digit zero (â€˜0â€™), disappears from the telephone number. Write the reason for this. What can be done to store telephone number starting from zero in a cell?

**Ans. This is because the telephone number is stored as a numeric value, and the numeric value does not have a preceding zero. **

**We can store telephone number starting from zero in a cell by formatting the cell consisting of telephone number as â€˜textâ€™.**

## Q43. Write answers for the following queries using functions.

**1. Write the formula in E2 to find the total marks scored by HARMAN.**

**Ans. =sum(B2 : D2)**

**2. Write the formula in F2 to find the average marks scored by HARMAN.**

** Ans. =average(B2 : D2) **

**3. Write the formula in cell B7 to find the highest score in Hindi.**

**Ans. =max(B2 : B6)**

**4. Write the formula in cell B8 to find the total number of students who appeared in Hindi?**

** Ans. =count(B2 : B6) **

**5. Write the formula in cell B9 to find the lowest score in Hindi.**

** Ans. =min(B2 : B6) **

**6. How will you find the lowest score in English and Maths? **

**Ans. We can find the lowest score in English and Maths by any of the following:**

**1. Drag the formula from B9 to D9**

**OR**

**2. Copy paste the formula from B9 to C9 and D9.**

**OR**

**3. Write formula =min(C2 : C6) in C9 and =min(D2 : D6) in D9**

**7. How will you find the highest score in Hindi, English and Maths?**

**Ans. We can find the highest score in Hindi, English and Maths by writing the following formula:**

**for Hindi : =max(B2 : B6)**

**for English: =max(C2 : C6)**

**for Maths : =max(D2 : D6)**

**Electronic Spreadsheet Class 9 Questions and Answers**

## Q44. Name and explain the three types of data that can be entered in a cell.

**Ans. Three types of data that can be entered in a cell are :**

**1. Label : Label is any text entered by using a keyboard. It may be any letter, number, or special symbol. By default the labels are left aligned.**

**2. Values: The numerical data consisting of only numbers are called values. By default values are right aligned.**

**3. Formula: Any expressions that begins with an equals â€˜=â€™ is treated as formula. When a formula is entered in a cell the formula bar gets activated.**

## Q45. What is fill handle in Calc?

Ans. The small black square in the bottom-right corner of the selected cell or range is called a fill handle.

## Q46. Write the shortcut for the following:

**Copy the formula****Paste the formula**

**Ans. Shortcuts are :**

**Ctrl + C****Ctrl + V**

## Q47. What do you mean by Referencing in Calc?

**Ans. Referencing is the way to refer the cell or range of cell in a formula or function.**

## Q48. Name the three types of referencing in Calc.

**Ans. Three types of referencing in Calc are:**

**Relative referencing****Mixed referencing****Absolute referencing**

## Q49. Explain the Relative referencing in Calc with example.

**Ans. When you drag any formula in any row or column in any direction, the formula gets copied in the new cellwith the relative reference. for example =C1 is an example of relative referencing, as this formula changes automatically when we drag it vertically or horizontally.**

## Q50. What do you mean by mixed referencing in Calc?

**Ans. In Mixed Referencing, the $ sign is used before row number or column name to make it constant. for example = C$1 is an example of mixed referencing, as this formula changes only when you drag it horizontally.**

**Electronic Spreadsheet Class 9 Questions and Answers**

## Q51. What do you mean by absolute referencing in Calc?

**Ans. In Absolute referencing, a $ symbol is used before the column name as well as row number to make it constant in any formula. For example, $C$12, $D$5, etc. In this case, even if you drag your formula in anydirection, the cell name remains constant.**

## Q52. Identify the types of referencing from the following

**=C1****=D$2****=$W2****=$E$4**

**Ans. **

**Relative Referencing****Mixed Referencing****Mixed Referencing****Absolute Referencing**

## Q53. Name any four types of charts that can be created in Open Office Calc.

**Ans. Four types of Charts are :**

**Bar Chart****Column Chart****Pie Chart****Line Chart**

## Q54. Write the steps to create column chart in Calc.

**Ans. Steps to create column chart in Calc are:**

**Select the range of data.****Click on Insert â†’ Chart****Select the type of chart****Select the chart (Column Chart)****Click finish.**

**Electronic Spreadsheet Class 9 Questions and Answers**

## Q55. Create the following worksheet in calc and write the formula for the task given below.

**Enter the formula in G2 to calculate the total marks scored by Harman****Enter the formula in H2 to calculate the average scored by Harman.****Enter the formula in B9 to find out the highest score obtained for science.****Enter the formula in B10 to find out the lowest score obtained by students in each subject.****Enter the formula in B11 to find out the number of students present for each subject.****Enter the formula in B12 to find out the average score of each subject.**

Ans. 1. =sum(B2 : F2) 2. =average(B2 : F2) 3. =max(C2 : C8) 4. Write formula =min(B2 : B8) in B10 and then drag horizontally till F10. 5. Write formula =count(B2 : B8) in B11 and then drag horizontally till F11. 6. Write formula =average(B2 : B8) in B12 and then drag horizontally till F12.

**Electronic Spreadsheet Class 9 Questions and Answers**

## Q56. Create the following worksheet in calc and write the formula for the task given below.

**Write formula in D5 to calculate TA of Firoz Khan.****Write formula in E3 to calculate DA of Deepak Gautam.****Write formula in F8 to calculate HRA of Nikki Khanna.****Write formula in G7 to calculate CPF of Meena Kumari.****Write formula in C12 to display the highest Basic salary.****Write formula in I10 to calculate the gross salary of Vinay Kumar.****Write formula in H12 to calculate the average of Gross Salary of all employees.****Write formula in B12 to display the total number of employees.****Write formula in I11 to calculate average of TA, DA and HRA of Yusuf.****Write formula in C13 to calculate the sum of Basic Salary of all employees.**

Ans. 1. = 6/100 * C5 2. = 14/100 * C3 3. = 10/100 * C8 4. = 3/100 * C7 5. = max (C2 : C11) 6. = sum (D10 : G10) 7. = average (H2 : H11) 8. = count (B2 : B11) 9. = average (D11 : F11) 10. = sum(C2 : C11)

## Q57. Create the following worksheet in calc and write the formula for the task given below.

**Write formula in H2 to calculate total marks of Amit.****Write formula in C12 to calculate minimum marks in Hindi.****Write formula in H6 to display lowest marks of Gagan.****Write the cell range which has marks of Nikki (of all subjects).****Write formula in H7 to calculate percentage of Meena.(Assume all marks are out of 100)****Write formula in B12 to calculate total number of students.****Write formula in H9 to calculate the 10% of total marks of Tejpal.****Write formula in I12 to calculate average marks of Science subject.****Write formula in H2 to calculate total marks of subject English, Maths and Biology of Amit.****Write formula in H4 to calculate the average of best three marks of Chetna.**

Ans. 1. = sum (C2 : G2) 2. = min (C2 : C11) 3. = min (C6 : G6) 4. Cell range is C8 : G8 5. = sum (C7 : G7)/500 * 100 6. = count (B2 : B11) 7. = (C9 + D9 + E9 + F9 + G9) * 10/100 8. = average (E2 : E11) 9. = D2 + F2 + G2 10. = average(C4 + D4 + G4)

## Q58. Create the following worksheet in calc and write the formula for the task given below.

**Write formula in E2 to calculate the Total price (Quantity * Price) of Pencil.****Write formula in C7 to calculate total of Price values****Write formula in D7 to calculate maximum value of column ‘QTY’.****Write formula in C8 to calculate average of Price values.****Write formula in C9 to find lowest value of column ‘PRICE’.****= C4 * D4 will return ____________****Write the cell range of all the numerical values of column ‘QTY’****Write the cell address which stores largest/maximum value of column ‘PRICE’.****How many values are stored in range C2 : D6?**

Ans. 1. = C2 * D2 2. =sum (C2 : C6) 3. = max (D2 : D6) 4. = average (C2 : C6) 5. = min (C2 : C6) 6. 750 7. D2 : D6 8. C5 9. 10

**Electronic Spreadsheet Class 9 Questions and Answers**

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

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

**Electronic Spreadsheet Class 9 Questions and Answers**” 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 Questions and Answers****All the answers of**

**“**“**Electronic Spreadsheet Class 9 Questions and Answers****are in reference with LibreOffice**.

**Electronic Spreadsheet Class 9 Questions and Answers**

## **Important Links of Class IX**

**Click here to download book pdf**

**Unit 1 : Introduction to ITâ€“ITeS Industry**

**MCQ—————————–Notes———————Book Solution————— Practice Questions**

**Unit 2 : Data Entry and Keyboarding Skills**

**MCQ—————————–Notes———————Book Solution————— Practice Questions**

**Unit 3 : Digital Documentation**

**MCQ—————————–Notes———————Book Solution————— Practice Questions**

**Unit 4 : Electronic Spreadsheet**

**MCQ—————————–Notes———————Book Solution————— Practice Questions**

**Unit 5 : Digital Presentation **

**MCQ—————————–Notes———————Book Solution————— Practice Questions**