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
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
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
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.
