The Understand Cell References and Formulas module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises:

  • Understanding Formulas
  • Understanding Cell References

Lab time: It will take approximately 1 hour to complete this lab.

Exercise 1 - Understanding Formulas

The power of Excel is in formulas, which are combinations of numbers, operators, and cell references that perform calculations.

You will learn how to identify the elements on an Excel formula, how cell references work when worksheet design considerations come into play and how to perform calculations by entering formulas in cells.

Exercise 2 - Understanding Cell References

Excel uses different types of references to refer to cells and ranges either absolutely, or relatively to the location where the reference appears. The different types are useful in different situations.

You will learn:

  • About the limitations of relative references
  • How to enter absolute and mixed references in formulas

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.