Calc Guide

functions
add-in 417
ADDRESS 336
arguments 176, 309, 376
array 408
basic arithmetic 187
CEILING 190
CONCATENATE 165
COUNTIF 331
database 330, 407
date and time 401
date formats 381
definition 160
description 160
entering 161
examples 187
financial analysis 381
FLOOR 190
HLOOKUP 334
INDEX 338
INDIRECT 336
informational 405
logical 404
LOOKUP 334
macros 303
MATCH 334
mathematical 376
MROUND 190
nested 177
OFFSET 336
overview 175
ROUND 189
ROUNDDOWN 189
ROUNDUP 189
simple statistics 188
spreadsheet 410
statistical analysis 393
structure 176
SUBTOTAL 332
SUMIF 331
terminology 376
text 414
VLOOKUP 333
G
Gallery
Hide/Show button 122
opening 122
Goal Seek 254
graphic filters 125
graphics
adding 118
anchoring 135
arrangement 134
linking 120
positioning 133
resizing 128
transparency 126
graphics mode 125
grid
options 357
grid lines, viewing 353
guides while moving 353
H
headers and footers 106
Hide/Show button 122
hiding and showing data 61
HTML compatibility 349
hyperlinks
absolute 267
creating 268
Ctrl-click to activate 345
editing 270
relative 267
removing 270
I
illumination of chart 84
image map 136
images
adding 118
context menu 128
cropping 126
embedding 120
inserting from file 118
inserting from the clipboard 121
inserting from the Gallery 121
linking 120
modifying 123
resizing 128
rotating 128
informational functions 405
input settings options 351
insert mode 17
Insert Picture dialog 118
inserting
columns and rows 32
sheets 33
interest rates 381
intersection operator 168
K
keyboard data entry 44
keyboard keys
navigating within spreadsheets 27
keyboard shortcuts
arrow keys 371
assigning 364
cell formatting 373
customizing 364
DataPilot 374
function keys 371
introduction 370
loading from a file 366
430 OpenOffice.org 3.3 Calc Guide