How can select the advanced filter?
Data>filter
Data>advanced filter
Data>filter>advanced filter
Filter>custom filter>advanced filter
Conditional formatting in MS Excel we can change __________.
Font style
Font color
Both a & b
both at a time.
How can be display the conditional formatting dialog box?
Format>data>conditional formatting
Format>conditional formatting
Data>format>conditional formatting
Data>sort>conditional formatting
What is the best option you would prefer in excel only to display students whose date of birth is after 01/01/2012 if you are having names and birth days of 20 students?
Sorting
Filtering
Conditional formatting
None of these
