Relative, Absolute and Mixed Cell References
Cell references control what happens to a formula when it is copied to another location. A relative reference changes as the formula moves, an absolute reference remains locked to one cell, and a mixed reference locks only the row or only the column. Understanding the dollar sign is essential when one fixed rate, price or assumption is used across many calculations
How would you like to use this resource?
Purchase this resource or use an active membership to open it.Protected previewPurchase this resource or use an active membership to open the complete PDF.
About this resource
Designed for A4 Portrait printing. Keep your printer set to actual size for the intended result.
Recommended material: Paper£2
Secure Stripe checkout is being prepared. You may add this resource to your basket, but no payment will be attempted until checkout is securely enabled.
Or view Membership for accessGoogle Sheets
Protected previewPurchase this resource or use an active membership to open the complete PDF.