Office 2016 For Seniors For Dummies (For Dummies (ComputerTech)) by Faithe Wempen

Author:Faithe Wempen [Wempen, Faithe]
Language: eng
Format: azw3
ISBN: 9781119077381
Publisher: Wiley
Published: 2015-10-19T00:00:00+00:00

Understand Functions

Sometimes, it’s awkward or lengthy to write a formula to perform a calculation. For example, suppose you want to sum the values in cells A1 through A10. To express it as a formula, you would have to write out each cell reference individually, like this:

=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10

In Excel, a function refers to a certain math calculation. Functions can greatly shortcut the amount of typing you have to do to create a particular result. For example, instead of the using the preceding formula, you could sum, using the SUM function like this:

=SUM(A1:A10)

With a function, you can represent a range with the upper-left corner’s cell reference, a colon, and the lower-right corner’s cell reference. In the case of A1:A10, there is only one column, so the upper left is A1 and the lower right is A10.

Each function has one or more arguments. An argument is a placeholder for a number, text string, or cell reference. For example, the SUM function requires at least one argument: a range of cells. So in

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.