Entering and editing data in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to enter the number 100 into cell A1.

Google Sheets

Type [1] into cell A1.

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

A=100

B100

CSUM(A1:A10)

D"A1"

Attempts:

3 left

💡 Hint

Common Mistakes

Typing =100 which makes it a formula

Typing "100" which enters text instead of a number

To enter the number 100, just type 100 directly into the cell.

2fill in blank

medium

Complete the code to edit cell B2 by replacing its content with the text "Hello".

Google Sheets

Click on cell B2 and type [1] then press Enter.

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

A=Hello

BHello

CHELLO

D"Hello"

Attempts:

3 left

💡 Hint

Common Mistakes

Typing =Hello which causes an error

Typing Hello without quotes which may be interpreted as a formula or cause errors

Typing "Hello" with quotes enters the text Hello into the cell.

3fill in blank

hard

Fix the error in the formula to sum cells A1 to A5: =SUM(A1:A5{{BLANK_1}}

Google Sheets

=SUM(A1:A5[1]

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

A)

B]

C}

D(

Attempts:

3 left

💡 Hint

Common Mistakes

Using square or curly brackets instead of parentheses

Forgetting to close the parenthesis

The SUM function requires a closing parenthesis to complete the formula.

4fill in blank

hard

Fill both blanks to create a formula that multiplies cell A1 by 10 and adds 5.

Google Sheets

=A1 [1] 10 [2] 5

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

A*

B+

C-

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using + instead of * for multiplication

Using - or / which changes the calculation

The formula multiplies A1 by 10 using * and then adds 5 using +.

5fill in blank

hard

Fill all three blanks to create a formula that calculates the average of cells B1 to B5 and subtracts 2.

Google Sheets

=AVERAGE([1]:[2]) [3] 2

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

AB1

BB5

C-

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Using + instead of - which adds 2 instead of subtracting

Using wrong cell references for the range

The formula averages cells B1 to B5 and subtracts 2 using the - operator.