Filter views vs filters in Google Sheets - Practice Questions

Challenge - 5 Problems

🧠 Conceptual

intermediate

Difference in visibility between Filter Views and Filters

In Google Sheets, what is the main difference in how Filter Views and Filters affect what users see?

A Filters change the view for all users at once, while Filter Views let each user see their own filtered data without affecting others.

B Filter Views permanently delete rows that don't match the filter, while Filters only hide them temporarily.

C Filters allow multiple users to create different views simultaneously, but Filter Views only allow one view at a time.

D Filter Views automatically sort data, but Filters only hide rows without sorting.

💡 Hint

Think about whether the filter changes the sheet for everyone or just for you.

Filters apply to the entire sheet and affect what all users see. Filter Views create personal views that only the user sees, so multiple users can have different filters without interfering.

🎯 Scenario

intermediate

Choosing between Filter Views and Filters for team collaboration

Your team is working together on a shared Google Sheet. You want each person to filter data differently without changing what others see. Which should you use?

A Use Filter Views because they delete rows that don't match the filter.

B Use Filters because they let everyone filter independently.

C Use Filter Views because they allow each user to create their own filter without affecting others.

D Use Filters because they save filtered data permanently.

💡 Hint

Consider which option lets multiple users filter differently at the same time.

Filter Views let each user create and save their own filtered view without changing the sheet for others. Filters apply to everyone and can't be personalized simultaneously.

📊 Formula Result

advanced

Effect of applying a Filter on visible rows count

You have 100 rows of data. You apply a Filter to show only rows where the value in column A is greater than 50. If 30 rows meet this condition, how many rows will be visible after applying the Filter?

A 70 rows will be visible, the rest are hidden.

B No rows will be visible because Filters delete rows.

C All 100 rows will be visible but sorted differently.

D 30 rows will be visible, the rest are hidden.

💡 Hint

Filters hide rows that don't meet the condition but do not delete them.

Filters hide rows that don't meet the condition, so only the 30 rows with values greater than 50 remain visible.

❓ data_analysis

advanced

Impact of Filter Views on data sorting

You create a Filter View that sorts data by column B in ascending order. What happens to the data sorting for other users who do not open this Filter View?

A Other users see the data sorted by column B immediately, even without opening the Filter View.

B Other users see the data sorted by column B only if they open the same Filter View.

C Other users see the data sorted by column B permanently for all views.

D Other users see the data unsorted because Filter Views delete sorting.

💡 Hint

Think about whether Filter Views change the sheet for everyone or just for the user who opens them.

Filter Views only change sorting and filtering for the user who opens them. Other users see the default data order unless they open the same Filter View.

❓ Function Choice

expert

Which option causes an error when creating a Filter View?

Which of the following actions will cause an error when trying to create a Filter View in Google Sheets?

A Trying to create a Filter View on a protected range without edit permission.

B Creating a Filter View on a range that includes empty rows.

C Creating multiple Filter Views on the same data range.

D Applying a Filter View that sorts data by a column with text values.

💡 Hint

Consider permissions and restrictions on protected ranges.

You cannot create or modify Filter Views on protected ranges if you do not have edit permission, which causes an error. The other options are allowed.

Practice

1. What is the main difference between a Filter and a Filter View in Google Sheets?

easy

A. Filters only work on numbers, Filter Views only work on text.

B. Filters save your filter settings permanently, Filter Views do not save any settings.

C. Filters change the data view for everyone, while Filter Views create personal saved filters only you see.

D. Filters are only available in Excel, Filter Views are only in Google Sheets.

Solution

1. Step 1: Understand what Filters do

   Filters apply changes to the data view that everyone sharing the sheet can see.

2. Step 2: Understand what Filter Views do

   Filter Views create personal saved filters that only the user applying them can see without affecting others.

3. Final Answer:

   Filters change the data view for everyone, while Filter Views create personal saved filters only you see. -> Option C

4. Quick Check:

   Filters affect all users, Filter Views are personal [OK]

Hint: Filters affect all; Filter Views are personal and saved [OK]

Common Mistakes:

• Thinking Filter Views affect everyone
• Confusing Filters with Filter Views saving settings
• Believing Filters only work on numbers

2. Which of the following is the correct way to create a Filter View in Google Sheets?

easy

A. Click Data > Filter views > Create new filter view

B. Click Data > Create a filter

C. Right-click a cell and select 'Filter Data'

D. Use the formula =FILTER() in a cell

Solution

1. Step 1: Identify menu options for Filter Views

   Filter Views are created via the menu path Data > Filter views > Create new filter view.

2. Step 2: Differentiate from Filters and formulas

   Click Data > Create a filter creates a normal filter affecting all users, Use the formula =FILTER() in a cell is a formula, and Right-click a cell and select 'Filter Data' is not a valid method.

3. Final Answer:

   Click Data > Filter views > Create new filter view -> Option A

4. Quick Check:

   Filter Views menu path = Data > Filter views > Create new filter view [OK]

Hint: Filter Views are under Data > Filter views menu [OK]

Common Mistakes:

• Choosing Data > Create a filter (normal filter)
• Using formulas instead of menu options
• Right-clicking expecting filter options

3. You have a shared Google Sheet with sales data. You apply a Filter to show only sales above $1000. What happens?

medium

A. Only you see the filtered data; others see all data.

B. The sheet data is permanently deleted for sales below $1000.

C. The filter is saved as a Filter View automatically.

D. Everyone viewing the sheet sees only sales above $1000.

Solution

1. Step 1: Understand effect of applying a Filter

   Applying a Filter changes the data view for all users currently viewing the sheet.

2. Step 2: Confirm what others see

   Since it's a Filter (not a Filter View), everyone sees only sales above $1000 while the filter is active.

3. Final Answer:

   Everyone viewing the sheet sees only sales above $1000. -> Option D

4. Quick Check:

   Filter affects all users = Everyone viewing the sheet sees only sales above $1000. [OK]

Hint: Filters affect all users' views immediately [OK]

Common Mistakes:

• Thinking only you see the filtered data
• Confusing Filters with Filter Views
• Believing data is deleted by filtering

4. You created a Filter View but your colleague says they cannot see your filtered data. What is the most likely reason?

medium

A. Filter Views only affect your personal view, not others'.

B. You forgot to share the Filter View link with your colleague.

C. Filter Views require a paid Google Workspace account to share.

D. Filter Views automatically apply to all users, so this is impossible.

Solution

1. Step 1: Recall how Filter Views work

   Filter Views create personal saved filters visible only to the user who created or opened them.

2. Step 2: Understand sharing behavior

   Filter Views do not change the view for others unless they open the same Filter View themselves.

3. Final Answer:

   Filter Views only affect your personal view, not others'. -> Option A

4. Quick Check:

   Filter Views are personal, not shared views [OK]

Hint: Filter Views are personal; others must open them to see [OK]

Common Mistakes:

• Assuming Filter Views auto-share with others
• Thinking Filter Views need paid accounts
• Believing you must share a link for Filter Views

5. You want to analyze a large dataset in a shared Google Sheet without disturbing others' views. Which approach should you use?

hard

A. Apply a Filter to hide unwanted rows temporarily.

B. Create a Filter View to save your personal filter settings.

C. Delete rows you don't want to see.

D. Copy the sheet and apply filters there.

Solution

1. Step 1: Identify the need to avoid disturbing others

   Applying a Filter affects all users, which can disrupt their work.

2. Step 2: Choose a method that keeps your view personal

   Creating a Filter View lets you filter data without changing what others see.

3. Step 3: Consider alternatives

   Deleting rows is destructive, copying the sheet is extra work and may cause version confusion.

4. Final Answer:

   Create a Filter View to save your personal filter settings. -> Option B

5. Quick Check:

   Filter View = personal, safe data exploration [OK]

Hint: Use Filter Views to explore data without affecting others [OK]

Common Mistakes:

• Using Filters and disturbing others
• Deleting data instead of filtering
• Copying sheets unnecessarily