Which column is based on sorting?
That column is present first in excel
That column is present last in excel
That column name is currently selected in drop down menu sort by
None of these
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
How can be display the conditional formatting dialog box?
Format>data>conditional formatting
Format>conditional formatting
Data>format>conditional formatting
Data>sort>conditional formatting
How can select the advanced filter?
Data>filter
Data>advanced filter
Data>filter>advanced filter
Filter>custom filter>advanced filter
