Deleting a Table Style

When you delete a table style that’s used in a spreadsheet, you need to choose a

different style to replace it.

**To delete a style:**

** **

**1**

Click the arrow to the right of the style in the Styles pane.

** **

**2**

Choose Delete Style.

** **

**3**

If the style you want to delete is being used in the current spreadsheet, choose a style

to replace it and then click OK.

** **

**118**

This chapter explains how to perform calculations in table

cells by using formulas.

The Elements of Formulas

A formula performs a calculation and displays the result in the cell where you place

the formula. A cell containing a formula is referred to as a *formula cell*.

For example, in the bottom cell of a column you can insert a formula that sums the

numbers in all the cells above it. If any of the values in the cells above the formula cell

change, the sum displayed in the formula cell updates automatically.

A formula performs calculations using specific values you provide. The values can

be numbers or text (*constants*) you type into the formula. Or they can be values that

reside in table cells you identify in the formula by using *cell references*. Formulas use

operators and functions to perform calculations using the values you provide:

Â

*Operators *are symbols that initiate operations, such as arithmetic and comparison

operations. You use the symbols in formulas to indicate the operation you want to

use. For example, the symbol + adds values, and the symbol = compares two values

to determine whether they’re equal.**=A2 + 16: **A formula that uses an operator to add two values.**=: **Always precedes a formula.**A2: **A cell reference. A2 refers to the second cell in the first column.**+: **An arithmetic operator that adds the value that precedes it with the value that

follows it.**16: **A numeric constant.

Â

*Functions *are predefined, named operations, such as SUM and AVERAGE. To use a

function, you enter its name and, in parentheses following the name, you provide

the arguments the function needs. *Arguments* specify the values the function uses

when it performs its operations.

**6**