Apple Numbers '08 Instrukcja Użytkownika Strona 289
- Strona / 295
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
Chapter 12 Dictionary of Functions 289
WEEKDAY
The WEEKDAY function converts a date to a number that represents the day of the
week using one of three numbering schemes.
WEEKDAY(date-time, [number-scheme])
 date-time: A date in any of the accepted date formats or a reference to a cell
containing such a date.
 number-scheme: Optional; a single digit that specifies how days are numbered:
1 or omitted counts Sunday = day 1, Saturday = day 7.
2 counts Monday = 1 through Sunday = 7.
3 counts Monday = 0 through Sunday = 6.
YEAR
The YEAR function extracts the year number from a date.
YEAR(date-time)
 date-time: A date or a reference to a cell containing a date.
Examples
WEEKDAY("Apr 6, 1988", 1) returns 4 (Wednesday, the fourth day if you start counting Sunday as day
1).
WEEKDAY("Apr 6, 1988") returns the same value as the preceding example (numbering scheme 1 is
used if no number-scheme argument is specified).
WEEKDAY("Apr 6, 1988”, 2) returns 3 (Wednesday, the third day if you start counting Monday as day 1).
WEEKDAY("Apr 6, 1988”, 3) returns 2 (Wednesday, day number 2 if you start counting Monday as day
0).
Examples
YEAR("April 6, 1988") returns 1988.
YEAR(NOW()) returns 2006 when evaluated on June 4, 2006.
- Numbers ’08 1
- User’s Guide 1
- Contents 3
- Contents 7 7
- 8 Contents 8
- Contents 9 9
- 10 Contents 10
- Contents 11 11
- 12 Contents 12
- Contents 13 13
- 14 Contents 14
- Contents 15 15
- Welcome to the 16
- Numbers User’s Guide 16
- Numbers Tools and Techniques 18
- The Numbers Window 20
- Spreadsheet Viewing Aids 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
- Click to open the 27
- Function Browser 27
- The Media Browser 28
- The Colors Window 28
- The Font Panel 29
- The Warnings Window 29
- Working with a Numbers 31
- Importing a Document 33
- Saving Spreadsheets 34
- Undoing Changes 35
- Viewing Sheets 37
- Adding and Deleting Sheets 38
- Dividing a Sheet into Pages 39
- 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
- Working with Tables 45
- 46 Chapter 3 Using Tables 46
- Chapter 3 Using Tables 47 47
- Resizing a Table 48
- Moving Tables 48
- Naming Tables 49
- Defining Reusable Tables 49
- 50 Chapter 3 Using Tables 50
- Selecting a Table 51
- Selecting a Table Cell 51
- Selecting a Row or Column 52
- Selecting Table Cell Borders 53
- 54 Chapter 3 Using Tables 54
- Working with Text in Cells 55
- Working with Numbers in Cells 56
- Working with Dates in Cells 57
- Formatting Cell Values 58
- Chapter 3 Using Tables 59 59
- 60 Chapter 3 Using Tables 60
- Chapter 3 Using Tables 61 61
- 62 Chapter 3 Using Tables 62
- Chapter 3 Using Tables 63 63
- 64 Chapter 3 Using Tables 64
- Chapter 3 Using Tables 65 65
- 66 Chapter 3 Using Tables 66
- Monitoring Cell Values 67
- Autofilling Table Cells 68
- Working with Rows and Columns 69
- Adding Columns 70
- Rearranging Rows and Columns 70
- Chapter 3 Using Tables 71 71
- Using a Footer Row 72
- Hiding Rows and Columns 72
- Alternating Row Colors 73
- Working with Table Cells 74
- Formatting Table Cell Borders 75
- Copying and Moving Cells 76
- Adding Comments 76
- Reorganizing Tables 77
- Filtering Rows 78
- Working with Table Styles 79
- Applying Table Styles 80
- Modifying a Table’s Style 80
- Using the Default Table Style 81
- Creating New Table Styles 82
- Renaming a Table Style 82
- Deleting a Table Style 82
- Using Formulas 83
- A Tour of Using Formulas 84
- Adding a Quick Formula 87
- Removing a Formula 88
- Using the Formula Editor 88
- Using the Formula Bar 90
- Using Cell References 91
- Handling Errors and Warnings 93
- Using Operators 94
- Using Functions 96
- Using Charts 98
- Chapter 6 Using Charts 99 99
- Adding a Chart 101
- Editing Charts 102
- Chapter 6 Using Charts 103 103
- Deleting a Chart 105
- Moving a Chart 105
- Using a Legend 106
- Using a Chart Title 107
- Resizing a Chart 107
- Rotating Charts 107
- Chapter 6 Using Charts 109 109
- Chapter 6 Using Charts 111 111
- Pie Charts 113
- Set a pie wedge apart by 114
- Bar and Column Charts 115
- Area Charts and Line Charts 116
- Scatter Charts 117
- 3D Charts 118
- Working with Text 119
- Selecting Text 120
- Smart quotes 128
- Straight quotes 128
- Adjusting Font Smoothing 129
- Aligning Text Horizontally 131
- Aligning Text Vertically 131
- Changing Text Color 133
- Setting a New Tab Stop 135
- Changing a Tab Stop 135
- Deleting a Tab Stop 135
- Setting Indents 136
- Setting Indents for Lists 137
- Using Bulleted Lists 138
- Using Numbered Lists 139
- Adding Text Boxes 141
- Presenting Text in Columns 141
- Putting Text Inside a Shape 142
- Using Hyperlinks 143
- Editing Hyperlink Text 144
- Inserting a Nonbreaking Space 146
- Finding and Replacing Text 148
- Selecting Objects 149
- Deleting Objects 150
- Moving Objects 150
- Aligning Objects 151
- Modifying 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
- Filling Objects 160
- Using the Colors Window 161
- Using Shapes 164
- Making Shapes Editable 165
- Reshaping a Curve 166
- Reshaping a Straight Segment 167
- Using Media Placeholders 170
- Working with Images 171
- Masking (Cropping) Images 172
- Using PDF Files as Graphics 176
- Using Sound and Movies 177
- Adding Address Book Data 179
- Sharing Your Numbers 183
- Spreadsheet 183
- The ColorSync Utility icon 186
- Sending a Spreadsheet to iWeb 187
- Designing Your Own Numbers 188
- Spreadsheet Templates 188
- Dictionary of 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
- ACCRINTM 206
- AVERAGEA 211
- CONCATENATE 216
- CONFIDENCE 216
- COUNTBLANK 220
- COUPDAYBS 221
- COUPDAYS 221
- COUPDAYSNC 222
- FORECAST 233
- HYPERLINK 236
- INDIRECT 237
- INTERCEPT 238
- Examples 253
- PERCENTILE 256
- PRICEDISC 260
- PRICEMAT 260
- QUOTIENT 263
- RANDBETWEEN 264
- ROUNDDOWN 268
- SUBSTITUTE 277
- SUMPRODUCT 278
- TIMEVALUE 282
- Index 291 291
- 292 Index 292
- Index 293 293
- 294 Index 294
- Index 295 295
Powiązane produkty i podręczniki dla Oprogramowanie Apple Numbers '08
(22 strony)
(34 strony)
(288 strony)
(73 strony)
(270 strony)© 2020, manymanuals.pl. Wszelkie prawa zastrzeżone. | 0.224 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji