Sorting & Filtering Data

Sorting & Filtering Data

Presented by Kathir. M

Multiple Choice

Which feature allows us to arrange the given data according to particular field either in ascending or descending order ?

• Data form

• Sort

• Filter

Multiple Choice

The _____________ feature allows you to see only those records that you want display while it hides the rest of the data temporarily from the view .

• Filter

• sort

Multiple Choice

State true or false.

You can sort data in only one field.

• True

• False

• Don`t know

• Not able to answer

Practical

Using the given data make a column chart and do sorting and filtering method. Name it as lab section - 2

Practical

Create a list of students and the categories they participated in the Interschool competition and sort them in Excel. Create a column chart to show the summary