How can select the advanced filter?
Data>filter
Data>advanced filter
Data>filter>advanced filter
Filter>custom filter>advanced filter
How can be display the conditional formatting dialog box?
Format>data>conditional formatting
Format>conditional formatting
Data>format>conditional formatting
Data>sort>conditional formatting
Conditional formatting in MS Excel we can change __________.
Font style
Font color
Both a & b
both at a time.
How is it possible to display all the data again after filtering?
Select return from drop down menu
Select custom from drop down menu
Select all from dropdown menu
None of these
What is the meaning of tick mark when we select data>filter>autofilter?
Excel is busy
Auto filter cannot take at present
Another excel sheet is also open
Auto filter feature is already on
