Which feature can help show only required data in a spreadsheet?
Answer and explanation
Correct answer: Filter
The Filter feature temporarily hides rows that do not meet selected conditions and displays only the records needed for analysis, such as students who scored above a value or items from one category. The hidden data is not necessarily deleted; clearing the filter can show it again. Printing creates a paper or print output, while mute and Recycle Bin are unrelated, so option A is correct.
Frequently asked questions
What is the correct answer to this question?
Filter
Why is this the correct answer?
The Filter feature temporarily hides rows that do not meet selected conditions and displays only the records needed for analysis, such as students who scored above a value or items from one category. The hidden data is not necessarily deleted; clearing the filter can show it again. Printing creates a paper or print output, while mute and Recycle Bin are unrelated, so option A 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.
