If the total in a spreadsheet is coming wrong, what should be checked first?
Answer and explanation
Correct answer: Cells selected in the formula
A spreadsheet formula calculates using the cells or range referenced in it. If a row, column, or cell is accidentally omitted or included, the total can be wrong even when the visible numbers look correct. The first check should therefore be the formula and its selected range, followed by cell values and formats. Mouse colour, chair height, and dust do not alter the calculation.
Frequently asked questions
What is the correct answer to this question?
Cells selected in the formula
Why is this the correct answer?
A spreadsheet formula calculates using the cells or range referenced in it. If a row, column, or cell is accidentally omitted or included, the total can be wrong even when the visible numbers look correct. The first check should therefore be the formula and its selected range, followed by cell values and formats. Mouse colour, chair height, and dust do not alter the calculation.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
