Using Excel Functions:
We have already seen how Excel can be used to perform simple calculations by typing equations into cells within the spreadsheet. Obviously, we would want to perform calculations using basic mathematical functions and constants, such as sin x, log y, or π. In this section, we will use Excel's built-in functions to perform elementary calculations. Functions are entered in cells as part of an equation; remember that equations in cells always begin with an “=” sign. We will also use the techniques learned in the preceding exercises to create a series of values, fill cells in the same column with the same formula, and perform calculations using both absolute and relative referencing.