Microsoft Office Tutorials and References

In Depth Information

**Using Functions**

3. Select the cell (or cells) where you want to paste your formula.

If you select multiple cells, Excel pastes a copy of your formula in each

of those cells.

4. Press Ctrl+V (or click the Paste icon under the Home tab).

Excel pastes your formula and automatically changes the cell references.

5. Press Esc or double-click away from the cell with the dotted line to

make the dotted line go away.

Using Functions

Creating simple formulas is easy, but creating complex formulas is hard. To

make complex formulas easier to create, Excel comes with prebuilt formulas

called functions. Table 9-3 lists some of the many functions available.

Table 9-3

Common Excel Functions

Function

Name

What It Does

AVERAGE

Calculates the average value of numbers stored in two or more cells

COUNT

Counts how many cells contain a number instead of a label (text)

MAX

Finds the largest number stored in two or more cells

MIN

Finds the smallest number stored in two or more cells

ROUND

Rounds a decimal number to a specific number of digits

SQRT

Calculates the square root of a number

SUM

Adds the values stored in two or more cells

Excel literally provides hundreds of functions that you can use by themselves

or as part of your own formulas. A function typically uses one or more cell

references:

✓

Single cell references,
such as =ROUND(C4,2), which rounds the

number found in cell C4 to two decimal places

✓

Contiguous
(adjacent) cell ranges,
such as =SUM(A4:A9), which adds all

the numbers found in cells A4, A5, A6, A7, A8, and A9

✓

Noncontiguous cell ranges,
such as =SUM(A4,B7,C11), which adds all

the numbers found in cells A4, B7, and C11