Understand and apply Referencing-Class-9-PART-B UNIT-IV-CH-4:

PART-B Unit-4 Electronic Spreadsheet-LibreOffice(2025-26)

Chapter-4 Understand and apply referencing

Question A – Fill in the Blanks

1.Referencing allows you to use data from _____ cells in formulas.

Answer: other

2.Relative referencing changes _____ when copied to another cell.

Answer: its reference

3.Absolute referencing uses the symbols _____ to fix rows or columns.

Answer: $

4.The formula =$A1 + B1 is an example of _____ reference.

Answer: mixed

5.To reference a cell without changing its position use _____ referencing.

Answer: absolute

Question C – Choose the Correct Option

1.What type of referencing adjusts automatically when copied to another cell?

A. Absolute

B. Relative

C. Mixed

D. Fixed

Answer: B. Relative

2.Which symbol is used for absolute referencing?

A. Has (#)

B. Percentage (%)

C. @

D. Dollar sign ($)

Answer: D. Dollar sign ($)

3.What does mixed referencing lock?

A. Both row and column

B. Neither row nor column

C. Either row or column

D. Only row

Answer: C. Either row or column

4.Which type of reference is used by default in Calc?

A. Absolute

B. Fixed

C. Relative

D. Mixed

Answer: C. Relative

5.What is an example of absolute referencing?

A. A1

B. $A$1

C. $A1

D. A$1

Answer: B. $A$1

Question D – Short Answer Questions

1.What is relative referencing in Calc?

Answer: Relative referencing changes its row/column reference automatically when copied to another cell.

2.How is absolute referencing indicated in a formula?

Answer: Absolute referencing uses the $ symbol before row number and column letter like $A$1.

3.Define mixed referencing with example.

Answer: Mixed referencing fixes either the row or the column using $. Example: $A1 or A$1.

4.What does $A1 mean in Calc?

Answer: $A1 means column A is fixed but row 1 can change.

5.How does relative referencing behave when copied?

Answer: It updates the reference according to the new position of the formula.

Question E – Long Answer Questions

1.Explain the concept of referencing in LibreOffice Calc.

Answer:

Referencing is a method of using data from other cells in a formula instead of typing values directly. It helps in automatic calculation and updating of results when the referenced cell value changes. It makes the worksheet dynamic and more efficient.

2.Describe the difference between relative, absolute and mixed referencing.

Answer:

Relative Referencing: Changes automatically when copied. Example: A1

Absolute Referencing: Does not change when copied; both row and column are fixed using $ symbol. Example: $A$1

Mixed Referencing: Either row or column is fixed using $. Example: $A1 or A$1

These referencing types help in performing calculations flexibly in Calc.

SOME OTHER LINKS YOU MAY LIKE:

CBSE INFORMATION TECHNOLOGY-UNIT-I-CLASS-9(CHAPTER-1)

CBSE INFORMATION TECHNOLOGY-UNIT-I-CLASS-9(CHAPTER-2)