Question

Evaluate
Fill in the blanks with the help of given words.
Sorting
Reapply
Filtering
descending
Clear Rules
1. The rearrangement of data in ascending (A to Z) or descending (Z to A) order is called
2. In case you edit data and wish to apply the same filter, click ..
... in the Sort
& Filter group.
3. To clear conditional formatting, click the Conditional Formatting drop-down menu and select
........ from the sub-menu.​

Answer 1

Answer:

1) Sorting

2)Data tab

3)The Home tab, click the Conditional Formatting command. A drop-down menu will appear.

Select Clear Rules.

A menu will appear. You can choose to clear rules from the Selected Cells, Entire Sheet, This Table, or This PivotTable.