Absolute Cell Referencing

First: Watch the video tutorials

Second: Download the Absolute Cell Referencing Spreadsheet

Third: Complete the 3 Exampe tasks and email the spreadsheet to your ICT FS tutor

 

Absolute Cell Reference Example 1 with IF Function and Percentage.

 

 

 

 

 

Absolute Cell Reference Example 2 with IF Function and Average.

 

 

 

 

 

Absolute Cell Reference Example 3 with IF AND Function and Average.