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

