Arithmetic operators in formulas 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 * or / instead of +

Forgetting the equal sign at the start

The plus sign (+) adds two numbers or cell values in Excel formulas.

2fill in blank

medium

Complete the formula to multiply the values in cells C2 and D2.

Excel

=C2 [1] D2

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

A*

B+

C-

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using + or - instead of *

Using x instead of *

The asterisk (*) is used to multiply numbers or cell values in Excel formulas.

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 + instead of -

Using * or / by mistake

The minus sign (-) subtracts one number or cell value from another in Excel formulas.

4fill in blank

hard

Fill both blanks to create a formula that divides the value in E4 by the value in F4 and then adds 10.

Excel

=E4 [1] F4 [2] 10

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

A/

B+

C-

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the order of operators

Using * instead of / for division

Division uses the slash (/), and addition uses the plus sign (+) in Excel formulas.

5fill in blank

hard

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

Excel

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

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 + instead of - for subtraction

Use * to multiply, - to subtract, and / to divide in Excel formulas.