
3
More Excel
I
n this chapter, we continue to build upon what we learned in
the previous chapter. We will look at how to reference a range
of cells, types of cell referencing, the AutoFill feature of Excel,
copying of formulas, and using names in formulas. We will also look
at worksheet functions, nesting of functions, and some commonly
used functions. We will work through two exercises illustrating
the use of worksheet functions. While working with formulas, it is
likely that you will encounter Excel error messages. We will look
at Excel error messages and explore some Excel features that help
us understand complex formulas and