GCE Level 1 Prep - SHEETS Quiz

What is the primary advantage of using Filter Views in Google Sheets instead of regular filters?

• A) Filter Views are faster to apply.
• B) Filter Views allow multiple users to filter data independently without affecting others.
• C) Filter Views automatically save data changes.
• D) Filter Views can only be used by the spreadsheet owner.

Which feature in Google Sheets allows you to automatically fill a series of cells with a pattern or sequence?

• A) AutoFill
• B) Flash Fill
• C) Smart Fill
• D) Quick Fill

Which Google Sheets feature allows you to create a visual representation of your data?

• A) Pivot Tables
• B) Charts
• C) Conditional Formatting
• D) Data Validation

How can you quickly apply the same formatting to multiple cells in Google Sheets?

• A) Copy and paste formatting
• B) Use the paint format tool
• C) Apply a custom style
• D) Use keyboard shortcuts

Which of the following is NOT a valid data type in Google Sheets?

• A) Number
• B) Date
• C) Currency
• D) Image