If the total in a spreadsheet should change automatically with changing data, what should be used?
Answer and explanation
Correct answer: Formula
A formula performs a calculation using cell values and can recalculate when those values change. For example, a total can be produced with a SUM formula over a selected range, so the result updates after an entry is edited. A paper copy, image, or sound device cannot perform this dynamic spreadsheet calculation. Hence, A is correct.
Frequently asked questions
What is the correct answer to this question?
Formula
Why is this the correct answer?
A formula performs a calculation using cell values and can recalculate when those values change. For example, a total can be produced with a SUM formula over a selected range, so the result updates after an entry is edited. A paper copy, image, or sound device cannot perform this dynamic spreadsheet calculation. Hence, A is correct.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
