Question

CONSIDER THE WORKSHEET SHOWING THE TOTAL MARKS OBTAINED BY SOME STUDENTS OF CLASS VI A AND ANSWER THE FOLLOWING QUESTION:-

1. WHICH FEATURE OF EXCEL IS SHOWN BY THE DROP DOWN MENU ARROWS IN THE COLUMN HEADINGS ?


NO SPAM OR ELSE DELETED, ITS URGENT PLEASE ANSWER

Answer 1

Answer:

Choosing AutoFilter from the Sort and Filter group on the Home tab applies drop-down arrows directly to column labels in your list, as illustrated in Figure 1-13. You then select a specific value from one of the drop-down lists to display all records in your list containing that value.

Answer 2

$\huge\star\underbrace{\mathtt\red{✺A} \mathtt\green{N}\mathtt\blue{S} \mathtt\purple{W}\mathtt\orange{E} \mathtt\pink{R✺}}\star$

Choosing AutoFilter from the Sort and Filter group on the Home tab applies drop-down arrows directly to column labels in your list, You then select a specific value from one of the drop-down lists to display all records in your list containing that value.