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

b.  C9=sum(C3:C8)
                 D9=sum(D3:D8)
                 E9=sum(E3:E8)
               c.  D10=(D9/C9)*100
                  E10=(E9/C9)*100
           3.  Differentiate between Absolute and Relative referencing.
          Ans.  Absolute Referencing: The fixing of a cell in a formula/function so that its location does not change with respect to the
              location where it is copied then this type of referencing is known as absolute referencing. Dollar sign ($) is used in front of
              a column name and row number to make it an absolute cell referencing like $A$10, $F$12, etc.
               Relative Referencing: Whenever a formula or function is copied to some other cell, the address in the formula/function
              changes relative to the location where it is copied. This is known as relative referencing.
           4.  Define the following:
               a.  Cell Range
               b.  Functions
               c.  Cell address
               d.  Worksheet
          Ans.  a.   A group of continuous cells selected with a mouse or keyboard is known as a cell range. Any data such as text, numbers,
                 and formulae can be entered in a cell range.
               b.   Functions are already created formulae in a spreadsheet that have a name followed by circular brackets. For example,
                 max(), min(), sum(), etc. We write arguments inside the brackets in the form of values, cell address or cell range.
               c.   Each cell in a spreadsheet is referred to by an address, which is formed by a combination of a column alphabet first and
                 row number later, and is called a cell address. For example, D5 refers to a cell formed by the intersection of D column
                 and 5th row.
               d.   A file in OpenOffice Calc is known as a worksheet. It consists of the cells in which data is entered and calculated. It is
                 also known as a spreadsheet.
           5.  Write the functions or formulae to answer the following queries:



















               a.  Cell D4 to display the total of Theory and Practical marks of Term 1.
               b.  Cell G4 to display the total of Theory and Practical marks of Term 2.
               c.  Cell H4 to display 40% of the total of Term 1.
               d.  Cell I4 to display 60% of the total of Term 2.
               e.  Cell J4 to display the sum of Term1 Weightage and Term 2 Weightage.
               f.  Cell D12 to display the Highest scorer of Term 1.
               g.  Cell G12 to display the Highest scorer of Term 2.
               h.  Cell J12 to display the Overall Highest scorer.
          Ans.  a.  D4=B4+C4, copy the formula for the rest of the students
               b.  G4=E4+F4, copy the formula for the rest of the students
               c.  H4=D4*$H3, copy the formula for the rest of the students
               d.  I4=G4*$I3, copy the formula for the rest of the students



          308   Trackpad Information Technology-IX
   303   304   305   306   307   308   309   310   311   312   313