What are the advantages of using this method rather than typing the cell location directly into the formula?
- faster than typing, and avoids possible typing errors
What is the difference between a formula and a function?- functions are built in formulas. Cell formulas can contain several functions
What is the difference between an absolute reference and a relative reference?
- when cells which have absolute reference are copied they will always point to the original referenced cell.
When should you use an absolute/relative reference?
- when you want the formula to always point to a specific cell no matter in which cell the formula is copied to
What is a mixed cell reference?
- absolute row and relative column, or absolute column and relative row
Hope this helps