Google Sheets Conditional Formatting Quiz

Google Sheets Conditional Formatting Quiz

Assessment

Interactive Video

Computers

9th - 10th Grade

Practice Problem

Hard

Created by

Nancy Jackson

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What tool is used to import data into Google Sheets in the video?

Coupler.io

Zapier

Data Studio

Integromat

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which format is applied to the 'Payments' column in the video?

Text

Date

Currency

Percentage

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of using a single color in conditional formatting?

To highlight cells based on specific conditions

To change the font style

To sort data automatically

To apply a gradient based on values

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What should you do if you want to highlight cells based on text conditions?

Use a color scale

Use a single color with 'Text is exactly' condition

Use a custom formula

Use data validation

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you highlight the entire row based on a condition in Google Sheets?

By using a color scale

By using data validation

By using a single color option

By using a custom formula

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which feature allows you to apply the same formatting to a new spreadsheet?

Format Painter

Conditional Formatting

Data Validation

Custom Formula

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What color is used to mark data pulled from a different worksheet?

Light Red

Light Blue

Dark Yellow

Green

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?