Microsoft Office Tutorials and References

In Depth Information

**Chapter 10: Miscellaneous Calculations**

10

Miscellaneous Calculations

In This Chapter

Converting between measurement units

●

Formulas for calculating the various parts of a right triangle

●

Calculations for area, surface, circumference, and volume

●

Matrix functions to solve simultaneous equations

●

Formulas that demonstrate various ways to round numbers

●

This chapter contains reference information that may be useful to you at some point. Consider it a

cheat sheet to help you remember the stuff you may have learned but have long since forgotten.

Unit Conversions

You know the distance from New York to London in miles, but your European office needs the

numbers in kilometers. What’s the conversion factor?

Excel’s CONVERT function can convert between a variety of measurements in the following

categories:

h
Weight and mass

h
Distance

h
Time

h
Pressure

h
Force

h
Energy

h
Power

h
Magnetism