Google Sheets L2

One way to ensure users enter the data you want into a Google Sheet is to provide a drop-down list. What feature allows you to do this?

• • Conditional Formatting

• • Filters

• • Data Validation

• • Data Clean up

To make workflows faster in Google Sheets, users can select multiple tabs and perform basic actions such as: (Select 3)

• • Duplicate at selected tabs

• • Color all selected tabs

• • Delete or hide all selected tabs

• • Protect all selected tabs

• • Rename all selected tabs

Mrs Wallace is a department head in a high school, and is looking at the performance grades for all students in one semester. What features can she use in Google Sheets to help analyze the data efficiently without having to search through it manually? (Select 2 correct answers)

• • Protect the sheets to keep an original copy of the data in case of errors or accidental deletion of data.

• • Use the “Scan All” function to locate specific values and student names.

• • Use filters to display required data and hide unwanted data.

• • Use charts to visually represent student progress.

What is the purpose of conditional formatting in Google Sheets? 

• To create charts and graphs

• To format cells based on specific conditions or criteria 

• To sort data in ascending or descending order 

• To perform mathematical calculations

What does the "Filter" function in Google Sheets allow you to do? 

• Create charts and graphs 

• Sort data in alphabetical order 

• Display only rows that meet certain criteria 

• Perform calculations on data