Page 309 - Trackpad IT-402_Class-IX
P. 309

e.  J4=H4+I4, copy the formula for the rest of the students
                  f.  D12=MAX(D4:D11
                  g.  G12=MAX(G4:G11)
                  h.  J12=Max(J4:J11)
               6.  Explain any four types of charts.
              Ans.  i.   Column Chart: A column chart represents the data over a period of time in columns. Each column rises from X-axis and
                     indicates the value of a data. The measurement values are shown vertically as Y-axis.
                  ii.   Bar Chart: A bar chart represents the data in horizontal columns. The measurement of values are organised horizontally.
                     Stacked bar chart is a variation of bar charts.
                  iii.   Pie Chart: A pie chart represents the data or value of each item in proportion or percentage to the consolidated or the
                     sum value of all items. Pie chart displays single type of data item and is beneficial when the user wants to emphasize
                     value of a significant item. Pie charts highlights compare how each value relates proportionally to the whole.
                  iv.  X-Y (Scatter) Chart: X-Y (Scatter) chart displays the relationships among the numeric values of several data series. This
                     chart shows uneven intervals or clusters of data and is commonly used to represent scientific data.

               7.  Write short notes on the following:
                    i.  Formulae Bar       ii.  Sheet Tabs
                  iii.  Operands         iv.  Cell
              Ans.  i.   Formulae  Bar:  One  of  the  most  important  features  of  spreadsheet  package  is  doing  calculations.  For  calculation
                     formulae are used. The formula applied in a particular cell can be viewed in the formula bar when the specific cell is
                     selected.
                  ii.   Sheet Tabs: It lies below the active sheet of the screen. The names of the worksheets appear in the sheet tabs at the
                     bottom of the workbook. Click on the specific sheet tab to open it.
                  iii.   Operands: Numeric Data are the operands on which formula is applied to perform arithmetical calculation. Operands
                     refer to data on which formula is applied.
                  iv.  Cell: A rectangular box formed by the intersection of a row and a column is called a cell. Cell is the basic unit of a
                     worksheet where data (numbers, text, formulas, etc.) are entered.
                                                                                           21 st   #Productivity & Accountability
            C.  Competency-based/Application-based questions:                           Century   #Technology Literacy
                                                                                          Skills
               1.  Kartik’s father has recently been selected as the President of the society and told him to make a list of the neighbours with
                  the details like Name, Number of members, Phone number, Address, Date of shifting to their locality and other details so
                  that he can share with all the residential people.
                  a.  Help him by suggesting the most suitable application software.
                  b.  Which feature of the software will help him generate the Serial Number?
                  c.  Give the steps to change the font size and style.
                  d.  Give the steps to save the file with a name.
                  e.  Display the date in the format: DD-MON-YYYY.
             Ans.  a.  Open the Calc.
                  b.   AutoFill feature helps you fill the predictable series automatically in a range of cells using the fill handle (plus sign (+)).
                     This fill handle appears when the mouse pointer moves over the bottom right corner of an active cell. Drag this handle
                     down to the point till the series needs to be generated.
                  c.  Select Font and Style icons present on the Formatting toolbar.
                  d.  Click on the File → Save As.
                  e.   Right-click on the cell to open the shortcut menu → Select Format cells… → Category-Date → select the format of the
                     date → click on OK.
               2.  Kabir has maintained his marks of five subjects in all 3 unit tests in three worksheets. Help him do the given tasks:
                  a.  Steps to rename the three sheets as Unit1, Unit2, Unit3.
                  b.  Steps to create a line chart.

                                                                                          Electronic Spreadsheet  309
   304   305   306   307   308   309   310   311   312   313   314