Calc Guide

wildcards 69
fixed values 178
focus 23
formatting
chart 84
data labels 92
symbols 92
formatting
autoformatting cells and sheets 59
cell background 59
cell borders 58
conditional 61
themes 60
formatting data
font 56
font effects 56
manual line breaks 54
multiple lines of text 53
numbers 55
shrinking text 54
wrapping 53
Formatting toolbar 12
formula bar 13
formulas
absolute reference 190
breaking into parts 204
calculation examples 180
concatenation operator 188
definition 178
intersection operator 188
operator types 182
operators in 180
range operator 186
relative reference 189
strategies for creating 203
using the Basic editor to create 204
Function List 199
Function Wizard 13, 200
functions
add-in 479
ADDRESS 383
arguments 197, 352, 429
array 468
basic arithmetic 210
CEILING 214
CONCATENATE 184
COUNTIF 216, 377
database 375, 466
date and time 458
date formats 435
definition 178
description 178
entering 180
examples 210
financial analysis 435
FLOOR 214
HLOOKUP 380
INDEX 385
INDIRECT 384
informational 463
logical 462
LOOKUP 381
macros 345
MATCH 381
mathematical 430
MROUND 215
nested 198
OFFSET 384
overview 197
ROUND 213
ROUNDDOWN 214
ROUNDUP 214
simple statistics 211
spreadsheet 470
statistical analysis 449
structure 198
SUBTOTAL 378
SUMIF 377
terminology 429
text 475
VLOOKUP 379
G
Gallery
Hide/Show button 135
opening 134
GETPIVOTDATA 267
Goal Seek 288
graphic filters 138
graphics
adding 130
anchoring 150
arrangement 149
linking 132
positioning 148
resizing 141
transparency 139
graphics mode 138
grid
options 408
grid lines, viewing 402
Index 493