12. Formulas and Functions

Calculations are the way that Excel “does the math.” Even if you’re only using Excel to keep lists, you may have numbers on which you’d like to perform some calculations (for example, totaling the number of items sold or computing bowling averages). Excel excels at calculations of this sort and provides tools to save you time and effort.

For instance, suppose you want to calculate the total of a column of numbers. You would create a formula in the cell beneath the column. The formula might look like this: ...

Get Microsoft Office 2011 for Mac: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.