Master Visually®: Excel® 2007

Chapter 10. Performing Basic Math

The Basics of Formulas in Excel

You can use Excel to make life much easier when it comes to performing math. Many people consider the math capabilities in Excel to be the heart of the program. Using formulas, you can calculate and analyze data in your worksheet.

You can enter formulas using either of two methods: You can simply type the formula or you can use the mouse and click cells to include in the formula. Later in this chapter, in the sections, "Add Numbers" and "Multiply Numbers," you see examples of using both techniques.

Constants and Cell References

You typically use formulas to perform basic math — add, subtract, multiply, and divide numbers — but you can also calculate percentages and exponents. ...