Beginner

20 mins

Teacher/Student led

Learning Goals

Learning Outcomes

+10 XP

What you need:
Chromebook/Laptop/PC

Using Cell References

Warning: Your screen size is quite small for viewing this. Rotate your device into landscape mode if you can.

1 Let's Learn!
2 The Magic of Cell References
3 Using Cell References in Excel
4 Why Use Cell References?
5 Different Types of Cell References
6 How to Use Cell References:
7 Examples
8 Practice Time!
Quiz

1 - Let's Learn!

As we continue our enchanting journey into the realm of Excel, we'll uncover the magic of "Using Cell References." Just as a map guides a traveler, cell references guide Excel to the exact location of the data we want to use. Let's embark on this new adventure and discover the power of pointing!

2 - The Magic of Cell References

In Excel, each cell has a unique address made of a letter (for the column) and a number (for the row). For instance, the top-left cell's address is "A1". By using these addresses in our formulas, we can instruct Excel to fetch data from specific cells.

Example:

If you want to add the numbers in cell A1 and B1, you don't have to know what the numbers are! Just tell Excel to add "A1 and B1" using the formula =A1+B1.

3 - Using Cell References in Excel

In the magical world of Excel, think of each cell as a tiny box that can hold a piece of information, like a number or a word.

These boxes have addresses, just like houses do! The address of each box (or cell) is made up of a letter (representing the column) and a number (representing the row). For example, the top-left box's address is "A1".

4 - Why Use Cell References?

Flexibility: By pointing to a cell's address instead of typing a number, you can easily change the number in the cell without rewriting the whole formula.

Accuracy: It reduces the chance of making errors. Imagine having a long formula; using cell references ensures you're always pulling the right data.

Clarity: When someone else looks at your Excel sheet, they can easily trace where the numbers are coming from.

5 - Different Types of Cell References

Direct Reference: Pointing to a single cell, like A1.

Range Reference: Pointing to a group of cells, like A1:A3.

Did You Know?

You can even reference cells from different sheets in the same workbook. It's like having a magical portal between rooms!

Unlock the Full Learning Experience

Get ready to embark on an incredible learning journey! Get access to this lesson and hundreds more on our learning platform.

Get started

Copyright Notice
This lesson is copyright of Coding Ireland 2017 - 2025. Unauthorised use, copying or distribution is not allowed.

Your Answer or Description of Your Work

Project URL This can be a link to your project (e.g. a Scratch, Microbit, Arcade or CodePen URL link).

Upload File

You must be logged into Scratch to share your project, otherwise the link will not work.

To get the URL link of your Scratch project:

Make sure you're logged into Scratch.
Click on the Share button in the project editor.
Click on the Copy Link button.
Click on the Copy Link link. This will save the URL of your project page into your clipboard.

To get the URL link of your Microbit project:

Click on the button in the project editor.
Click on the Publish Project button.
Click on the Copy button. This will save the URL of your project page into your clipboard.

To get the URL link of your Arcade project:

Click on the button in the project editor.
Click on the Publish Project button.
Click on the Copy button. This will save the URL of your project page into your clipboard.

To get the URL link of your CodePen project:

Make sure you're logged into CodePen.
Open your project in the editor.
Click on the Save button at the top of the editor.
Copy the link from the address bar in your web browser (e.g. https://codepen.io/Jane-Smith/pen/gOVXxBQ)