Formula structure (=, cell references) 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 sign (-) instead of plus (+).

Forgetting to start the formula with '='.

The plus sign (+) adds the values of the two cells.

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 slash (/) which divides instead of multiplies.

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

Fill both blanks to create a formula that divides the value in D4 by 2 and then adds 5.

Excel

=D4[1]2[2]5

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

A/

B+

C-

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up the order of operations.

Using multiplication (*) instead of division (/).

First, divide D4 by 2 using '/', then add 5 using '+'.

5fill in blank

hard

Fill all three blanks to create a formula that multiplies A5 by B5, subtracts 10, and then divides by 2.

Excel

=((A5[1]B5)[2]10)[3]2

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

A*

B-

C/

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting parentheses causing wrong calculation order.

Using '+' instead of '-' for subtraction.

Multiply A5 and B5 with '*', subtract 10 with '-', then divide by 2 with '/'.