In a large attendance table, only students whose attendance is below a fixed limit must be shown. Which feature is most suitable?
Answer and explanation
Correct answer: Filtering
Filtering applies a condition and displays only the rows that meet it, such as attendance below a chosen percentage. Other rows are hidden from the current view rather than permanently deleted. Sorting changes the order of rows but normally keeps all rows visible, while spell check and printing do not select records by a numerical 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 a chosen percentage. Other rows are hidden from the current view rather than permanently deleted. Sorting changes the order of rows but normally keeps all rows visible, while spell check and printing do not select records by a numerical condition.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
