Notification rules in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to open the Notification rules menu in Google Sheets.

Google Sheets

Go to the Tools menu and select [1].

Drag options to blanks, or click blank then click option'

ANotification rules

BData validation

CConditional formatting

DProtect sheet

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing Data validation instead of Notification rules

Selecting Conditional formatting which changes colors, not notifications

Notification rules are found under the Tools menu as 'Notification rules'.

2fill in blank

medium

Complete the code to set a notification rule for when any changes are made.

Google Sheets

In the Notification rules dialog, select 'Notify me at my email when' and choose [1].

Drag options to blanks, or click blank then click option'

Aa user submits a form

Ba cell is edited

Ca comment is added

Dany changes are made

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'a user submits a form' which only triggers on form responses

Selecting 'a comment is added' which only notifies about comments

Selecting 'any changes are made' ensures you get notified for all edits.

3fill in blank

hard

Fix the error in the notification frequency setting.

Google Sheets

Choose to notify me [1] changes are made.

Drag options to blanks, or click blank then click option'

Amonthly report

Bdaily digest

Cimmediately when

Dweekly summary

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'daily digest' which delays notifications

Selecting 'weekly summary' which sends one email per week

To get instant alerts, select 'immediately when'. Other options delay notifications.

4fill in blank

hard

Fill both blanks to create a notification rule for form submissions with immediate emails.

Google Sheets

Notify me at my email when [1] and send notifications [2].

Drag options to blanks, or click blank then click option'

Aa user submits a form

Bimmediately

Cdaily digest

Dany changes are made

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing event types with wrong notification timing

Choosing 'any changes are made' when only form submissions are needed

This sets notifications for form submissions and sends emails immediately.

5fill in blank

hard

Fill all three blanks to set a notification rule for any changes with daily emails and save it.

Google Sheets

Select [1] in the event list, choose to notify [2], then click [3] to save.

Drag options to blanks, or click blank then click option'

Aany changes are made

Bdaily digest

CSave

Dimmediately

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'immediately' when daily digest is needed

Forgetting to click 'Save' to apply the rule

This sets notifications for any changes, sends daily emails, and saves the rule.