Manuais de utilizador para Apple numbers

índice analítico

• Contents

  3
• Welcome to the NumbersUser’sGuide

  16
• Numbers Tools and Techniques

  18
  • Spreadsheet Templates

    18
  • The Numbers Window

    20
  • Spreadsheet Viewing Aids

    21
    • Zooming In or Out

      21
    • The Sheets Pane

      21
    • Print View

      22
    • Alignment Guides

      22
  • The Styles Pane

    23
  • The Toolbar

    24
  • The Format Bar

    25
  • The Inspector Window

    25
  • Formula Tools

    26
  • The Media Browser

    28
  • The Colors Window

    28
  • The Font Panel

    29
  • The Warnings Window

    29
  • Keyboard Shortcuts and Shortcut Menus

    30
• Working with a Numbers Spreadsheet

  31
  • Creating, Opening, and Importing Spreadsheets

    31
    • Creating a New Spreadsheet

      31
    • Importing a Document

      33
    • Opening an Existing Spreadsheet

      33
  • Saving Spreadsheets

    34
    • Saving a Spreadsheet

      34
    • Undoing Changes

      35
    • Automatically Saving a Backup Version of a Spreadsheet

      35
    • Saving a Spreadsheet as a Template

      35
    • Saving Search Terms for a Spreadsheet

      36
    • Saving a Copy of a Spreadsheet

      36
    • Closing a Spreadsheet Without Quitting Numbers

      36
  • Using Sheets to Organize a Spreadsheet

    37
    • Viewing Sheets

      37
    • Adding and Deleting Sheets

      38
    • Reorganizing Sheets and Their Contents

      38
    • Changing Sheet Names

      39
  • Dividing a Sheet into Pages

    39
    • Setting a Spreadsheet’s Page Size

      40
    • Using Headers and Footers

      41
    • Arranging Objects on a Page

      41
    • Setting Page Orientation

      42
    • Setting Pagination Order

      42
    • Numbering Pages

      42
    • Setting Page Margins

      43
• Using Tables

  44
  • About Tables

    44
  • Working with Tables

    45
    • Adding a Table

      45
    • Using Table Tools

      45
    • Resizing a Table

      48
    • Moving Tables

      48
    • Naming Tables

      49
    • Defining Reusable Tables

      49
    • Copying Tables Among iWork Applications

      50
  • Selecting Tables and Their Components

    51
    • Selecting a Table

      51
    • Selecting a Table Cell

      51
    • Selecting a Group of Table Cells

      52
    • Selecting a Row or Column

      52
    • Selecting Table Cell Borders

      53
  • Working with Content in Table Cells

    54
    • Adding and Editing Cell Values

      54
    • Working with Text in Cells

      55
    • Working with Numbers in Cells

      56
    • Working with Dates in Cells

      57
    • Displaying Content Too Large for Its Cell

      57
    • Formatting Cell Values

      58
      • Using the Number Format

        59
      • Using the Currency Format

        60
      • Using the Percentage Format

        61
      • Using the Date and Time Format

        62
      • Using the Fraction Format

        63
      • Using the Scientific Format

        63
      • Using the Text Format

        64
      • Using a Checkbox and Other Control Formats

        65
    • Monitoring Cell Values

      67
    • Adding Images or Color to Cells

      68
    • Autofilling Table Cells

      68
  • Working with Rows and Columns

    69
    • Adding Rows

      69
    • Adding Columns

      70
    • Rearranging Rows and Columns

      70
    • Deleting Table Rows and Columns

      70
    • Using a Table Header Row or Column

      71
    • Using a Footer Row

      72
    • Hiding Rows and Columns

      72
    • Resizing Table Rows and Columns

      73
    • Alternating Row Colors

      73
  • Working with Table Cells

    74
    • Merging Table Cells

      74
    • Splitting Table Cells

      74
    • Formatting Table Cell Borders

      75
    • Copying and Moving Cells

      76
    • Adding Comments

      76
  • Reorganizing Tables

    77
    • Sorting Table Cells

      77
    • Filtering Rows

      78
• Working with Table Styles

  79
  • Using Table Styles

    79
  • Applying Table Styles

    80
  • Modifying a Table’s Style

    80
    • Modifying Table Style Attributes

      80
    • Copying and Pasting Table Styles

      81
  • Using the Default Table Style

    81
  • Creating New Table Styles

    82
  • Renaming a Table Style

    82
  • Deleting a Table Style

    82
• Using Formulas and Functions in Tables

  83
  • Using Formulas

    83
    • A Tour of Using Formulas

      84
    • Performing Instant Calculations

      86
    • Adding a Quick Formula

      87
      • Performing a Basic Calculation Using Column Values

        87
      • Performing a Basic Calculation Using Row Values

        88
    • Removing a Formula

      88
    • Using the Formula Editor

      88
      • Adding a New Formula with the Formula Editor

        89
      • Editing a Formula with the Formula Editor

        89
    • Using the Formula Bar

      90
      • Adding a New Formula with the Formula Bar

        90
      • Editing a Formula with the Formula Bar

        91
    • Using Cell References

      91
      • Adding Cell References to a Formula

        91
      • Copying or Moving Formulas with Cell References

        92
    • Applying a Formula Once to Cells in a Column or Row

      93
    • Handling Errors and Warnings

      93
  • Using Operators

    94
    • Performing Arithmetic Operations

      94
    • Understanding the Arithmetic Operators

      95
    • Understanding the Comparison Operators

      96
  • Using Functions

    96
• Using Charts

  98
  • About Charts

    98
  • Adding a Chart

    101
  • Editing Charts

    102
    • Changing the Plotting Orientation

      103
    • Changing the Data Plotted in a Chart

      103
      • Adding Data to a Chart

        103
      • Adding Data to a Chart from Multiple Tables

        104
      • Removing Data from a Chart

        104
      • Replacing a Data Series

        105
    • Deleting a Chart

      105
    • Moving a Chart

      105
    • Changing a Chart from One Type to Another

      105
  • Formatting General Chart Attributes

    106
    • Using a Legend

      106
    • Using a Chart Title

      107
    • Resizing a Chart

      107
    • Rotating Charts

      107
    • Adding Labels and Axis Markings

      108
      • Showing Axes and Borders

        108
      • Using Axis Titles

        109
      • Showing Data Point Labels

        109
      • Formatting the Value Axis

        110
      • Placing Labels, Gridlines, and Tick Marks

        110
    • Formatting the Elements in a Data Series

      112
    • Formatting Titles, Labels, and Legends

      112
    • Adding Descriptive Text to a Chart

      113
  • Formatting Specific Types of Charts

    113
    • Pie Charts

      113
      • Selecting Individual Pie Wedges

        113
      • Showing Series Names in a Pie Chart

        114
      • Separating Individual Pie Wedges

        114
      • Adding Shadows to Pie Charts and Wedges

        114
      • Adjusting the Opacity of Pie Charts

        115
      • Rotating 2D Pie Charts

        115
    • Bar and Column Charts

      115
      • Adjusting Spacing of Bar and Column Charts

        115
      • Adding Shadows to Bar and Column Charts

        116
      • Adjusting the Opacity of Bar and Column Charts

        116
    • Area Charts and Line Charts

      116
    • Scatter Charts

      117
    • 3D Charts

      118
• Working with Text

  119
  • Adding Text

    119
  • Deleting, Copying, and Pasting Text

    119
  • Selecting Text

    120
  • Formatting Text Size and Appearance

    120
    • Using the Format Bar to Format Text

      121
    • Using the Format Menu to Format Text

      121
      • Making Text Bold or Italic Using the Menus

        121
      • Creating Outlined Text Using the Menus

        121
      • Underlining Text Using the Menus

        122
      • Changing Text Size Using the Menus

        122
      • Making Text Subscript or Superscript Using the Menus

        122
      • Changing Text Capitalization Using the Menus

        123
    • Using the Font Panel to Format Text

      123
      • Making the Font Panel Easy to Use

        124
      • Changing Fonts Using the Font Panel

        124
      • Changing Underlining Using the Font Panel

        125
      • Adding a Strikethrough to Text Using the Font Panel

        125
      • Changing Text Color Using the Font Panel

        125
      • Changing the Paragraph Background Color Using the Font Panel

        126
      • Creating Shadows on Text Using the Font Panel

        126
    • Adding Accents and Special Characters

      126
      • Adding Accent Marks

        126
      • Viewing Keyboard Layouts for Other Languages

        127
      • Typing Special Characters and Symbols

        128
      • Using Smart Quotes

        128
    • Using Advanced Typography Features

      129
  • Adjusting Font Smoothing

    129
  • Setting Text Alignment, Spacing, and Color

    130
    • Aligning Text Horizontally

      131
    • Aligning Text Vertically

      131
    • Adjusting the Spacing Between Lines of Text

      132
    • Adjusting the Spacing Before or After a Paragraph

      133
    • Adjusting the Spacing Between Characters

      133
    • Changing Text Color

      133
  • Setting Tab Stops to Align Text

    134
    • Setting a New Tab Stop

      135
    • Changing a Tab Stop

      135
    • Deleting a Tab Stop

      135
  • Setting Indents

    136
    • Setting Indents for Paragraphs

      136
    • Changing the Inset Margin of Text in Objects

      136
    • Setting Indents for Lists

      137
  • Using Bulleted, Numbered, and Ordered Lists (Outlines)

    137
    • Generating Lists Automatically

      137
    • Using Bulleted Lists

      138
    • Using Numbered Lists

      139
    • Using Ordered Lists (Outlines)

      140
  • Using Text Boxes and Shapes to Highlight Text

    141
    • Adding Text Boxes

      141
    • Presenting Text in Columns

      141
    • Putting Text Inside a Shape

      142
    • Formatting a Text Box or Shape

      143
  • Using Hyperlinks

    143
    • Linking to a Webpage

      143
    • Linking to a Preaddressed Email Message

      144
    • Editing Hyperlink Text

      144
  • Inserting Page Numbers and Other Changeable Values

    145
  • Automatically Substituting Text

    145
  • Inserting a Nonbreaking Space

    146
  • Checking for Spelling Mistakes

    146
    • Finding Misspelled Words

      146
    • Working with Spelling Suggestions

      147
  • Finding and Replacing Text

    148
• Working with Shapes, Graphics, andOther Objects

  149
  • Selecting Objects

    149
  • Copying or Duplicating Objects

    150
  • Deleting Objects

    150
  • Moving Objects

    150
    • Moving an Object Forward or Backward

      151
    • Aligning Objects

      151
      • Aligning Objects Relative to Each Other

        151
      • Spacing Objects Evenly on a Page

        152
      • Using Alignment Guides

        152
      • Creating New Alignment Guides

        153
      • Setting Precise Positions of Objects

        153
  • Modifying Objects

    154
    • Resizing Objects

      154
    • Flipping and Rotating Objects

      154
    • Changing the Style of Borders

      155
    • Framing Objects

      156
    • Adding Shadows

      156
    • Adding a Reflection

      158
    • Adjusting Opacity

      158
  • Grouping and Locking Objects

    159
    • Grouping and Ungrouping Objects

      159
    • Locking and Unlocking Objects

      160
  • Filling Objects

    160
    • Filling an Object with Color

      160
    • Using the Colors Window

      161
    • Filling an Object with an Image

      162
  • Using Shapes

    164
    • Adding a Predrawn Shape

      164
    • Adding a Custom Shape

      164
    • Making Shapes Editable

      165
    • Manipulating Points of a Shape

      166
    • Reshaping a Curve

      166
    • Reshaping a Straight Segment

      167
    • Transforming Corner Points into Curved Points and Vice Versa

      167
    • Editing Specific Predrawn Shapes

      168
      • Editing a Rounded Rectangle

        168
      • Editing Single and Double Arrows

        168
      • Editing a Star

        169
      • Editing a Polygon

        169
  • Using Media Placeholders

    170
  • Working with Images

    171
    • Importing an Image

      171
    • Masking (Cropping) Images

      172
      • Cropping an Image Using the Default (Rectangular) Mask

        172
      • Masking an Image with a Shape

        173
      • Unmasking an Image

        173
    • Removing the Background or Unwanted Elements from an Image

      173
    • Changing an Image’s Brightness, Contrast, and Other Settings

      174
    • Using PDF Files as Graphics

      176
  • Using Sound and Movies

    177
    • Adding a Sound File

      177
    • Adding a Movie File

      177
    • Adjusting Media Playback Settings

      178
• Adding Address Book Data toaTable

  179
  • Using Address Book Fields

    179
  • Mapping Column Names to Address Book Field Names

    180
  • Adding Address Book Data to an Existing Table

    182
  • Adding Address Book Data to a New Table

    182
• Sharing Your Numbers Spreadsheet

  183
  • Printing a Sheet

    183
    • Choosing Printer Layout Options

      184
    • Adjusting the Printed Color with ColorSync

      185
  • Exporting to Other Document Formats

    186
  • Sending a Spreadsheet to iWeb

    187
• Designing Your Own Numbers Spreadsheet Templates

  188
  • Designing a Template

    188
  • Step 1:Define Table Styles

    188
  • Step 2:Define Reusable Tables

    189
  • Step 3:Define Default Charts, Text Boxes, Shapes, and Images

    189
    • Defining Default Attributes for Charts

      189
    • Defining Default Attributes for Text Boxes and Shapes

      190
    • Defining Default Attributes for Imported Images

      190
  • Step 4:Create Initial Spreadsheet Content

    191
    • Predefining Tables and Other Objects for a Custom Template

      191
    • Creating Media Placeholders for a Custom Template

      191
    • Predefining Sheets for a Custom Template

      192
  • Step 5:Save a Custom Template

    192
• Dictionary of Functions

  193
  • About Functions

    193
  • Date and Time Functions

    195
  • Financial Functions

    196
  • Logical Functions

    198
  • Information Functions

    198
  • Reference Functions

    199
  • Numeric Functions

    200
  • Trigonometric Functions

    201
  • Statistical Functions

    202
  • Text Functions

    204
  • Function Descriptions

    205
    • ABS

      205
    • ACCRINT

      205
    • ACCRINTM

      206
    • ACOS

      206
    • ACOSH

      207
    • ADDRESS

      207
    • AND

      208
    • AREAS

      208
    • ASIN

      209
    • ASINH

      209
    • ATAN

      209
    • ATAN2

      210
    • ATANH

      210
    • AVEDEV

      210
    • AVERAGE

      211
    • AVERAGEA

      211
    • CEILING

      212
    • CHAR

      212
    • CHOOSE

      213
    • CLEAN

      213
    • CODE

      214
    • COLUMN

      214
    • COLUMNS

      215
    • COMBIN

      215
    • CONCATENATE

      216
    • CONFIDENCE

      216
    • CORREL

      217
    • COS

      217
    • COSH

      218
    • COUNT

      218
    • COUNTA

      219
    • COUNTBLANK

      220
    • COUNTIF

      220
    • COUPDAYBS

      221
    • COUPDAYS

      221
    • COUPDAYSNC

      222
    • COUPNUM

      223
    • COVAR

      224
    • DATE

      224
    • DATEDIF

      225
    • DAY

      226
    • DB

      226
    • DDB

      227
    • DEGREES

      227
    • DISC

      228
    • DOLLAR

      228
    • EDATE

      229
    • EVEN

      229
    • EXACT

      230
    • EXP

      230
    • FACT

      230
    • FALSE

      231
    • FIND

      231
    • FIXED

      232
    • FLOOR

      232
    • FORECAST

      233
    • FV

      233
    • GCD

      234
    • HLOOKUP

      234
    • HOUR

      235
    • HYPERLINK

      236
    • IF

      236
    • INDEX

      237
    • INDIRECT

      237
    • INT

      238
    • INTERCEPT

      238
    • IPMT

      239
    • IRR

      240
    • ISBLANK

      240
    • ISERROR

      241
    • ISEVEN

      241
    • ISODD

      241
    • ISPMT

      242
    • LARGE

      242
    • LCM

      243
    • LEFT

      244
    • LEN

      244
    • LN

      244
    • LOG

      245
    • LOG10

      245
    • LOOKUP

      245
    • LOWER

      246
    • MATCH

      246
    • MAX

      247
    • MAXA

      248
    • MEDIAN

      248
    • MID

      248
    • MIN

      249
    • MINA

      249
    • MINUTE

      250
    • MIRR

      250
    • MOD

      250
    • MODE

      251
    • MONTH

      251
    • MROUND

      252
    • NOT

      252
    • NOW

      253
    • NPER

      253
    • NPV

      254
    • ODD

      254
    • OFFSET

      255
    • OR

      255
    • PERCENTILE

      256
    • PI

      256
    • PMT

      257
    • POISSON

      257
    • POWER

      258
    • PPMT

      258
    • PRICE

      259
    • PRICEDISC

      260
    • PRICEMAT

      260
    • PROB

      261
    • PRODUCT

      262
    • PROPER

      262
    • PV

      262
    • QUOTIENT

      263
    • RADIANS

      263
    • RAND

      264
    • RANDBETWEEN

      264
    • RANK

      264
    • RATE

      265
    • REPLACE

      266
    • REPT

      266
    • RIGHT

      267
    • ROMAN

      267
    • ROUND

      268
    • ROUNDDOWN

      268
    • ROUNDUP

      269
    • ROW

      270
    • ROWS

      270
    • SEARCH

      270
    • SECOND

      271
    • SIGN

      271
    • SIN

      271
    • SINH

      272
    • SLN

      272
    • SLOPE

      273
    • SMALL

      273
    • SQRT

      274
    • STDEV

      274
    • STDEVA

      275
    • STDEVP

      275
    • STDEVPA

      276
    • SUBSTITUTE

      277
    • SUM

      277
    • SUMIF

      278
    • SUMPRODUCT

      278
    • SUMSQ

      279
    • SYD

      279
    • T

      280
    • TAN

      280
    • TANH

      281
    • TIME

      281
    • TIMEVALUE

      282
    • TODAY

      282
    • TRIM

      283
    • TRUE

      283
    • TRUNC

      283
    • UPPER

      284
    • VALUE

      284
    • VAR

      284
    • VARA

      285
    • VARP

      286
    • VARPA

      286
    • VDB

      287
    • VLOOKUP

      288
    • WEEKDAY

      289
    • YEAR

      289
• Index

  290
  • A

    290
  • B

    290
  • C

    290
  • D

    291
  • E

    291
  • F

    291
  • G

    291
  • H

    291
  • I

    292
  • K

    292
  • L

    292
  • M

    292
  • N

    292
  • O

    293
  • P

    293
  • Q

    293
  • R

    293
  • S

    294
  • T

    294
  • U

    295
  • V

    295
  • W

    295
  • Y

    295
  • Z

    295