If blank cells are accidentally selected while calculating an average in a spreadsheet, what problem may occur?
Answer and explanation
Correct answer: The calculation may be affected
An average is calculated from the values included in the selected range. Blank cells may be ignored by many spreadsheet functions, but selecting the wrong range can also include missing, unintended, or related cells and produce a misleading result. Therefore, option A is the safest correct answer. The other choices have no connection with selecting cells for an average.
Frequently asked questions
What is the correct answer to this question?
The calculation may be affected
Why is this the correct answer?
An average is calculated from the values included in the selected range. Blank cells may be ignored by many spreadsheet functions, but selecting the wrong range can also include missing, unintended, or related cells and produce a misleading result. Therefore, option A is the safest correct answer. The other choices have no connection with selecting cells for an average.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc. Topic: Analyse data using scenarios and goal seek.
