Co-authoring in real time in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Excel

=SUM(A1[1]A5)

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

A,

B-

C;

D:

Attempts:

3 left

💡 Hint

Common Mistakes

Using a comma instead of a colon to specify a range.

Using a semicolon which is not valid for ranges.

Using a dash which is not recognized as a range operator.

The colon ':' is used to specify a range of cells in Excel formulas.

2fill in blank

medium

Complete the formula to calculate the average of cells B1 to B10.

Excel

=AVERAGE(B1[1]B10)

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

A:

B;

C,

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using a comma which separates arguments, not ranges.

Using a semicolon which is not valid in this context.

Using a dash which is not recognized as a range.

The colon ':' defines the range of cells from B1 to B10 for the AVERAGE function.

3fill in blank

hard

Fix the error in the formula to count non-empty cells in C1 to C20.

Excel

=COUNTA(C1[1]C20)

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

A:

B,

C;

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using a comma which separates arguments, not ranges.

Using a semicolon which is invalid here.

Using a dash which causes a formula error.

The colon ':' is needed to specify the range from C1 to C20 in the COUNTA function.

4fill in blank

hard

Complete the code to create a formula that sums cells D1 to D5 and multiplies by 2.

Excel

=SUM(D1:D5)[1]2

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

A:

B*

C+

D-

Attempts:

3 left

💡 Hint

Common Mistakes

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

Using ',' instead of ':' for range.

Using '-' which subtracts instead of multiplies.

The colon ':' defines the range D1 to D5 for SUM, and the asterisk '*' multiplies the result by 2.

5fill in blank

hard

Fill both blanks to create a formula that counts cells E1 to E10 with values greater than 5.

Excel

=COUNTIF(E1:E10, ">"[1][2])

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

A:

B&

C5

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' instead of '&' to join strings.

Using ',' instead of ':' for range.

Leaving out the number 5 in the condition.

The colon ':' defines the range E1 to E10. The ampersand '&' joins the '>' operator with the number 5 to form the condition ">5".