The assumption is that after taking ENGR 1101/1901: Introduction to Engineering and Engineering Technology, you are proficient in cell referencing (relative, absolute, and mixed). This is pre-requisite knowledge for this course and will not be re-taught. Additionally, we assume that you are proficient in the factor-label method used for unit conversion.

To Do:

Please take a look at the following Excel file. The first three worksheet tabs have different examples which require different types of cell referencing. Your job is to attempt them and check your answers with the solutions that are on the following three worksheets.

Pre-Req Concept Check - Cell Referencing in Excel

If you are struggling with this, check out the following resources that were shared in ENGR 1101/1901.

Resources:

Factor Label Method Refresher Videos

Cell Referencing Refresher Videos 6, 7a, 7b