Microsoft Office Tutorials and References
In Depth Information
You can use a defined name as an argument to a function. For example, if you click the
Formulas tab on the ribbon and use the Define Name button to assign the name QtrlyIncome
to the range C3:C6, you can use the formula =SUM(QtrlyIncome) to total the numbers in
cells C3, C4, C5, and C6.
For more about names, see “Naming cells and cell ranges” in Chapter 12.
You can use an array as an argument in a function. Some functions, such as TREND and
TRANSPOSE, require array arguments; other functions don’t require array arguments but do
accept them. Arrays can consist of numbers, text, or logical values.
For more about arrays, see “Using arrays” in Chapter 12.
Mixed argument types
You can mix argument types within a function. For example, the formula
=AVERAGE(Group1,A3,5 * 3) uses a defined name (Group1), a cell reference (A3), and a
numeric expression (5 * 3) to arrive at a single value. All three are acceptable.
The easiest way to locate and insert built-in functions is by clicking the Insert Function
button. This button has two versions—one is the little fx button that appears on the formula
bar, and the other is located in the Function Library group on the Formulas tab on the
ribbon. In either location, when you click Insert Function, the dialog box shown in Figure 13-2
appears. If you’re not sure what function you need, type a description of what you are
trying to do in the Search text box. For example, if you type how many cells contain values
and then click the Go button, the Insert Function dialog box returns a list of recommended
functions, similar to the list shown in Figure 13-5.
You can also select a function category from the Or Select A Category drop-down list to
filter the list. Function categories include Financial, Date & Time, Lookup & Reference, Text,
and more. The Recommended category keeps track of any functions returned as a result
of using the Search text box. When you select a function, the syntax and a brief
description appear at the bottom of the dialog box. You can obtain help on a function selected in
the Select A Function list by clicking the Help On This Function link at the bottom of the