Excel on the web - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to sum the values in cells A1 to A5.

Excel

=SUM([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 dash (-) instead of a colon (:)

Separating cells with commas or semicolons

The correct way to specify a range in Excel is using a colon (:), so A1:A5 sums all cells from A1 to A5.

2fill in blank

medium

Complete the formula to calculate the average of cells B2 to B6.

Excel

=AVERAGE([1])

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

AB2:B6

BB2,B6

CB2;B6

DB2-B6

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash (-) instead of a colon (:)

Separating cells with commas or semicolons

Excel uses a colon (:) to specify a range of cells, so B2:B6 correctly selects all cells from B2 to B6 for averaging.

3fill in blank

hard

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

Excel

=C1[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 multiply (*)

Using divide (/) or minus (-) by mistake

To multiply in Excel, use the asterisk (*) operator. So =C1*10 multiplies the value in C1 by 10.

4fill in blank

hard

Fill both blanks to create a formula that counts how many cells in D1 to D10 are greater than 5.

Excel

=COUNTIF([1], [2])

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

AD1:D10

BD1-D10

C">5"

D>5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash (-) instead of colon (:) for range

Not putting the condition in quotes

The COUNTIF function needs a range and a condition as a text string. So D1:D10 is the range, and ">5" is the condition to count cells greater than 5.

5fill in blank

hard

Fill all three blanks to create a formula that sums values in E1 to E5 only if they are less than 20.

Excel

=SUMIF([1], [2], [3])

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

AE1:E5

B"<20"

D"<=20"

Attempts:

3 left

💡 Hint

Common Mistakes

Not putting the condition in quotes

Using a dash (-) instead of colon (:) for ranges

Mixing up the order of arguments

The SUMIF function needs the range to check (E1:E5), the condition as a string ("<20"), and the range to sum (also E1:E5).