Named ranges in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to sum the values in the named range called 'Sales'.

Google Sheets

=SUM([1])

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

ASales

BA1:A10

CSUM

DTotal

Attempts:

3 left

💡 Hint

Common Mistakes

Using cell references instead of the named range.

Trying to put quotes around the named range.

The named range 'Sales' can be used directly in formulas like =SUM(Sales) to sum all values in that range.

2fill in blank

medium

Complete the formula to calculate the average of the named range 'Expenses'.

Google Sheets

=AVERAGE([1])

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

ASUM

BExpenses

CA1:A20

DTotal

Attempts:

3 left

💡 Hint

Common Mistakes

Using cell references instead of the named range.

Using the wrong function like SUM instead of AVERAGE.

Use the named range 'Expenses' directly inside the AVERAGE function to calculate the average.

3fill in blank

hard

Fix the error in the formula to count how many cells in the named range 'Inventory' are greater than 10.

Google Sheets

=COUNTIF([1], ">10")

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

AInventory

B"Inventory"

CInventory()

DInventory[]

Attempts:

3 left

💡 Hint

Common Mistakes

Putting quotes around the named range name.

Adding parentheses or brackets after the named range.

Named ranges should be used without quotes or parentheses in formulas. So use Inventory directly.

4fill in blank

hard

Fill both blanks to create a formula that sums values in the named range 'Revenue' only if they are greater than 100.

Google Sheets

=SUMIF([1], [2])

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

ARevenue

B"<100"

C">100"

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong named range.

Using the wrong comparison operator or missing quotes.

The formula =SUMIF(Revenue, ">100") sums all values in the named range 'Revenue' that are greater than 100.

5fill in blank

hard

Fill all three blanks to create a formula that sums values in the named range 'Revenue' where the corresponding values in 'Region' are 'North' and in 'Quarter' are 'Q1'.

Google Sheets

=SUMIFS([1], [2], "North", [3], "Q1")

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

ARevenue

BRegion

CQuarter

DExpenses

Attempts:

3 left

💡 Hint

Common Mistakes

Incorrect argument order.

Forgetting quotes around text criteria like "North".

The formula =SUMIFS(Revenue, Region, "North", Quarter, "Q1") sums values from 'Revenue' meeting both criteria using the parallel named ranges 'Region' and 'Quarter'.