Relative references (A1) in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to add the values in cells A1 and B1.

Excel

=A1[1]B1

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

A+

B-

C*

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using a minus (-) instead of plus (+).

Using multiplication (*) or division (/) by mistake.

The plus sign (+) adds the values of cells A1 and B1.

2fill in blank

medium

Complete the formula to multiply the value in cell C2 by 10.

Excel

=C2[1]10

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

A+

B-

C/

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus (+) instead of multiplication.

Using division (/) or subtraction (-) by mistake.

The asterisk (*) multiplies the value in C2 by 10.

3fill in blank

hard

Fix the error in the formula to subtract B3 from A3.

Excel

=A3[1]B3

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

A-

B/

C*

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus (+) instead of minus (-).

Using multiplication (*) or division (/) by mistake.

The minus sign (-) subtracts the value in B3 from A3.

4fill in blank

hard

Complete the formula to divide the value in D4 by the value in E4.

Excel

=D4[1]E4

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

A*

B/

C+

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using multiplication (*) or addition (+) instead of division.

Using subtraction (-) by mistake.

The forward slash (/) divides the value in D4 by the value in E4.

5fill in blank

hard

Fill both blanks to create a formula that adds A5 and B5, then multiplies the result by C5.

Excel

=(A5[1]B5)[2]C5

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

A+

B*

C-

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using subtraction (-) or division (/) instead of addition or multiplication.

Forgetting parentheses to control order of operations.

The formula adds A5 and B5 using +, then multiplies the sum by C5 using *.