Page 219 - CA 165 ver 1.0 Class 9
P. 219

2.  What is Cell Referencing? Discuss its different types giving suitable examples.
                     Ans.  The identification or address of a cell in a formula is known as ‘Cell Reference’. There are three types of
                         referencing in ‘Calc’: Relative Referencing, Absolute Referencing and Mixed Referencing.

                         ●   Relative referencing is based on the position of the cell in which the formula is typed with respect to
                             the cell address of the formula. When we copy or move the formula to other cells, the reference (cell
                             address) automatically changes according to the relative position of cells in consideration. Example:
                             ‘=C5+D5+E5’.
                         ●   Absolute referencing is applied when a user does not want to change the value while copying the
                             formula with cell address to another cell. To apply an absolute cell reference, a ‘$’ (dollar) sign is
                             prefixed before the row number and/or the column name in the cell address. (i.e. $ sign fixes the
                             value). Example: ‘=$C$3+$D$3+$E$3’.
                         ●   Mixed  referencing  is  the  combination  of  absolute  and  relative  referencing.  While  applying  mixed
                             referencing, either the row number or the column name of the cell address in the formula is fixed. The
                             cell references such as $F5 or F$5 are examples of mixed referencing. Example: ‘=F10/$F$3*100’.
                     3.   What is a function in ‘Calc’? List all the statistical functions.
                     Ans.  Functions are in-built formula in ‘Calc’, which can be used to perform arithmetical and non-arithmetical
                         tasks. A function contains ‘Name’ and ‘Argument’. In ‘Calc’ there are more than 375 in-built functions which
                         can be applied directly or as part of a formula. For Example: A formula, say A1+A2+A3+A4+A5 can be
                         written using the ‘SUM’ function along with cell range as: SUM(A1:A5).
                         ●    AVERAGE( ): Produces the average (mean) of the given arguments. Eg.=AVERAGE(10;20;30) Displays
                             output: 20
                         ●    MAX( ): Produces the largest value from the given range of cells. Eg. =MAX(10;20;15;25) Displays
                             output:25
                         ●    MIN( ): Produces the smallest value from the given set of values/range of cells. Eg. = MIN(10;20;15;25)
                             Displays output:10
                         ●    COUNT: Produces the number of arguments enclosed in small brackets. It can only count the numeric
                             entries and ignores the text entries. Eg. = COUNT(1;2;15;25;3;6) Displays  output :6
                     4.   Explain the following terms associated with charts:
                         i.  Data Labels                                     ii.  Walls and Floors
                         iii.  Plot Area                                     iv.  Data Series
                     Ans.  i.  Data Labels: It is the set of values which the user wants to plot in the chart.
                         ii.   Walls and Floors: In a 3-D chart, the base area or the plane in X-Y axis is called the floor and the
                             vertical areas, i.e. planes in X-Z and Y-Z axis are called walls.
                         iii.   Plot Area:  It is that area of the chart in which the data is plotted. In a 2-D chart; axis bound the plot
                             area whereas in 3-D charts, walls and floors bound the plot area.
                         iv.  Data Series: It is the set of values which the user wants to plot in the chart.

                 C.  Application based questions.
                     1.   What formula should be contained in the cell C2 to calculate Temp in Fahrenheit?







                           If Temperature in Fahrenheit = 9 ÷ 5 × (Temperature in Celsius + 32). Also, name the referencing techniques
                         that can be used to copy the formula to the other cells to obtain the result for C3,C4.
                     2.   Tripti wants to refer the range of cells from D2 to E5. What is the correct way of doing it?



                                                                                                Data Analysis    217
   214   215   216   217   218   219   220   221   222   223   224