Question

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

1. HOW WILL YOU TURN OFF THIS FEATURE IN THE WORKSHEET ??


NO SPAM PLEASE

Answer 1

Answer:

step 1) Choose Options from the Tools menu.

step 2) Excel displays the Options dialog box.

Make sure the View tab is selected. (See Figure 1.)

step 3) Clear the Sheet Tabs check box to turn off the worksheet tabs.

step 4 )Click on OK.

Answer 2

$\huge{\fcolorbox{white}{pink}{Answer:}}$

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.