While calculating average in a spreadsheet, the heading cell and total cell are also selected. What should be checked?
Answer and explanation
Correct answer: Formula cell range
An average formula should normally include only the individual numeric values being averaged. A heading is text and a total cell may count the same data again or distort the calculation. Therefore, inspect the formula’s selected range and remove non-data or summary cells before confirming the result; A is correct.
Frequently asked questions
What is the correct answer to this question?
Formula cell range
Why is this the correct answer?
An average formula should normally include only the individual numeric values being averaged. A heading is text and a total cell may count the same data again or distort the calculation. Therefore, inspect the formula’s selected range and remove non-data or summary cells before confirming the result; A 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.
