Question

Briefly explain the utility of filter feature in calc?

Answer 1

Use Data > Filter > AutoFilter to insert the auto filter combo box in the appropriate cell. Finally, use the drop-down arrow to choose an appropriate auto filter. Remove an auto filter by repeating the steps to create the auto filter—in other words, the menu option acts as a toggle to turn the auto filter on and off.

Hope it helps mate

Answer 2

A filter is a device in signal processing used to allow wanted frequency components from the signals and to remove unwanted ones. The background noise of the interfacing signal can be reduced by eliminating some frequencies, which is known as filtering. Filter circuits can be designed to combine the properties of the LPF (low pass filter) and HPF (high pass filter) into a single filter, which is known as a bandpass filter.