Class:9 Unit-4 Electronic Spreadsheet

  Unit – 4 Electronic Spreadsheet (Practical) Q1. Create the following worksheet in calc and write the formula for the task given below. 1.       Enter the formula in G2 to calculate the total marks scored by Harman 2.       Enter the formula in H2 to calculate the average scored by Harman. 3.       Enter the formula in B9 to find out the highest score obtained for science. 4.       Enter the formula in B10 to find out the lowest score obtained by students in each subject. 5.       Enter the formula in B11 to find out the number of students present for each subject. 6.       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 =co...

  Unit – 4 Electronic Spreadsheet   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: 1.       Managing financial and accounting documents. 2.       Creating data reports, generating invoices. 3.       Data analysis from scientific and statistical researches.   Q3. List any four activities which can be done accurately or efficiently on Open Office Calc. Ans. Four activities are : 1.       Filtering the required data. 2.       Calculations using formula and functions. 3.       Check the validity of data. 4.       Arranging data in ascending and descend...