Apple numbers User Manual

Apple

Inde

x

290

Index

3D charts

defining scene settings 118
modifying the viewing angle 118

A

ABS mathematical function 205
ACCRINT financial function 205
ACCRINTM financial function 206
ACOSH trigonometric function 207
ACOS trigonometric function 206
Address Book

adding contact data to a new table 182
adding contact data to an existing table 182
fields supported 180

ADDRESS lookup function 207
Adjust Image window 174
alignment guides

creating new 153
using 152

AND logical function 208
area and line charts

adding shadows 117
formatting symbols 117
setting line color 117

AREAS lookup function 208
arrows, predrawn

adding 164
editing 168

ASINH trigonometric function 209
ASIN trigonometric function 209
ATAN2 trigonometric function 210
ATANH trigonometric function 210
ATAN trigonometric function 209
AVEDEV statistical function 210
AVERAGEA statistical function 211
AVERAGE statistical function 211

B

bar and column charts

adding shadows 116
adjusting opacity 116

adjusting spacing 115

bulleted text

adding new 138
rearranging and editing 138

C

CEILING mathematical function 212
Character Palette 128
characters in other languages 127
CHAR text function 212
charts

adding 101
adding data from multiple tables 104
adding descriptive text 113
adding labels and axis markings 108
changing chart type 105
changing plotting orientation 103
choosing chart type 102
copying data into 103
editing data 103
formatting 106, 113
formatting data series elements 112
formatting the value axis 110
formatting titles, labels, and legends 112
placing grid labels and tick marks 110
replacing a data series 105
repositioning a legend 106
resizing 107
rotating 107
showing and hiding a legend 106
showing axes and borders 108
understanding data series 99

CHOOSE lookup function 213
CLEAN text function 213
closing a spreadsheet 36
CODE text function 214
Colors window 161
COLUMN lookup function 214
COLUMNS lookup function 215
COMBIN mathematical function 215
CONCATENATE text function 216