Formula bar and cell preview in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to add 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 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 calculate the average of cells A1 to A5.

Excel

=AVERAGE([1])

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

AA1:A5

BA1-B5

CA1+A5

DA1*5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a minus sign instead of a colon.

Adding cells instead of selecting a range.

The range A1:A5 selects cells from A1 to A5 for the average calculation.

3fill in blank

hard

Fix the error in the formula to multiply cell B2 by 10.

Excel

=B2[1]10

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

A-

B+

C*

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus or minus instead of multiplication.

Using division operator by mistake.

The asterisk * is the multiplication operator in Excel formulas.

4fill in blank

hard

Fill both blanks to create a formula that subtracts 5 from the value in cell C3.

Excel

=C3[1][2]

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

A-

B5

C10

D+

E*

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus instead of minus.

Using 10 instead of 5.

The minus sign - subtracts the number 5 from the value in cell C3.

5fill in blank

hard

Fill all three blanks to create a formula that calculates the sum of cells D1 to D4 and then divides by 4.

Excel

=(SUM([1])[2][3])

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

AD1:D4

B/

C4

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using multiplication instead of division.

Using incorrect cell range.

The formula sums cells D1 to D4, then divides the result by 4 to find the average.