Spreadsheets – theory and practical skills Flashcards
1
Q
Why do we use $ in front of formulae?
A
Absolute cell referencing is a way of fixing the position of a cell within a formula e.g. if the formulae is replicated the reference to the cell will not change
2
Q
What is a 0 or 1 in lookups?
A
0- forces an exact match
1- forces an approximate match
