Join David Rivers for an in-depth discussion in this video Using cell references, part of Numbers 3 Essential Training.
Voiceover: We've already learned how…we can save a lot of time by copying formulas…and function in a table.…We did this in the previous movie,…copying the formula from our difference column here down…and it knew to use the right numbers in the right rows.…It's called relative addressing.…But sometimes you don't want that happening.…For example, when we go to the difference Canadian…in this column,…and click in cell E3,…all we want to do now is…take the difference of value and…multiply it by the exchange rate.…
So let's start our simple formula with an equal sign.…We'll select the cell D3,…multiply, the symbol is the asterisk on your keyboard,…it puts in the multiplication sign,…and it's this value we want to multiply it by.…It's from a different table in a different cell.…We click the check mark and there's the value,…you can see 38,051 instead of 34,910.…All right, so we get a little bit more in Canadian dollars.…If we want to copy that down now,…and if we try to, look what happens.…
Click and drag that handle in the middle,…
- Creating and laying out spreadsheets
- Importing data
- Working with tables
- Adding images to cells
- Performing calculations with formulas and functions
- Creating charts
- Formatting text and numbers
- Including audio, video, and shapes
- Designing templates
- Printing and sharing spreadsheets
Skill Level Beginner
1. Getting Started with Numbers
2. Working with Spreadsheets
3. Working with Tables
4. Working with Table Styles
5. Using Formulas and Functions
6. Working with Charts
7. Working with Text and Numbers
8. Working with Objects
9. Creating Your Own Templates
10. Sharing Your Spreadsheets
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.