If a large attendance table must show only students below seventy-five percent attendance, which feature is correct?
Answer and explanation
Correct answer: Filtering
Filtering applies a condition and displays only the rows that meet it, such as attendance below 75 percent. The other rows remain in the data but are temporarily hidden from the result view, so the original table is not necessarily deleted. Sorting would arrange all rows in an order but would not by itself hide students who do not meet the condition.
Frequently asked questions
What is the correct answer to this question?
Filtering
Why is this the correct answer?
Filtering applies a condition and displays only the rows that meet it, such as attendance below 75 percent. The other rows remain in the data but are temporarily hidden from the result view, so the original table is not necessarily deleted. Sorting would arrange all rows in an order but would not by itself hide students who do not meet the condition.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
