Index

A

ABS (Absolute Values of Numbers) function, 35

absolute addressing, in formulas, 11

Absolute Values of Numbers (ABS) function, 35

Add option, 3

adding thousand separators (FIXED) function, 82

addressing

absolute, 11

relative, 11

alignment, of text, 23–24

AND function, 110–111

annual rate of interest for loans (RATE) function, 69–70

annual rate of interest for savings (RRI) function, 70

ARABIC function, 75

Array option box, 18

ASCII character (CHAR) function, 87

ASCII code (CODE) function, 87–88

Auto-format dialog box, 33

auto-formatting sheets, 32–33

AutoFormat option, 32

AVERAGE (average) function, 51

B

BASE (converting between numeric systems) function, 81–82

C

capital (PPMT) function, 68–69

CEILING (nearest multiple larger than or equal to X) function, 43–44