Referencing other worksheets in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to reference cell A1 from the sheet named 'Sales'.

Excel

=Sales![1]

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

AA1

B1A

CB1

DSheet1

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong cell reference like B1 instead of A1.

Putting the row number before the column letter.

Using the wrong sheet name.

The correct way to reference cell A1 in another sheet named 'Sales' is =Sales!A1.

2fill in blank

medium

Complete the formula to sum cells A1 to A5 from the sheet named 'Data'.

Excel

=SUM(Data![1])

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

AData!A1:A5

BA5:A1

C1A:5A

DA1:A5

Attempts:

3 left

💡 Hint

Common Mistakes

Reversing the range like A5:A1.

Including the sheet name twice.

Using invalid cell references like 1A.

The correct range reference is A1:A5. So the formula is =SUM(Data!A1:A5).

3fill in blank

hard

Fix the error in the formula to reference cell B2 from the sheet named '2023 Sales'.

Excel

='2023 Sales'![1]

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

A2B

BB2

CB22

DSales2023

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong cell reference like 2B.

Not enclosing the sheet name in quotes when it has spaces.

Adding extra characters to the cell reference.

When a sheet name has spaces or starts with a number, it must be enclosed in single quotes. The correct cell reference is B2.

4fill in blank

hard

Fill both blanks to create a formula that multiplies cell A1 from 'Sheet1' by cell B1 from 'Sheet2'.

Excel

=Sheet1![1] * Sheet2![2]

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

AA1

BB1

CC1

DA2

Attempts:

3 left

💡 Hint

Common Mistakes

Using the same cell reference for both sheets.

Using invalid cell references like C1 or A2.

Forgetting the exclamation mark.

The formula multiplies Sheet1!A1 by Sheet2!B1.

5fill in blank

hard

Fill all three blanks to create a formula that sums cells A1 to A3 from 'Jan', 'Feb', and 'Mar' sheets.

Excel

=SUM(Jan![1], Feb![2], Mar![3])

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

AA1:A3

BB1:B3

CA2:A4

DC1:C3

Attempts:

3 left

💡 Hint

Common Mistakes

Using different ranges for each sheet.

Using invalid ranges like B1:B3 or A2:A4.

Forgetting the exclamation mark after the sheet name.

The formula sums the range A1:A3 from each sheet: Jan, Feb, and Mar.