Excel L4 Sort/Filter

To arrange data by the age column from (high to low) we will

• Filter it

• Sort it

• Apply Conditional Formatting

• Rearrange data manually

To display only those records where the surname is SMITH you will

• Manually extract the data

• Sort the data

• Filter the data

• Use Goto option

What can you use to help you see only certain types of records and hide everything else?

• Filters

• Functions

• Sorts

• Charts

What can you use to reorganise your data into a different order.

• Filters

• Functions

• Sorting

• Charts

The Sort & Filter group is present under which tab of Microsoft Excel?

• Insert Tab

• Data Tab

• Page Layout

• View

The arrangement of data in 0 to 9 will arrange the data in the order

• Smallest to Largest

• Largest to Smallest

The arrangement of data in Z to A will arrange the data in __________ order.

• Ascending

• Descending

What is this icon?

• Borders

• Sort& Filter

• Bold

• Conditional Formatting

Which tab in Excel allows you to add a graph?

• Insert

• File

• Data

• Formulas

What records will this city filter find?

• Only London and New York

• Only Moscow

• Only London and Sydney

• All records in London, Moscow, New York, Paris & Sydney