While calculating average marks in a spreadsheet, the heading, blank cell, and total cell were also selected. What is the most correct check?
Answer and explanation
Correct answer: Check the correct cell range of the formula
An average formula should use the range containing the individual numeric marks, not a heading, an unrelated blank, or a cell containing a total. Including the total can count aggregated data again and distort the result. The student should inspect the formula or select the correct range before recalculating. Printer, screen size, and hidden rows do not fix the calculation.
Frequently asked questions
What is the correct answer to this question?
Check the correct cell range of the formula
Why is this the correct answer?
An average formula should use the range containing the individual numeric marks, not a heading, an unrelated blank, or a cell containing a total. Including the total can count aggregated data again and distort the result. The student should inspect the formula or select the correct range before recalculating. Printer, screen size, and hidden rows do not fix 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.
