O'Reilly logo

Take Control of Numbers by Sharon Zardetto

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Fun with Formulas and Functions

Maybe you won’t consider this chapter fun, exactly (although I do), but it should at least remove any stress accompanying your dealings with formulas and functions.

It starts with the two quick ways of accessing the most common spreadsheet functions (such as SUM and AVERAGE): the Function Button and the Quick Calculations Bar (which has an alternative identity as the Smart Cell View).

Then we’ll move on to creating your own formulas, starting with what you need to know about basic math operations as they relate to entering information in a formula: Typing Mathematical Operators and The Order of Operations. Next, we’ll make sure you understand Cell References—the different ways you can refer to cells; it’s particularly ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required