A student selected the wrong cell range to calculate total marks in a spreadsheet. What is the most likely result?
Answer and explanation
Correct answer: An incorrect total may be obtained
A formula calculates the cells included in its selected range. If the range omits marks, includes unrelated values, or covers the wrong rows, the displayed total can be wrong even though the formula works as written. A spreadsheet does not understand the intended range automatically, and the other options are unrelated.
Frequently asked questions
What is the correct answer to this question?
An incorrect total may be obtained
Why is this the correct answer?
A formula calculates the cells included in its selected range. If the range omits marks, includes unrelated values, or covers the wrong rows, the displayed total can be wrong even though the formula works as written. A spreadsheet does not understand the intended range automatically, and the other options are unrelated.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
