Absolute Cell References. Unit 2 ICT GNVQ. Lesson Objectives. To use an absolute cell reference in a formula To use the www.ictgnvq.org.uk website effectively. What you are asked to do….
Absolute Cell References
Unit 2 ICT GNVQ
Enter the discount as 15% in a cell near or at the top of the spreadsheet. Create two new columns (with suitable headings)
Highlight the top row of your spreadsheet model, click “Insert” then “rows”. This will insert one row. Now do this once or twice more to insert two or three rows
Formula displayed in formula bar
New price displayed in cell F5
The formula used in cell F6 will be this:
This uses cell C3 in the formula – it is empty – so the amount shown in cell F6 is the same price as before. We need to find some way to make sure the formula always uses the cell address C2 in each formula.