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

Search JabSto ::

Custom Search