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….
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
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.