Introducing
Prezi AI.
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Loading content…
Loading…
Spreadsheets – Formulae and Functions
Transcript
If someone missed today's lesson...
how would you explain how to create an absolute reference to them?
Objectives:
Open "Auto Fill" and follow the instructions
COMMON
ICT
Mr Rogers
Auto fill.xlsx
Click on the bottom right corner and drag down to use auto fill
- Use auto fill to save time
- Know when to use absolute cell references
Spreadsheets – Formulae and Functions
Outcomes:
Key Words:
Open "Ultimate Cars"
Absolute & relative cell references
relative reference
- A spreadsheet with formulas that use absolute references
Euro = 1.2325
a relative reference moves when you use auto fill or copy & paste
COMMON
ICT
Mr Rogers
Ultimate Cars.xlsx
Calculate the prices in £ and € using a formula with an absolute reference
absolute reference
Open the worksheet "Commission" and follow the instructions
an absolute reference is 'stuck in place' using $ signs
Mr Rogers
Calculate the prices in £ and € using a formula with an absolute reference
https://www.google.co.uk/search?&q=1+GBP+to+USD
Choose a template
Presentations from around the world
Learn more about creating dynamic, engaging presentations with Prezi