Apple Numbers '08 - Manual (Page 294)

294 Index
ROWS lookup function 270
ruler
showing and hiding 134
using to change a tab stop 135
using to delete a tab stop 135
using to set a new tab stop 135
using to set paragraph indents 136
S
saving
as a template 35
a spreadsheet 34
automatic backup version 35
copy of spreadsheet 36
Spotlight 36
undoing changes made since 35
with template images 34
scatter chart
formatting symbols 117
specifying axis settings 117
searching for text 148
SEARCH text function 270
SECOND date/time function 271
shapes
adding custom 164
adding predrawn 164
cropping using the default (rectangular)
mask 172
editing predrawn 168
formatting text in 143
making editable 165
manipulating points 166
reshaping a curve 166
reshaping a straight segment 167
transforming corner points into curved points
and vice versa 167
using as masks 173
using the Draw tool 164
sheets
adding and deleting 38
printing 183
renaming 39
reorganizing 38
showing and hiding tables and charts 37
using to organize a spreadsheet 37
viewing 37
viewing the contents of 37
shortcut menus 24, 30
SIGN mathematical function 271
SINH trigonometric function 272
SIN trigonometric function 271
SLN financial function 272
SLOPE statistical function 273
SMALL statistical function 273
smart quotes 128
sound file types supported 177
special characters and symbols
inserting 128
spelling check
finding misspelled words 146
working with spelling suggestions 147
spreadsheet
choosing a template 31
creating 31
opening existing 33
setting margins 43
setting page orientation 42
setting page size 40
SQRT mathematical function 274
star shape
adding 164
editing 169
statistical functions 202
STDEVA statistical function 275
STDEVPA statistical function 276
STDEVP statistical function 275
STDEV statistical function 274
SUBSTITUTE text function 277
SUMIF mathematical function 278
SUM mathematical function 277
SUMPRODUCT mathematical function 278
SUMSQ mathematical function 279
SYD financial function 279
T
table cells
adding and editing content 54
adding checkboxes and other controls 65
adding comments to 76
adding images 68
autofilling 68
defining rules 67
enlarging so content fits 57
filtering rows 78
formatting borders 75
formatting numbers 59
merging adjacent cells into one 74
monitoring cell values with rules 67
resizing 57
selecting 51
selecting a group of cells 52
selecting borders 53
sorting 77
splitting into equal parts 74
using checkboxes and other controls 65
working with dates 57
working with numbers 56
working with text 55