Why is a filter used in a spreadsheet?
Answer and explanation
Correct answer: To show records that match selected conditions
A filter displays only the rows that satisfy selected conditions, such as showing students who scored above 80. The other rows are usually hidden temporarily, not permanently deleted, and can be shown again by clearing the filter. Therefore, filtering is useful for examining a particular part of a large data set.
Frequently asked questions
What is the correct answer to this question?
To show records that match selected conditions
Why is this the correct answer?
A filter displays only the rows that satisfy selected conditions, such as showing students who scored above 80. The other rows are usually hidden temporarily, not permanently deleted, and can be shown again by clearing the filter. Therefore, filtering is useful for examining a particular part of a large data set.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
