Workbook, worksheet, and cell structure in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to reference cell A1 in Excel.

Excel

=[1]

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

A1A

BA1

CCellA1

DSheet1!A1

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the row and column like 1A.

Using sheet name without exclamation mark.

Using words like CellA1.

In Excel, to reference a cell, you use its column letter followed by its row number, like A1.

2fill in blank

medium

Complete the formula to sum cells from 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.

Only referencing two cells instead of a range.

Excel uses a colon ':' to specify a range of cells, like A1:A5.

3fill in blank

hard

Fix the error in this formula that references cell B2 on Sheet2.

Excel

=Sheet2[1]B2

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

A B2

B:B2

C!B2

D.B2

Attempts:

3 left

💡 Hint

Common Mistakes

Using a space instead of '!'.

Using a dot or colon instead of '!'.

Leaving out the separator.

In Excel, to reference a cell on another sheet, use an exclamation mark '!' between the sheet name and cell.

4fill in blank

hard

Fill both blanks to create a formula that multiplies cell C3 by 10 and adds cell D4.

Excel

= [1] * 10 + [2]

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

AC3

BD4

C10

DC4

Attempts:

3 left

💡 Hint

Common Mistakes

Using numbers instead of cell references.

Swapping the cell references.

Using incorrect cell references.

The formula multiplies the value in C3 by 10, then adds the value in D4.

5fill in blank

hard

Fill all three blanks to create a formula that sums cells A1 to A5, then divides by the count of those cells.

Excel

=SUM([1])/COUNT([2]) + [3]

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

AA1:A5

C0

DA1;A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using different ranges for SUM and COUNT.

Using semicolon instead of colon in ranges.

Adding a number other than zero.

This formula calculates the average of cells A1 to A5 by summing them and dividing by their count, then adds 0.