In a spreadsheet, total marks are wrong because a heading cell is included in the formula. What is the correct correction?
Answer and explanation
Correct answer: Select only the correct marks cells in the formula
A spreadsheet formula calculates from the cells included in its range. A heading cell contains a label rather than a student's numeric mark, so including it makes the range incorrect or can produce an unwanted result. Edit the formula to include only the cells containing the intended marks, then check the result against a manual total.
Frequently asked questions
What is the correct answer to this question?
Select only the correct marks cells in the formula
Why is this the correct answer?
A spreadsheet formula calculates from the cells included in its range. A heading cell contains a label rather than a student's numeric mark, so including it makes the range incorrect or can produce an unwanted result. Edit the formula to include only the cells containing the intended marks, then check the result against a manual total.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
