In a spreadsheet, the total marks are wrong because heading and blank cells are also included in the formula. What is the most correct check?
Answer and explanation
Correct answer: सूत्र की कोशिका सीमा जांचना
A spreadsheet formula calculates from the cell references or range written in it. If the range includes a heading, an unintended value, or cells outside the marks list, the result may be wrong. Checking and correcting the range ensures that only the intended numeric cells are included; printer or screen settings cannot fix the calculation.
Frequently asked questions
What is the correct answer to this question?
सूत्र की कोशिका सीमा जांचना
Why is this the correct answer?
A spreadsheet formula calculates from the cell references or range written in it. If the range includes a heading, an unintended value, or cells outside the marks list, the result may be wrong. Checking and correcting the range ensures that only the intended numeric cells are included; printer or screen settings cannot 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.
