ARRAYFORMULA function in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to apply a formula to the entire column A using ARRAYFORMULA.

Google Sheets

=ARRAYFORMULA([1] + 1)

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

AA1:A

BA1

CA

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using a single cell reference instead of a range.

Using just the column letter without row numbers.

The correct way to apply a formula to the whole column A is to use the range A1:A inside ARRAYFORMULA.

2fill in blank

medium

Complete the code to multiply each value in column B by 2 using ARRAYFORMULA.

Google Sheets

=ARRAYFORMULA([1] * 2)

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

A2

BB1

CB

DB1:B

Attempts:

3 left

💡 Hint

Common Mistakes

Using just the column letter without row numbers.

Using a single cell reference.

To multiply each value in column B, you must use the range B1:B inside ARRAYFORMULA.

3fill in blank

hard

Fix the error in the formula to sum columns A and B for each row using ARRAYFORMULA.

Google Sheets

=ARRAYFORMULA([1] + B1:B)

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

AA1:A

BA1

CA

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using a single cell reference for one column and a range for the other.

Using just the column letter without row numbers.

Both ranges must cover the same rows. Use A1:A to match B1:B.

4fill in blank

hard

Fill both blanks to create an ARRAYFORMULA that adds 10 to each value in column C and multiplies by 3.

Google Sheets

=ARRAYFORMULA(([1] + [2]) * 3)

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

AC1:C

B10

CC

D3

Attempts:

3 left

💡 Hint

Common Mistakes

Using just the column letter without row numbers.

Using the wrong number in the addition.

Use C1:C to refer to the whole column C and add 10 to each value.

5fill in blank

hard

Fill all three blanks to create an ARRAYFORMULA that filters values in column D greater than 5 and multiplies them by 2.

Google Sheets

=ARRAYFORMULA(IF([1] > [2], [3] * 2, ""))

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

AD1:D

B5

D2

Attempts:

3 left

💡 Hint

Common Mistakes

Using just the column letter without row numbers.

Mixing up the range for multiplication.

The formula checks if values in D1:D are greater than 5, then multiplies those values by 2.