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