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

