In a spreadsheet, total marks are wrong because the heading cell is also included in the formula. What is the correct correction?
Answer and explanation
Correct answer: Select only the correct mark cells in the formula
A spreadsheet formula operates on the cells included in its range. If a heading cell containing text or an unintended value is included, the formula may give an incorrect or misleading total. Edit the formula so that its range contains only the cells holding marks, then check the result against a simple manual calculation. Changing the printer or deleting data does not fix the formula.
Frequently asked questions
What is the correct answer to this question?
Select only the correct mark cells in the formula
Why is this the correct answer?
A spreadsheet formula operates on the cells included in its range. If a heading cell containing text or an unintended value is included, the formula may give an incorrect or misleading total. Edit the formula so that its range contains only the cells holding marks, then check the result against a simple manual calculation. Changing the printer or deleting data does not fix the formula.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
