In a spreadsheet, total marks are wrong and some extra cells are included in the formula. What is the most correct reason?
Answer and explanation
Correct answer: The formula cell range is wrong
Spreadsheet formulas calculate from the cell references or range written in them. If the range extends beyond the intended marks, unrelated or extra values may be included, producing an incorrect total. The printer, monitor size, and mouse speed do not change the mathematical references in a formula. Therefore the cell range must be checked.
Frequently asked questions
What is the correct answer to this question?
The formula cell range is wrong
Why is this the correct answer?
Spreadsheet formulas calculate from the cell references or range written in them. If the range extends beyond the intended marks, unrelated or extra values may be included, producing an incorrect total. The printer, monitor size, and mouse speed do not change the mathematical references in a formula. Therefore the cell range must be checked.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
