AutoFill for formula copying in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to multiply cell A1 by 2 and copy it down the column.

Google Sheets

=A1[1]2

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

A*

B+

C-

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using + instead of * will add instead of multiply.

Using / will divide, not multiply.

The asterisk (*) is used for multiplication in Google Sheets formulas.

2fill in blank

medium

Complete the formula to sum cells from B1 to B5.

Google Sheets

=SUM([1])

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

AB1-B5

BB1+B5

CB1:B5

DB1*B5

Attempts:

3 left

💡 Hint

Common Mistakes

Using B1+B5 adds only two cells, not the whole range.

Using B1-B5 or B1*B5 are incorrect for summing.

Using B1:B5 selects the range of cells from B1 to B5 to sum.

3fill in blank

hard

Fix the error in the formula to calculate the average of cells C1 to C4.

Google Sheets

=AVERAGE([1])

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

AC1,C4

BC1:C4

CC1-C4

DC1;C4

Attempts:

3 left

💡 Hint

Common Mistakes

Using semicolon or comma separates cells incorrectly.

Using subtraction operator (-) is invalid here.

The correct range syntax uses a colon (:), so C1:C4 selects all cells from C1 to C4.

4fill in blank

hard

Fill both blanks to create a formula that multiplies each value in column D by 3 for rows 1 to 5.

Google Sheets

={D[1]*[2]

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

A1:5

B3

C2

DA1:A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using A1:A5 selects wrong column.

Multiplying by 2 instead of 3 gives wrong result.

D1:5 selects rows 1 to 5 in column D, and multiplying by 3 scales each value by 3.

5fill in blank

hard

Fill all three blanks to create a formula that sums values in E1 to E4 only if they are greater than 10.

Google Sheets

=SUMIF(E[1], ">"&[2], E[3])

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

A1:4

B10

D5:8

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong ranges like 5:8.

Not concatenating ">" with the number 10.

The range E1:4 selects cells E1 to E4. The condition ">"&10 means values greater than 10. The sum range is also E1:4.