Calculated fields in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to calculate the total price by multiplying quantity and unit price.

Excel

=A2[1]B2

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 the values instead of multiplying.

Using '-' or '/' will give incorrect results.

The multiplication operator (*) is used to calculate total price by multiplying quantity (A2) and unit price (B2).

2fill in blank

medium

Complete the formula to calculate the discount amount by multiplying price and discount rate.

Excel

=C3[1]D3

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

A+

B*

C-

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' adds values instead of calculating discount.

Using '-' or '/' gives wrong results.

Multiplying price (C3) by discount rate (D3) gives the discount amount.

3fill in blank

hard

Fix the error in the formula to calculate net price after discount.

Excel

=E4[1]F4

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

A+

B/

C*

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' adds discount instead of subtracting.

Using '*' or '/' will not calculate net price correctly.

Net price is price (E4) minus discount amount (F4), so use the subtraction operator '-'.

4fill in blank

hard

Fill both blanks to calculate total cost including tax. Multiply net price by (1 plus tax rate).

Excel

=G5[1](1[2]H5)

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

A*

B+

C-

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using '-' instead of '+' inside parentheses.

Using '+' instead of '*' between net price and parentheses.

To add tax, multiply net price (G5) by (1 + tax rate (H5)). Use '*' for multiplication and '+' to add 1 and tax rate.

5fill in blank

hard

Fill all four blanks to calculate final price with discount and tax: multiply quantity by unit price, subtract discount, then multiply by (1 plus tax rate).

Excel

=((A6[1]B6)[2]C6)[3](1[4]D6)

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

A*

B-

C+

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' instead of '-' to subtract discount.

Using '/' instead of '*' for multiplication.

Using '-' instead of '+' inside parentheses.

First multiply quantity (A6) by unit price (B6) using '*'. Then subtract discount (C6) with '-'. Finally multiply by (1 + tax rate (D6)) using '*' and '+'.