Page 253 - IT_Play_V1.0 Class9
P. 253

2.  What is the purpose of using mixed referencing in LibreOffice Calc?
                       i.  To fix both row and column.
                       ii.  To lock only the row or only the column while copying the formula.
                       iii. To make the formula flexible.
                       iv. To prevent copying formulas altogether.

                 B.  Fill in the blanks.
                    1.   Absolute referencing ensures that the cell reference remains ................................. when the formula is copied to
                       different locations.
                    2.  In mixed referencing, for cell address B10, if only the row is fixed, the cell reference would be ..................................

                                                                                                        21 st
                 C.  Assertion and reasoning question.                                               Century   #Critical Thinking
                                                                                                       Skills
                      The following question consists of two statements – Assertion (A) and Reason (R). Answer the question by
                    selecting the appropriate option given below:
                    i.   Both A and R are true and R is the correct explanation of A.
                    ii.  Both A and R are true but R is not the correct explanation of A.
                    iii.  A is true but R is false.
                    iv.  A is false but R is true.
                    Assertion (A): To use absolute referencing in a formula, you must place a dollar sign ($) before both the column and
                    row numbers (e.g., $A$1).
                      Reason (R): Absolute referencing allows the reference to remain fixed when the formula is copied to another cell.

                                                   Section B (Subjective Type Questions)
                 A.  Answer the following questions:
                    1.  What is cell referencing?

                    2.  What is relative reference in LibreOffice Calc?
                                                                                                    21 st
                 B.  Application-based question.                                                  Century   #Technology Literacy
                                                                                                    Skills
                         Aarav is working on a spreadsheet to calculate the percentage for students in various subjects. The maximum
                       marks for each subject remain constant, but the student marks vary across rows. Aarav uses Auto Fill to copy the
                       formula for calculating total marks across rows, but he wants to ensure that the reference to the fixed maximum
                       marks (in cell G2) remains constant for all rows, while the student marks change based on the row number.
                              A              B           C          D           E             F
                          1.  Student Name   Maths       Science    English     Total Marks   Percentage
                          2.  Aarav          80          85         90          255           =(E2/G2)*100
                          3.  Priya          75          80         88          243
                          4.  Rahul          78          83         92          253

                         i.   Which type of referencing can Aarav use to keep the maximum marks column (G2) fixed while allowing the
                           total marks row to change across rows?
                         ii. Write the new formula for calculating the percentage in the Percentage column for Aarav.
















                                                                                Understand and Apply Referencing    251
   248   249   250   251   252   253   254   255   256   257   258