Microsoft Office Tutorials and References

In Depth Information

**Chapter 8: Advancing Your Math**

Chapter 8

Advancing Your Math

In This Chapter

▶
Calculating the diameter, circumference, and area of a circle

▶
Returning random numbers

▶
Working with combinations and permutations

▶
Performing sophisticated multiplication

▶
Using the MOD function to test other numerical values

▶
Using the SUBTOTAL function for a variety of arithmetic and statistical totals

▶
Using the SUMIF and SUMIFS functions for selective summation

▶
Getting an angle on trigonometry functions

In this chapter, I show you some of the more advanced math functions.

You won’t use these functions every day, but they’re just the right thing

when you need them. Some of this will come back to you because you

probably learned most of this in school.

Using PI to Calculate Circumference

and Diameter

Pi is the ratio of a circle’s circumference to its diameter. A circle’s

circumference
is its outer edge and is equal to the complete distance around the circle.

A circle’s
diameter
is the length of a straight line spanning from one side of

the circle, through the middle, and reaching the other side.

Dividing a circle’s circumference by its diameter returns a value of

approximately 3.14159, known as
pi.
Pi is represented with the Greek letter pi and the

symbol π.