Question

which of the tabs should be clicked to do the following in MS Excel?
1. Sorting a column
2. Getting the advanced filter option
3. Performing conditional formatting
4. Printing a worksheet
5. Changing the chart type​

Answer 1

Explanation:

1the Sort dialog box, under Column, in the Sort by box, select the column that you want to sort.

2Go Data tab –> Sort & Filter –> Advanced.

3From the Home tab, click the Conditional Formatting command. A drop-down menu will appear. Hover the mouse over the desired conditional formatting type, then select the desired rule from the menu that appears