If the average marks in a spreadsheet are coming wrong, what should be checked first?
Answer and explanation
Correct answer: Cells selected in the formula
An average is calculated from the cells included in the formula. If the range contains the wrong students, headings, blank-related entries, or excludes valid marks, the result can be incorrect even when the formula syntax is valid. Check the cell range and values first, then review the formula. Mouse colour, chair height, and sound level cannot change the calculation.
Frequently asked questions
What is the correct answer to this question?
Cells selected in the formula
Why is this the correct answer?
An average is calculated from the cells included in the formula. If the range contains the wrong students, headings, blank-related entries, or excludes valid marks, the result can be incorrect even when the formula syntax is valid. Check the cell range and values first, then review the formula. Mouse colour, chair height, and sound level cannot change 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.
