Mastering Microsoft Office (Palgrave Master)

Cover......Page 1
Contents......Page 6
Preface......Page 13
1.2 Introduction......Page 14
1.4 Switching on the PC and starting Windows......Page 16
1.5 Shutting down the computer......Page 19
2.2 Introduction......Page 20
2.3 Starting Word and understanding the Word screen......Page 21
2.4 Using Help......Page 23
2.5 Creating a document......Page 25
2.6 Moving around the document......Page 26
2.7 Inserting, deleting and replacing text......Page 27
2.8 Saving a document......Page 28
2.10 Retrieving a document and exiting from Word......Page 29
2.12 Multiple choice......Page 31
2.14 Practical exercises......Page 32
3.2 Introduction......Page 34
3.3 Copying a document......Page 35
3.5 Copying blocks of text......Page 36
3.6 Moving blocks of text......Page 39
3.7 Deleting blocks of text......Page 40
3.9 Using the spelling tool......Page 41
3.11 Preview your document......Page 43
3.12 Print your document......Page 44
3.14 Summary......Page 46
3.15 Multiple choice......Page 47
3.16 Written exercises......Page 48
3.17 Practical exercises......Page 49
4.3 Changing the appearance and size of text......Page 51
4.4 Using paragraph styles......Page 54
4.5 Aligning text......Page 55
4.7 Indenting a block of text......Page 57
4.8 Using bullet points......Page 59
4.9 Defining the page layout......Page 60
4.10 Creating headers and footers......Page 62
4.11 Add page numbers......Page 63
4.13 Multiple choice......Page 64
4.14 Written exercises......Page 65
4.15 Practical exercises......Page 66
5.2 Introduction......Page 68
5.3 Listing folders and files using My Computer......Page 70
5.4 Creating, renaming and deleting folders using My Computer......Page 71
5.5 Moving, copying and deleting files using My Computer......Page 73
5.7 Using Windows Explorer......Page 75
5.8 Summary......Page 76
5.9 Multiple choice......Page 77
5.10 Written exercises......Page 78
5.11 Practical exercises......Page 79
6.2 Introduction......Page 80
6.3 Starting Excel and understanding the Excel screen......Page 81
6.4 Moving around the worksheet......Page 83
6.5 Entering text and numbers......Page 84
6.6 Saving and closing a workbook......Page 85
6.8 Retrieving a workbook......Page 86
6.10 Printing a worksheet......Page 87
6.13 Multiple choice......Page 89
6.14 Written exercises......Page 90
6.15 Practical exercises......Page 91
7.3 Copying a workbook......Page 92
7.4 Editing the contents of a cell......Page 93
7.5 Selecting a range of cells......Page 94
7.6 Sort a range of cells......Page 95
7.7 Copying cell contents......Page 96
7.8 Moving cell contents......Page 97
7.10 Inserting and deleting rows and columns......Page 98
7.11 Aligning and formatting text......Page 99
7.12 Changing column and row widths......Page 100
7.13 Using AutoFormat to enhance the worksheet......Page 101
7.14 Defining the page layout......Page 102
7.15 Summary......Page 103
7.16 Multiple choice......Page 104
7.17 Written exercises......Page 105
7.18 Practical exercises......Page 106
8.2 Introduction......Page 107
8.3 Filling a range of cells by example......Page 108
8.4 Using formulae......Page 109
8.5 Using functions......Page 112
8.6 Using absolute cell addresses......Page 115
8.8 Summary......Page 116
8.10 Written exercises......Page 117
8.11 Practical exercises......Page 119
9.3 Creating a chart......Page 120
9.5 Amending chart features......Page 124
9.6 Creating a multi-series chart......Page 126
9.8 Using more than one worksheet in a workbook......Page 127
9.9 Linking worksheets together......Page 129
9.10 Adding headers, footers and page numbers to a worksheet......Page 130
9.11 Summary......Page 131
9.12 Multiple choice......Page 132
9.14 Practical exercises......Page 133
10.2 Introduction......Page 135
10.3 Starting Access......Page 136
10.4 Creating a new database......Page 137
10.5 Creating a table......Page 139
10.6 Entering and sorting data......Page 142
10.7 Filtering a database......Page 144
10.9 Summary......Page 145
10.11 Written exercises......Page 146
10.12 Practical exercises......Page 147
11.2 Introduction......Page 149
11.3 Opening a database......Page 150
11.4 Viewing table design......Page 152
11.5 Modifying field properties......Page 153
11.6 Creating a table without a wizard......Page 155
11.8 Saving the table......Page 158
11.9 Changing table structure......Page 159
11.10 Data entry and modification......Page 160
11.12 Multiple choice......Page 162
11.14 Practical exercises......Page 163
12.2 Introduction......Page 165
12.3 Creating a new table......Page 167
12.4 Building a relationship......Page 168
12.5 Extending a relationship......Page 171
12.6 Deleting a relationship......Page 173
12.7 Viewing a relationship......Page 174
12.9 Multiple choice......Page 175
12.10 Written exercises......Page 176
12.11 Practical exercises......Page 177
13.2 Introduction......Page 179
13.3 Creating a query......Page 180
13.5 Sorting a query......Page 184
13.6 Adding criteria to a query......Page 186
13.7 Combining criteria......Page 188
13.8 Creating a query without a wizard......Page 189
13.9 Adding calculations......Page 192
13.10 Summary......Page 193
13.11 Multiple choice......Page 194
13.12 Written exercises......Page 195
13.13 Practical exercises......Page 196
14.2 Introduction......Page 198
14.3 Creating a form with the Form Wizard......Page 199
14.5 Entering data into a simple form......Page 202
14.6 Creating a form from multiple tables......Page 203
14.7 Entering data into a two-table form......Page 205
14.8 Finding records......Page 206
14.9 Creating a report......Page 208
14.11 Modifying forms and reports......Page 211
14.13 Multiple choice......Page 213
14.15 Practical exercises......Page 214
15.2 Introduction......Page 216
15.3 Starting PowerPoint......Page 217
15.4 Creating a presentation with the AutoContent Wizard......Page 218
15.6 Viewing the slides......Page 220
15.7 Printing a presentation......Page 224
15.10 Simple editing in outline view......Page 225
15.11 Simple animation effects......Page 226
15.14 Multiple choice......Page 228
15.16 Practical exercises......Page 229
16.3 Creating a blank presentation......Page 230
16.4 Adding text......Page 231
16.5 Copying and moving slides in outline view......Page 235
16.6 Inserting a new slide......Page 236
16.7 Editing slides in slide view......Page 237
16.8 Using the drawing toolbar......Page 239
16.9 Animate the drawings......Page 240
16.10 Sharing data between applications......Page 241
16.12 Summary......Page 242
16.15 Practical exercises......Page 243
17.2 Introduction......Page 245
17.4 Sending e-mail......Page 247
17.5 Receiving e-mail......Page 248
17.7 Sending attachments with an e-mail......Page 250
17.9 Forwarding an e-mail......Page 252
17.11 Viewing copies of sent e-mails......Page 253
17.12 Using the address book......Page 254
17.14 Multiple choice......Page 255
17.16 Practical exercises......Page 256
A.1 Math......Page 257
A.2 Database and list management......Page 258
A.4 Engineering......Page 259
A.5 Financial......Page 261
A.6 Information......Page 262
A.9 Statistical......Page 263
A.10 Text......Page 265
D......Page 267
F......Page 268
P......Page 269
S......Page 270
W......Page 271