Summary

In this chapter, you learned to perform calculations with formulas and functions. You know that a formula is the recipe for a calculation, and you know how to assemble it from its various components—an equal sign, cell or range references, operators, and more. You know how to create the formulas you need, and how to troubleshoot them when they go wrong.

You're now also familiar with functions. You know that a function is a preset calculation built into Excel, how to insert functions from the Ribbon or by typing them into cells, and how to give functions the arguments they need to work.

In the next chapter, I'll show you how to create powerful and persuasive charts from your data.

Get Office 2010 Made Simple 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.