Activate the AutoFilter feature from the Data tab to begin filtering your data;
Apply multiple filters to fine-tune your dataset based on varied criteria;
Use the Clear Filter option to reset your data view to its original state;
Employ advanced filtering options to specify more complex filter conditions.

Завдання

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Завдання

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Mark tasks as Completed

Все було зрозуміло?

Секція 5. Розділ 2

Choose your plan

Filtering Data Using AutoFilter

Imagine having a magic magnifying glass that only shows you the data you need. That's what using AutoFilter in Excel is like.

We'll go through how to use this tool to highlight the essential information, helping you to ignore the noise and focus on what's important.

Activate the AutoFilter feature from the Data tab to begin filtering your data;
Apply multiple filters to fine-tune your dataset based on varied criteria;
Use the Clear Filter option to reset your data view to its original state;
Employ advanced filtering options to specify more complex filter conditions.

Завдання

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Завдання

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Mark tasks as Completed

Все було зрозуміло?

Секція 5. Розділ 2

Imagine having a magic magnifying glass that only shows you the data you need. That's what using AutoFilter in Excel is like.

We'll go through how to use this tool to highlight the essential information, helping you to ignore the noise and focus on what's important.

Activate the AutoFilter feature from the Data tab to begin filtering your data;
Apply multiple filters to fine-tune your dataset based on varied criteria;
Use the Clear Filter option to reset your data view to its original state;
Employ advanced filtering options to specify more complex filter conditions.

Завдання

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Завдання

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Все було зрозуміло?

Imagine having a magic magnifying glass that only shows you the data you need. That's what using AutoFilter in Excel is like.

We'll go through how to use this tool to highlight the essential information, helping you to ignore the noise and focus on what's important.

Activate the AutoFilter feature from the Data tab to begin filtering your data;
Apply multiple filters to fine-tune your dataset based on varied criteria;
Use the Clear Filter option to reset your data view to its original state;
Employ advanced filtering options to specify more complex filter conditions.

Завдання

Select the range. Click the Filter button. Click the arrow on the Category header, choose Toys. Click OK.
Click Category autofilter, choose Books. Click Supplier autofilter, choose Orion Distributors.
Click Re-order Level autofilter, choose the red flag Click a dropdown arrow on a column header. Select Clear Filter From [Column Name].

Секція 5. Розділ 2

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів