LABEL for column headers in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to add a label "Sales" above the data in column A.

Google Sheets

=LABEL(A2:A10, [1])

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

ASales

B"Sales"

C'Sales'

DSales"

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting the quotes around the label text.

Using single quotes instead of double quotes.

Typing the label without quotes causing an error.

The LABEL function requires the label text in quotes. So use "Sales" to label the column.

2fill in blank

medium

Complete the formula to label the range B2:B15 as "Expenses".

Google Sheets

=LABEL([1], "Expenses")

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

AB2:B15

BB1:B15

CB2:B14

DB3:B15

Attempts:

3 left

💡 Hint

Common Mistakes

Including the header row in the range.

Selecting a range that is too short or too long.

Using incorrect cell references.

The range to label is B2:B15, which contains the data without the header row.

3fill in blank

hard

Fix the error in the formula to label C2:C20 as "Profit".

Google Sheets

=LABEL(C2:C20, [1])

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

AProfit

Bprofit

C'Profit'

D"Profit"

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting quotes around the label text.

Using single quotes instead of double quotes.

Using lowercase without quotes.

The label text must be enclosed in double quotes to be recognized as a string.

4fill in blank

hard

Fill both blanks to label the range D3:D12 as "Revenue" and the range E3:E12 as "Cost".

Google Sheets

=ARRAYFORMULA({LABEL(D3:D12, [1]), LABEL(E3:E12, [2])})

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

A"Revenue"

B"Profit"

C"Cost"

D"Sales"

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up the labels for the two ranges.

Forgetting quotes around label text.

Using labels not matching the data.

The first label is "Revenue" for D3:D12, and the second label is "Cost" for E3:E12.

5fill in blank

hard

Fill all three blanks to create a dictionary with keys as uppercase column headers and values as the ranges labeled "Q1", "Q2", and "Q3".

Google Sheets

=[1]: LABEL(A2:A10, [2]), [3]: LABEL(B2:B10, "Q2"), "Q3": LABEL(C2:C10, "Q3")}

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

A"Q1"

B"Q2"

C"Q3"

D"q1"

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting double quotes around keys or labels.

Using incorrect key for the corresponding range.

Using lowercase instead of uppercase for keys.

The dictionary uses keys "Q1", "Q2", "Q3" (uppercase column headers). The value for "Q1" is the A2:A10 range labeled "Q1", for "Q2" is B2:B10 labeled "Q2", and for "Q3" is C2:C10 labeled "Q3". Thus, BLANK_1 (key) and BLANK_2 (label) are both "Q1"; BLANK_3 (key) is "Q2".