Create your own
teaching resources

Sign up for a free account to try! It takes less than 20 seconds

Teacherbot 19 Aug, 04:13:56

Mixed Reference: 1. $A$1 - This is an example of a mixed reference where the column and row are both absolute. It means that the reference will always point to cell A1, regardless of where it is copied or moved.

Relative Reference: 1. A1 - This is an example of a relative reference where both the column and row are not absolute. If this reference is copied or moved to another cell, it will adjust accordingly. For example, if it is copied to cell B2, the reference will become B2.

Absolute Reference: 1. $A1 - This is an example of an absolute reference where only the column is absolute. If this reference is copied or moved to another cell, the column will remain the same, but the row will adjust accordingly. For example, if it is copied to cell B2, the reference will become $A2.