What is the advantage of cell reference in a spreadsheet?
Answer and explanation
Correct answer: Using the cell address instead of the value in a formula
A cell reference identifies a cell by its address, such as B3, instead of typing its current value directly. A formula using B3 can update automatically when the value in B3 changes. This makes a spreadsheet flexible and reduces repeated data entry. The other choices are unrelated to cell references.
Frequently asked questions
What is the correct answer to this question?
Using the cell address instead of the value in a formula
Why is this the correct answer?
A cell reference identifies a cell by its address, such as B3, instead of typing its current value directly. A formula using B3 can update automatically when the value in B3 changes. This makes a spreadsheet flexible and reduces repeated data entry. The other choices are unrelated to cell references.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
