A spreadsheet has a full list of students. Only students with low attendance need to be shown. Which feature is most suitable?
Advertisement
Answer and explanation
Correct answer: Filtering
Filtering displays only rows that meet a condition, such as attendance below a chosen percentage, while the other rows remain stored and can usually be shown again. Sorting only changes the order of all or selected rows. Printing and spell check do not select records based on attendance.
Frequently asked questions
What is the correct answer to this question?
Filtering
Why is this the correct answer?
Filtering displays only rows that meet a condition, such as attendance below a chosen percentage, while the other rows remain stored and can usually be shown again. Sorting only changes the order of all or selected rows. Printing and spell check do not select records based on attendance.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
Advertisement