Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting

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 ...