If total marks should change automatically when monthly marks change, which feature is useful?
Answer and explanation
Correct answer: Apply formula
A spreadsheet formula performs a calculation using cell values. For example, a total can be calculated with a SUM formula referring to the cells containing monthly marks. If one of those marks changes, the spreadsheet recalculates the formula and updates the total. Inserting a picture, muting sound, or refreshing a web page does not perform this automatic calculation, so option B is correct.
Frequently asked questions
What is the correct answer to this question?
Apply formula
Why is this the correct answer?
A spreadsheet formula performs a calculation using cell values. For example, a total can be calculated with a SUM formula referring to the cells containing monthly marks. If one of those marks changes, the spreadsheet recalculates the formula and updates the total. Inserting a picture, muting sound, or refreshing a web page does not perform this automatic calculation, so option B 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.
