Google Sheets - Filters & Filter Views

The video tutorial explains how to use filters and filter views in Google Sheets to manage data visibility. It covers creating basic filters, their limitations, and introduces filter views for personalized data filtering. The tutorial provides step-by-step instructions on creating, managing, and using filter views, ensuring data is filtered for individual users without affecting others' views.

What is a limitation of using a regular filter in Google Sheets?

• It only works for the creator of the filter.

• It filters data for all users of the sheet.

• It cannot be removed once applied.

• It only works for numerical data.

How can you create a filter view in Google Sheets?

• By clicking on the filter icon and selecting 'Create Filter View'.

• By going to Data and selecting 'Create a Filter'.

• By clicking on the pirate flag icon and selecting 'Create New Filter View'.

• By right-clicking on the sheet and selecting 'New Filter View'.

What is the main advantage of using filter views over regular filters?

• Filter views change the data for all users.

• Filter views can be shared with other users.

• Filter views automatically update data in real-time.

• Filter views allow you to save filters for future use.

How can you close a filter view in Google Sheets?

• By clicking on the X on the far right.

• By going to Data and selecting 'Remove Filter'.

• By selecting 'Close Filter' from the toolbar.

• By clicking on the filter icon and selecting 'Close'.

Where can you make additional changes to a filter view?

• In the toolbar under 'Edit Filter'.

• In the sheet's context menu.

• In the settings cog on the far right.

• In the Data menu under 'Filter Options'.