Question

Q.1.
Fill in the blanks :
(1x5-5)
i.
button is used to clear all filters from the worksheet
11
button is used to search a record with specific value,
iii.
provides an easy way to present the data in a summarized form.
IV.
button is used to remove all the subtotal in a worksheet.
The purpose of grouping the worksheets is to enter common
formatting effects
and formulas. please answer thesea q​

Answer 1

Answer:

i) If you want to completely remove filters, go to the Data tab and click the Filter button, or use the keyboard shortcut Alt+D+F+F.

ii) On the Home tab, in the Find group, click Find, or press CTRL+F. ... 3.In the Find What box, type the value for which you want to search.

iii) Summary provides an easy way to present the data in a summarised way.

iv) If you no longer need the subtotals, follow these steps to remove them. Select a cell in the list, and on the Excel Ribbon, click the Data tab, then click Subtotals. Click the Remove All button, to remove the Subtotals.

Explanation:

Plz Mark me as brainliest and follow me for more answers like this