A list must show only students with low attendance and hide the rest. Which feature is most correct?
Answer and explanation
Correct answer: Filtering
Filtering displays only the rows that meet a selected condition, such as attendance below a chosen percentage, while temporarily hiding the remaining rows. Therefore, option B is correct. Sorting changes the order of rows but normally keeps all rows visible. Printing and spell check do not select records according to attendance values.
Frequently asked questions
What is the correct answer to this question?
Filtering
Why is this the correct answer?
Filtering displays only the rows that meet a selected condition, such as attendance below a chosen percentage, while temporarily hiding the remaining rows. Therefore, option B is correct. Sorting changes the order of rows but normally keeps all rows visible. Printing and spell check do not select records according to attendance values.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc. Topic: Analyse data using scenarios and goal seek.
