Flashcards
ICT (spreadsheets)
Cards in this deck (4)
- 1Relative Cell ReferencingChanges in accordance to the position in the spreadsheet.
eg:
=A1*B1
=SUM(A1:A7)
Any formulas with a dollar sign in $$ are an absolute cell reference. - 2Absolute Cell ReferencingCell staying the same even when the position has changed.
- 3Absolute Cell Reference ($)Uses the dollar symbol $ $
Examples of absolute cell referencing:
=A1*$B$14 - 4Cloud
Information
- Description
- Flashcards on ICT (spreadsheets), created by Linette Joseph on 01/03/2019.
- Created by
- Linette Joseph
- Views
- 0
- Rating