Page 143 - Excel Workbook for Dummies

14_798452 ch09.qxp 3/13/06 7:52 PM Page 126
126 Part II: Using Formulas and Functions
CD-ROM. This file contains a Rounding Formulas worksheet where you can practice
using the ROUND, ROUNDUP, and ROUNDDOWN functions on the value of the mathe-
matical constant pi, accurate to 15 placed returned by the PI function to cell A3:

1. Position the cell cursor in cell B3 and construct a formula using the ROUND func-
tion that rounds off the value of pi in cell A3 to no decimal places.
2. In cell B4, construct a formula with the ROUND function that rounds off the value
of pi in cell A3 to one decimal place.
Because all the rounding formulas you’re going to create for this exercise use the
same value in cell A3, you can save time by making copies of the original ROUND
formula and then editing the function name or the num_digits argument in the
copies as needed. To do this, however, you must remember to convert the refer-
ence to cell A3 from relative to absolute when constructing the formula with the
Insert Function feature.
3. In cell B5, construct a formula with the ROUND function that rounds off the value
of pi in cell A3 to two decimal places.
4. In cell B6, construct a formula with the ROUND function that rounds off the value
of pi in cell A3 to three decimal places.
5. In cell B7, construct a formula with the ROUNDUP function that rounds up the
value of pi in cell A3 to two decimal places.
6. In cell B8, construct a formula with the ROUNDUP function that rounds up the
value of pi in cell A3 to four decimal places.
7. In cell B9, construct a formula with the ROUNDDOWN function that rounds down
the value of pi in cell A3 to two decimal places.
8. In cell B10, construct a formula with the ROUNDDOWN function that rounds
down the value of pi in cell A3 to four decimal places.
Compare your spreadsheet to one shown in Figure 9-1. If everything checks out,
proceed to Step 9.
9. Save your workbook file in the Chapter 9 folder with the filename Solved9-1.xls.

Figure 9-1:
The
Exercise9-1.
xls work-
book with
its ROUND,
ROUNDUP,
and ROUND-
DOWN
formulas.