In a large attendance table, only students with low attendance must be shown temporarily. Which feature is correct?
Answer and explanation
Correct answer: Filtering
Filtering applies a condition and displays only rows that meet it, such as attendance below a chosen percentage, while keeping the other rows hidden temporarily. Sorting changes the order of rows but normally keeps all rows visible. Printing and spell check do not select records, so filtering, B, is correct.
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 rows that meet it, such as attendance below a chosen percentage, while keeping the other rows hidden temporarily. Sorting changes the order of rows but normally keeps all rows visible. Printing and spell check do not select records, so filtering, B, is correct.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.