Apple AppleWorks 5 : Mac OS Uživatelský manuál Strana 151
- Strana / 293
- Tabulka s obsahem
- KNIHY
Hodnocené. / 5. Na základě hodnocení zákazníků
Spreadsheet 7-5
As you work with spreadsheet frames, keep the following points in mind:
1 You can’t change or open any type of frame in a paint document. See
“Adding text and spreadsheets” on page 6-14 for more information.
1 You can link two or more spreadsheet frames in a document. See
“Linking frames” on page 9-29.
Typing in a spreadsheet
Each cell in a spreadsheet can contain numbers, words, or formulas.
To enter a negative number, begin the number with a minus sign (–).
To enter a formula or function, begin the entry with an equal sign (=). See
“Working with formulas” on page 7-21 and “Examples: Entering formulas”
on page 7-25 for more information.
Note You can also print, or merge, database information on a spreadsheet.
For more information on merging documents and printing them, see
“Merging data into documents (mail merge)” on page 9-22.
Selecting cells and ranges
You must select a cell or cell range (group of adjacent cells) before you can
change, format, or work with data.
*
Choose Index from the or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
In the Help index,* see:
E entering spreadsheet data
E spreadsheets, documents
Click to
confirm the entry
or to cancel
To type numbers or words
in a cell, click a cell and
begin typing
What you type
appears in the
entry bar
The entry
appears in
the cell
In the Help index,* see:
E Go To Cell command
E selecting cells
- AppleWorks 5 1
- User’s Manual 1
- Apple Computer, Inc 2
- Contents 3
- Chapter 3: Basics 4
- Chapter 5: Drawing 6
- Chapter 6: Painting 7
- Chapter 7: Spreadsheet 7
- Chapter 8: Database 9
- Chapter 9: Beyond the basics 10
- Chapter 10: Communications 11
- AppleWorks 5 User’s Manual 12
- Chapter 1: Introduction 13
- If Do this 14
- Using AppleWorks Help 15
- Getting additional help 18
- Working with AppleWorks 18
- What’s a document? 19
- Document types 19
- Draw documents 21
- Paint documents 22
- Spreadsheet documents 23
- Database documents 24
- Where to go from here 25
- Starting AppleWorks 27
- Creating a document 28
- Creating a blank document 29
- E New command 29
- Using an Assistant 30
- E Assistants 30
- Select an 31
- Assistant 31
- Assistant for creating tables 31
- This Assistant Helps you to 32
- Using stationery 33
- Saving a document 34
- Opening a document 36
- Finding documents 37
- Linking to other documents 38
- 3. Click OK 39
- 4. Click Save 40
- Opening stationery 41
- Identifying your documents 42
- Converting documents 45
- Close All from the File menu 46
- Chapter 3: Basics 49
- Viewing windows 50
- E viewing documents 50
- Page indicator 51
- Using the tool panel 52
- Using the button bar 53
- Customizing the button bar 54
- Adding and removing buttons 55
- Creating your own button bar 55
- E buttons 55
- Using palettes 56
- Working with frames 57
- Cutting, copying, and pasting 58
- Basics 3-11 59
- Previewing pages for printing 60
- E pages, viewing 60
- E Show Margins command 60
- Using rulers 61
- Basics 3-15 63
- To insert Do this Example 64
- Setting margins 65
- Using libraries 66
- E libraries, creating 67
- E libraries, opening 67
- Edit menu, choose 68
- Setting preferences 69
- E WorldScript 70
- 1 compose letters and memos 71
- 1 create lists and outlines 71
- 1 keep a personal journal 71
- Text basics 72
- Typing text 74
- E deleting, text 74
- E text, shortcuts 74
- E undoing actions 74
- Selected text 75
- Changing text appearance 77
- Changing paragraph formats 78
- Setting and changing tabs 80
- E tabbing 80
- Aligning paragraph text 82
- E text, alignment 82
- E paragraphs 83
- Sorting paragraphs 84
- Outlining 84
- Text (word processing) 4-15 85
- Creating an outline 86
- E topics, outlines 86
- Rearranging outline topics 87
- E topics 87
- E collapsing 88
- Creating tables 89
- Working with pages 90
- Text formatted in columns 91
- Click to add columns 92
- Click to subtract columns 92
- Shows the number of columns 92
- E sections 94
- Adding footnotes and endnotes 98
- Finding and changing text 99
- Using writing tools 100
- Hyphenating words 101
- E Auto-Hyphenate command 101
- E artwork, text 104
- E drawing, tools 104
- E libraries, overview 104
- Wrapping text around pictures 105
- E text wrap 105
- E book marks 106
- Chapter 5: Drawing 107
- A draw document 108
- Circle drawn in a 108
- What are objects? 109
- Using the drawing tools 109
- E objects, creating 109
- E selecting objects 110
- Drawing 5-5 111
- E autogrid 113
- E graphics, grid 113
- E rulers 113
- Type here 114
- E objects, modifying 115
- E styles 117
- Resizing objects 118
- E resizing, objects 118
- E reshaping 119
- Connecting objects 120
- Arranging objects 121
- E locking 122
- Creating a master page 123
- Adding clip art 125
- In the Help index,* see: 126
- Chapter 6: Painting 129
- Painting basics 130
- About the paint window 131
- Working with paint frames 131
- E frames, working in 131
- E paint frames 131
- Working with images 132
- To Do this 133
- E Paint Mode command 135
- Selecting and moving images 136
- E images, arranging 136
- E editing, images 137
- Transforming a selection 138
- Coloring and tinting images 140
- E transforming 140
- Combining images 141
- Adding text and spreadsheets 142
- Working with large files 144
- Chapter 7: Spreadsheet 147
- Spreadsheet basics 148
- A spreadsheet document 149
- A spreadsheet frame in a 149
- Modifying cell data 152
- Moving data 153
- E entering spreadsheet data 153
- Copying and deleting data 154
- Filling a range of cells 154
- To Do this Example 156
- Sorting cell data 157
- E sorting spreadsheet data 157
- =Shares*Price 158
- February 159
- Using named cells in formulas 160
- E formulas, spreadsheet 160
- E named cells and ranges 160
- Spreadsheet 7-15 161
- E hiding 163
- E resizing, spreadsheet cells 163
- Changing the display 166
- Working with formulas 167
- Cell references in formulas 168
- Entering formulas 169
- E arithmetic operators 169
- E spreadsheets, calculations 169
- Calculating formula results 170
- E Help, printing 170
- E Auto Calc command 170
- Before After 171
- Error messages 171
- Working with functions 172
- Entering functions 173
- E functions 173
- E charts, modifying 177
- E charts, creating 179
- E charts, formatting 179
- E frames, creating 180
- E libraries, using 180
- Chapter 8: Database 183
- Creating a database document 185
- E documents, creating 185
- Part 2: Define two fields 186
- Part 4: Make new records 187
- Designing a database 188
- Defining database fields 189
- E fields, defining 189
- Assigning field types 190
- E fields, types 190
- Database 8-9 191
- E formulas, database 193
- E Define Fields command 194
- Entering data in fields 195
- Moving through records 198
- Viewing records 199
- Selecting rows and columns 200
- E List mode 200
- Resizing rows and columns 201
- Selecting and hiding records 203
- Sorting records 204
- Database 8-23 205
- Finding information 206
- E New Request command 207
- E operators 207
- Matching records 209
- E matching records 209
- Working with layouts 210
- Database 8-29 211
- New Layout command 212
- E layouts, mailing labels 213
- Editing a layout 214
- E fields, arranging 214
- E layouts, editing 214
- E editing, text 216
- E fields, formatting 216
- Database 8-35 217
- E layouts, parts for 218
- E summaries, database 218
- To In Layout mode, do this 219
- Creating reports 220
- Database 8-39 221
- Printing a database document 222
- Database 8-41 223
- Chapter 9: Beyond the basics 225
- Beyond the basics 9-3 227
- Using styles 229
- About the stylesheet palette 230
- Beyond the basics 9-7 231
- Applying a style 233
- E styles, using 233
- Turning off a style 235
- E styles, editing 235
- Beyond the basics 9-13 237
- Editing styles 239
- Creating a slide presentation 242
- Setting up slides 243
- E slide shows, options 243
- 244
- The pointer 245
- 5. Click OK 246
- Beyond the basics 9-23 247
- Printing the merge documents 249
- E merging data 249
- E FileMaker Pro 250
- Addressing envelopes 251
- E envelopes 252
- E stationery, using 252
- Linking frames 253
- Linked spreadsheet frames 254
- Continue indicator 254
- Linked paint frames 254
- Working with movies 255
- Playing a movie 256
- Editing a movie 256
- E movies, in documents 256
- E button bars 257
- Using macros 258
- E AppleScript 259
- Chapter 10: Communications 261
- Term Definition 262
- Communications 10-3 263
- Communications 10-5 265
- To Choose 267
- Terminal settings Terminal 269
- E Internet 271
- About browsers 272
- Creating a Web page 273
- Web pages, creating 274
- Web pages, graphics for 275
- Linking Web pages 276
- E Web pages, links to 276
- Type a name for the 278
- Web pages, saving 279
- Working with electronic mail 280
Související produkty a manuály pro Software Apple AppleWorks 5 : Mac OS
Software Apple iMovie '08 Uživatelský manuál
(51 stránky)
(51 stránky)
Software Apple GarageBand '09 Uživatelský manuál
(124 stránky)
(124 stránky)
Software Apple Xsan 1.4 Uživatelský manuál
(206 stránky)
(206 stránky)
Software Apple Xserve Uživatelský manuál
(92 stránky)
(92 stránky)
Software Apple Aperture 2 Uživatelský manuál
(753 stránky)
(753 stránky)
Software Apple iPhoto '08 Uživatelský manuál
(22 stránky)
(22 stránky)
Software Apple GarageBand 2.0 Uživatelský manuál
(77 stránky)
(77 stránky)
Software Apple Server Diagnostics Uživatelský manuál
(61 stránky)
(61 stránky)
Software Apple iWeb '08 Uživatelský manuál
(26 stránky)
(26 stránky)
Software Apple AppleShare IP 6.3 Uživatelský manuál
(46 stránky)
(46 stránky)
Software Apple Server Diagnostics Uživatelský manuál
(67 stránky)
(67 stránky)
Software Apple Logic Express 7 Uživatelský manuál
(776 stránky)
(776 stránky)
Software Apple Numbers '09 Uživatelský manuál
(93 stránky)
(93 stránky)
© 2020, manymanuals.cz. Všechna práva vyhrazena. | 0.042 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce