Calculated fields in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to calculate the total price by multiplying quantity in A2 by price in B2.

Google Sheets

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

Using / or - will give wrong results.

The multiplication operator * calculates total price by multiplying quantity and price.

2fill in blank

medium

Complete the formula to calculate the average of numbers in cells A1 to A5.

Google Sheets

=AVERAGE([1])

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

AA1:A5

BA1-A5

CA1+A5

DA1,A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a minus sign or comma instead of colon for range.

Adding cells instead of selecting a range.

The range A1:A5 selects all cells from A1 to A5 for averaging.

3fill in blank

hard

Fix the error in the formula to calculate the percentage of B2 over A2.

Google Sheets

=[1]/A2*100

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

AB2*

BA2

CB2

DB2/

Attempts:

3 left

💡 Hint

Common Mistakes

Using A2 in numerator instead of B2.

Adding extra operators causing syntax errors.

The formula divides B2 by A2 and multiplies by 100 to get the percentage.

4fill in blank

hard

Fill both blanks to create a formula that sums values in B2 to B10 only if corresponding A2 to A10 cells equal "Yes".

Google Sheets

=SUMIF([1], [2], B2:B10)

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

AA2:A10

B"No"

C"Yes"

DB2:B10

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong range for condition.

Using "No" instead of "Yes" as condition.

The SUMIF function sums values in B2:B10 where cells in A2:A10 equal "Yes".

5fill in blank

hard

Fill all three blanks to create a formula that counts how many cells in C2:C20 are greater than 50.

Google Sheets

=COUNTIF([1], "[2][3]")

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

AC2:C20

B>

C50

D"<50"

Attempts:

3 left

💡 Hint

Common Mistakes

Using separate arguments for operator and number instead of combined string.

Using less than operator instead of greater than.

The COUNTIF function counts cells in C2:C20 where values are greater than 50. The condition is written as a string ">50".