Microsoft Office Tutorials and References
In Depth Information
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.
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.
Common Excel Functions
What It Does
Calculates the average value of numbers stored in two or more cells
Counts how many cells contain a number instead of a label (text)
Finds the largest number stored in two or more cells
Finds the smallest number stored in two or more cells
Rounds a decimal number to a specific number of digits
Calculates the square root of a number
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
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