Which feature will help show only passed students in a large spreadsheet table?
Answer and explanation
Correct answer: Filter
A filter displays only the rows that meet a chosen condition, such as marks greater than or equal to the passing level. Other rows are hidden from the current view rather than necessarily deleted, so the full data can be shown again by clearing the filter. Close exits the file, a lock concerns protection, and a page number labels pages; none selects matching records.
Frequently asked questions
What is the correct answer to this question?
Filter
Why is this the correct answer?
A filter displays only the rows that meet a chosen condition, such as marks greater than or equal to the passing level. Other rows are hidden from the current view rather than necessarily deleted, so the full data can be shown again by clearing the filter. Close exits the file, a lock concerns protection, and a page number labels pages; none selects matching records.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
