Computer Based Training: Office 97, Windows 95 & NT Basics

home *** CD-ROM | disk | FTP | other *** search

/ Computer Based Training: …, Windows 95 & NT Basics / a1454501.iso / mo97w03 / AW03.CTL < prev next >

Wrap

Text File | 1997-04-30 | 58.6 KB | 2,095 lines

Screen 3 1 16 ********************************* * Course: Microsoft Office 97: Advanced Word * Unit: Calculations and charts Unit No.:03 * Topic: Performing calculations Topic No.: 1 **** eff.exe a03_101.gif 86 443 0 1 0 15 15 15 * Word 97 includes its own math isave 16 447 293 362 text1 textbox 16 447 293 362 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_102a.gif 297 355 0 1 0 15 15 15 eff.exe a03_102b.gif 246 202 0 1 0 15 15 15 * In fact, you can use Word to c isave 16 367 293 260 text2 growbox 16 367 293 260 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 16 367 image memory text1 0 16 447 * qcall AW03q 030101 eff.exe a03_103a.gif 286 389 0 1 0 15 15 15 * It is often more convenient to isave 14 448 272 329 text1 textbox 14 448 272 329 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_104a.gif 296 369 0 1 0 15 15 15 * ≥ numbers are arranged in simp isave 14 334 272 278 text2 growbox 14 334 272 278 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_105a.gif 379 340 0 1 0 15 15 15 * ≥ numbers are distributed thro isave 14 283 272 227 text3 growbox 14 283 272 227 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 14 283 image memory text2 0 14 334 image memory text1 0 14 448 * eff.exe a03_106a.gif 155 389 0 1 0 15 15 15 * However, it is better to use E isave 9 447 242 328 text1 textbox 9 447 242 328 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_107a.gif 155 390 0 1 0 15 15 15 * ≥ complex tasks are being atte isave 9 333 242 260 text2 growbox 9 333 242 260 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_108a.gif 290 376 0 1 0 15 15 15 * ≥ numbers in a table are not a isave 9 265 242 192 text3 growbox 9 265 242 192 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 9 265 image memory text2 0 9 333 image memory text1 0 9 447 * eff.exe a03_109a.gif 245 390 0 1 0 15 15 15 * When you use Excel to perform isave 140 409 462 324 text1 textbox 140 409 462 324 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * It is also easy to move data f notebox 185 295 421 ** image memory text1 0 140 409 * Simscrn 3 2 16 ********************************* eff.exe a03_111.gif 0 459 0 1 0 15 15 15 * Let's begin by looking at how isave 357 250 601 165 text1 textbox 357 250 601 165 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_112a.gif 157 379 0 1 0 15 15 15 * We can take this part of a mem isave 357 170 601 97 text2 growbox 357 170 601 97 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 357 170 image memory text1 0 357 250 * eff.exe a03_113a.gif 157 379 0 1 0 15 15 15 * There are four figures in this isave 11 458 241 373 text1 textbox 11 458 241 373 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_114a.gif 172 298 0 1 0 15 15 15 * Vicky wants to automate the ca isave 11 378 241 254 text2 growbox 11 378 241 254 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 11 378 image memory text1 0 11 458 * qcall AW03q 030102 eff.exe a03_115a.gif 286 215 0 1 0 15 15 15 * Vicky needs to create a bookma isave 21 168 304 100 text1 textbox 21 168 304 100 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_116.gif 0 459 0 1 0 15 15 15 * She can then use the names of isave 21 105 304 49 text2 growbox 21 105 304 49 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 21 105 image memory text1 0 21 168 * eff.exe a03_117a.gif 167 430 0 1 0 15 15 15 eff.exe a03_117b.gif 388 289 0 1 0 15 15 15 eff.exe a03_117c.gif 167 20 0 1 0 15 15 15 eff.exe a03_117d.gif 388 20 0 1 0 15 15 15 * To create a bookmark, Vicky si isave 355 243 589 175 text1 textbox 355 243 589 175 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_118a.gif 103 457 0 1 0 15 15 15 * And selects Bookmark from the isave 355 180 589 124 text2 growbox 355 180 589 124 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 355 180 image memory text1 0 355 243 * eff.exe a03_119a.gif 103 457 0 1 0 15 15 15 * When the Bookmark dialog box o isave 6 455 231 387 text1 textbox 6 455 231 387 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_120a.gif 113 188 0 1 0 15 15 15 * And clicks the Add button isave 6 392 231 336 text2 growbox 6 392 231 336 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_121a.gif 113 430 0 1 0 15 15 15 eff.exe a03_121b.gif 113 338 0 1 0 15 15 15 * She then repeats this process isave 6 341 231 268 text3 growbox 6 341 231 268 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 6 341 image memory text2 0 6 392 image memory text1 0 6 455 * Simscrn 3 3 16 ********************************* eff.exe a03_122.gif 0 459 0 1 0 15 15 15 * To insert the field containing isave 346 237 603 152 text1 textbox 346 237 603 152 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_123a.gif 103 457 0 1 0 15 15 15 * And selects the Field option f isave 346 157 603 101 text2 growbox 346 157 603 101 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 346 157 image memory text1 0 346 237 * eff.exe a03_124a.gif 103 457 0 1 0 15 15 15 * The Field dialog box opens, en isave 350 311 622 243 text1 textbox 350 311 622 243 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_125a.gif 143 388 0 1 0 15 15 15 * The two list boxes at the top isave 350 248 622 141 text2 growbox 350 248 622 141 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_126a.gif 143 388 0 1 0 15 15 15 * ≥ field nam isave 350 146 622 107 text3 growbox 350 146 622 107 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 350 146 image memory text2 0 350 248 image memory text1 0 350 311 * eff.exe a03_127a.gif 43 388 0 1 0 15 15 15 * As Vicky is inserting a mathem isave 396 247 631 145 text1 textbox 396 247 631 145 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_128a.gif 43 373 0 1 0 15 15 15 * And =(Formula) has been select isave 396 150 631 77 text2 growbox 396 150 631 77 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 396 150 image memory text1 0 396 247 * eff.exe a03_129a.gif 174 373 0 1 0 15 15 15 eff.exe a03_129b.gif 321 373 0 1 0 15 15 15 eff.exe a03_129c.gif 174 196 0 1 0 15 15 15 eff.exe a03_129d.gif 321 196 0 1 0 15 15 15 * When she has selected the corr isave 347 298 622 213 text1 textbox 347 298 622 213 showtext 0 0 4 footnote 1 pause 1 1 1 1 1 1 1 1 ** qcall AW03q 030103 eff.exe a03_130a.gif 146 203 0 1 0 15 15 15 * Her formula can include bookma isave 347 218 622 145 text2 growbox 347 218 622 145 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 347 218 image memory text1 0 347 298 * *eff.exe a03_131.gif 0 459 0 1 0 15 15 15 * To add the four bookmarks Quar *isave 5 445 180 335 text1 *textbox 5 445 180 335 *showtext 0 0 2 *pause 1 1 1 1 1 1 1 1 ** eff.exe a03_132a.gif 161 203 0 1 0 15 15 15 * = Quarter1 + Quarter2 + Quarte isave 303 459 635 374 text1 textbox 303 459 635 374 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_133.gif 0 459 0 1 0 15 15 15 * It is very important to get th isave 303 379 635 289 text2 growbox 303 379 635 289 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** footnote 0 image memory text2 0 303 379 image memory text1 0 303 459 *image memory text1 0 5 445 * eff.exe a03_134a.gif 138 203 0 1 0 15 15 15 * When she has entered the formu isave 318 364 623 296 text1 textbox 318 364 623 296 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_135a.gif 138 427 0 1 0 15 15 15 eff.exe a03_135b.gif 138 20 0 1 0 15 15 15 * The field code is inserted whe isave 318 301 623 228 text2 growbox 318 301 623 228 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * You can view the field code it notebox 40 369 300 ** image memory text2 0 318 301 image memory text1 0 318 364 * qcall AW03q 030104 eff.exe a03_137a.gif 286 298 0 1 0 15 15 15 * If one of the numbers Vicky ha isave 30 431 306 329 text1 textbox 30 431 306 329 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_138a.gif 286 298 0 1 0 15 15 15 eff.exe a03_138b.gif 286 20 0 1 0 15 15 15 * To update the calculation, Vic isave 30 334 306 261 text2 growbox 30 334 306 261 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_139a.gif 286 225 0 1 0 15 15 15 * And then presses the F9 key, w isave 30 266 306 193 text3 growbox 30 266 306 193 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 30 266 image memory text2 0 30 334 image memory text1 0 30 431 * Simscrn 3 4 16 ********************************* eff.exe a03_140.gif 0 459 0 1 0 15 15 15 * Now let's look at how Word's m isave 195 430 417 345 text1 textbox 195 430 417 345 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 195 430 * eff.exe a03_141.gif 0 459 0 1 0 15 15 15 * Suppose that Vicky Jones has c isave 10 412 249 327 text1 textbox 10 412 249 327 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_142a.gif 471 333 0 1 0 15 15 15 * She needs to complete her tabl isave 10 332 249 242 text2 growbox 10 332 249 242 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_143a.gif 466 333 0 1 0 15 15 15 * And she wants to insert the su isave 10 247 249 174 text3 growbox 10 247 249 174 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 10 247 image memory text2 0 10 332 image memory text1 0 10 412 * eff.exe a03_144a.gif 22 380 0 1 0 15 15 15 eff.exe a03_144b.gif 49 431 0 1 0 15 15 15 eff.exe a03_144c.gif 219 303 0 1 0 15 15 15 * Vicky begins by placing the in isave 4 252 230 167 text1 textbox 4 252 230 167 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_145a.gif 68 457 0 1 0 15 15 15 * And selects Tables and Borders isave 4 172 230 99 text2 growbox 4 172 230 99 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_146a.gif 68 457 0 1 0 15 15 15 * This opens the Tables and Bord isave 4 104 230 14 text3 growbox 4 104 230 14 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 4 104 image memory text2 0 4 172 image memory text1 0 4 252 * qcall AW03q 030105 eff.exe a03_147a.gif 141 409 0 1 0 15 15 15 * Vicky can click the AutoSum bu isave 17 299 288 214 text1 textbox 17 299 288 214 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_148a.gif 320 409 0 1 0 15 15 15 eff.exe a03_148b.gif 415 409 0 1 0 15 15 15 eff.exe a03_148c.gif 320 20 0 1 0 15 15 15 eff.exe a03_148d.gif 415 20 0 1 0 15 15 15 * A formula inserted using this isave 17 219 288 129 text2 growbox 17 219 288 129 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 17 219 image memory text1 0 17 299 * eff.exe a03_149a.gif 223 427 0 1 0 15 15 15 eff.exe a03_149b.gif 466 285 0 1 0 15 15 15 eff.exe a03_149c.gif 223 20 0 1 0 15 15 15 eff.exe a03_149d.gif 466 20 0 1 0 15 15 15 * However, this can lead to prob isave 32 290 297 205 text1 textbox 32 290 297 205 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_150a.gif 264 427 0 1 0 15 15 15 eff.exe a03_150b.gif 466 303 0 1 0 15 15 15 eff.exe a03_150c.gif 264 20 0 1 0 15 15 15 eff.exe a03_150d.gif 466 20 0 1 0 15 15 15 * Here, for example, the formula isave 32 210 297 120 text2 growbox 32 210 297 120 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_151a.gif 466 303 0 1 0 15 15 15 * As this is not what Vicky inte isave 32 125 297 52 text3 growbox 32 125 297 52 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 32 125 image memory text2 0 32 210 image memory text1 0 32 290 * Simscrn 3 5 16 ********************************* eff.exe a03_152.gif 0 459 0 1 0 15 15 15 * Vicky can also insert a formul isave 13 197 266 129 text1 textbox 13 197 266 129 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_153a.gif 188 457 0 1 0 15 15 15 * This opens the Formula dialog isave 13 134 266 27 text2 growbox 13 134 266 27 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 13 134 image memory text1 0 13 197 * eff.exe a03_154a.gif 181 323 0 1 0 15 15 15 * When the Formula dialog box op isave 7 202 282 117 text1 textbox 7 202 282 117 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_155a.gif 181 323 0 1 0 15 15 15 eff.exe a03_155b.gif 288 181 0 1 0 15 15 15 * If Word cannot determine an ap isave 7 122 282 32 text2 growbox 7 122 282 32 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 7 122 image memory text1 0 7 202 * qcall AW03q 030106 eff.exe a03_156a.gif 117 334 0 1 0 15 15 15 * The first character in the For isave 18 187 267 136 text1 textbox 18 187 267 136 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** footnote 2 eff.exe a03_157a.gif 209 297 0 1 0 15 15 15 eff.exe a03_157b.gif 209 181 0 1 0 15 15 15 eff.exe a03_157c.gif 288 181 0 1 0 15 15 15 * This is followed by a mathemat isave 18 141 267 51 text2 growbox 18 141 267 51 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 18 141 image memory text1 0 18 187 * *qcall AW03q 030107 eff.exe a03_158a.gif 117 334 0 1 0 15 15 15 eff.exe a03_158b.gif 181 210 0 1 0 15 15 15 * Instead of entering functions isave 367 348 620 280 text1 textbox 367 348 620 280 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_159a.gif 181 210 0 1 0 15 15 15 * This automatically enters the isave 367 285 620 212 text2 growbox 367 285 620 212 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** footnote 0 image memory text2 0 367 285 image memory text1 0 367 348 * eff.exe a03_160a.gif 234 363 0 1 0 15 15 15 * Vicky can specify which cells isave 373 345 632 260 text1 textbox 373 345 632 260 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * Many functions are followed by notebox 77 355 351 ** eff.exe a03_162.gif 0 459 0 1 0 15 15 15 * There are several methods she isave 373 265 632 192 text2 growbox 373 265 632 192 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 373 265 image memory text1 0 373 345 * *eff.exe a03_163.gif 0 459 0 1 0 15 15 15 * Vicky can enter the terms ABOV *isave 338 435 625 350 text1 *textbox 338 435 625 350 *showtext 0 0 4 *pause 1 1 1 1 1 1 1 1 ** eff.exe a03_164a.gif 191 363 0 1 0 15 15 15 * =SUM(LEFT isave 32 258 320 139 text1 textbox 32 258 320 139 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** * Unlike formulas entered using notebox 329 239 588 ** eff.exe a03_166a.gif 188 345 0 1 0 15 15 15 eff.exe a03_166b.gif 466 273 0 1 0 15 15 15 eff.exe a03_166c.gif 188 20 0 1 0 15 15 15 eff.exe a03_166d.gif 466 20 0 1 0 15 15 15 * This will calculate the total isave 32 144 320 54 text2 growbox 32 144 320 54 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 32 144 image memory text1 0 32 258 * Simscrn 3 6 16 ********************************* eff.exe a03_167.gif 0 459 0 1 0 15 15 15 * Vicky can also use a system of isave 143 287 422 219 text1 textbox 143 287 422 219 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_168a.gif 63 373 0 1 0 15 15 15 * The columns of a table can be isave 143 224 422 168 text2 growbox 143 224 422 168 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_169a.gif 0 328 0 1 0 15 15 15 eff.exe a03_169b.gif 63 373 0 1 0 15 15 15 * Similarly, the rows can be ref isave 143 173 422 117 text3 growbox 143 173 422 117 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 143 173 image memory text2 0 143 224 image memory text1 0 143 287 * eff.exe a03_170a.gif 0 328 0 1 0 15 15 15 * For example, the cell containi isave 182 262 430 194 text1 textbox 182 262 430 194 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_171a.gif 33 328 0 1 0 15 15 15 eff.exe a03_171b.gif 468 298 0 1 0 15 15 15 * And the cell containing the to isave 182 199 430 143 text2 growbox 182 199 430 143 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 182 199 image memory text1 0 182 262 * qcall AW03q 030108 eff.exe a03_172a.gif 468 298 0 1 0 15 15 15 * The table coordinate system al isave 12 272 271 204 text1 textbox 12 272 271 204 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_173a.gif 91 430 0 1 0 15 15 15 eff.exe a03_173b.gif 177 430 0 1 0 15 15 15 * For instance, you can specify isave 12 209 271 119 text2 growbox 12 209 271 119 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_174a.gif 91 430 0 1 0 15 15 15 eff.exe a03_174b.gif 177 430 0 1 0 15 15 15 * An =SUM() formula containing t isave 12 124 271 51 text3 growbox 12 124 271 51 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 12 124 image memory text2 0 12 209 image memory text1 0 12 272 * eff.exe a03_175a.gif 5 427 0 1 0 15 15 15 eff.exe a03_175b.gif 91 427 0 1 0 15 15 15 eff.exe a03_175c.gif 5 154 0 1 0 15 15 15 * You can also use the column or isave 169 191 449 123 text1 textbox 169 191 449 123 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_176a.gif 239 379 0 1 0 15 15 15 eff.exe a03_176b.gif 239 333 0 1 0 15 15 15 eff.exe a03_176c.gif 468 333 0 1 0 15 15 15 * For example, the reference F:F isave 169 128 449 55 text2 growbox 169 128 449 55 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_177a.gif 2 379 0 1 0 15 15 15 eff.exe a03_177b.gif 2 333 0 1 0 15 15 15 * And the reference 2:2 specifie isave 169 60 449 4 text3 growbox 169 60 449 4 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 169 60 image memory text2 0 169 128 image memory text1 0 169 191 * qcall AW03q 030109 eff.exe a03_178a.gif 438 183 0 1 0 15 15 15 * You can use bookmarks to inclu isave 332 435 617 333 text1 textbox 332 435 617 333 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_179a.gif 2 454 0 1 0 15 15 15 * For example, if Vicky wanted t isave 332 338 617 265 text2 growbox 332 338 617 265 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 332 338 image memory text1 0 332 435 * eff.exe a03_180a.gif 29 454 0 1 0 15 15 15 eff.exe a03_180b.gif 580 374 0 1 0 15 15 15 eff.exe a03_180c.gif 29 20 0 1 0 15 15 15 eff.exe a03_180d.gif 580 20 0 1 0 15 15 15 * She could then enter that book isave 28 257 288 189 text1 textbox 28 257 288 189 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_181a.gif 183 323 0 1 0 15 15 15 eff.exe a03_181b.gif 316 210 0 1 0 15 15 15 * Or, instead of typing the book isave 28 194 288 87 text2 growbox 28 194 288 87 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 28 194 image memory text1 0 28 257 * ** eff.exe a03_182a.gif 139 377 0 1 0 15 15 15 eff.exe a03_182b.gif 188 377 0 1 0 15 15 15 eff.exe a03_182c.gif 188 20 0 1 0 15 15 15 * Vicky enters the formulas to isave 6 259 277 208 text1 textbox 6 259 277 208 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_184a.gif 178 345 0 1 0 15 15 15 * To total all these totals in isave 6 213 277 106 text2 growbox 6 213 277 106 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_185.gif 0 459 0 1 0 15 15 15 * Before inserting this formula, isave 6 111 277 4 text3 growbox 6 111 277 4 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 6 111 image memory text2 0 6 213 image memory text1 0 6 259 * eff.exe a03_186a.gif 178 323 0 1 0 15 15 15 * She can set the format of the isave 354 418 633 350 text1 textbox 354 418 633 350 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_187a.gif 188 254 0 1 0 15 15 15 * Vicky clicks the OK button to isave 354 355 633 299 text2 growbox 354 355 633 299 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_188a.gif 188 345 0 1 0 15 15 15 eff.exe a03_188b.gif 468 123 0 1 0 15 15 15 eff.exe a03_188c.gif 188 20 0 1 0 15 15 15 eff.exe a03_188d.gif 468 20 0 1 0 15 15 15 * Word then returns the result o isave 354 304 633 231 text3 growbox 354 304 633 231 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 354 304 image memory text2 0 354 355 image memory text1 0 354 418 * * Topic: Hands-on: Performing a calculation in a table Topic No.: 2 **** Simscrn 3 7 16 ********************************* MoveCtrl 1 493 426 0 0 ********************************* *eff.exe a03_201.gif 86 443 0 1 0 15 15 15 * Now that you have seen Vicky e isave 218 301 401 216 text1 textbox 218 301 401 216 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 image memory text1 0 218 301 ** exercise 01 1 130 100 *exercise 1 1 200 80 task 1 0101 404 320 236 4 70 67 35 75 *task 01 0101 404 320 236 4 70 67 35 75 pause 1 1 1 1 1 1 1 1 ** * * Topic: Creating and importing worksheets Topic No.: 3 **** Screen 3 8 16 ********************************* eff.exe a03_301.gif 86 443 0 1 0 15 15 15 * Although Word's math tools are isave 4 455 277 353 text1 textbox 4 455 277 353 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_302a.gif 212 363 0 1 0 15 15 15 * While you may prefer to use Ex isave 4 358 277 268 text2 growbox 4 358 277 268 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_303a.gif 245 296 0 1 0 15 15 15 * Similarly, you might need to u isave 4 273 277 183 text3 growbox 4 273 277 183 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** * In Excel, a worksheet is the p notebox 286 393 510 ** image memory text3 0 4 273 image memory text2 0 4 358 image memory text1 0 4 455 * eff.exe a03_305a.gif 291 400 0 1 0 15 15 15 * You can use an Excel worksheet isave 28 448 287 346 text1 textbox 28 448 287 346 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_306a.gif 183 400 0 1 0 15 15 15 * ≥ embedding the worksheet in t isave 28 351 287 261 text2 growbox 28 351 287 261 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_307a.gif 183 406 0 1 0 15 15 15 * ≥ linking the worksheet to the isave 28 266 287 193 text3 growbox 28 266 287 193 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 28 266 image memory text2 0 28 351 image memory text1 0 28 448 * eff.exe a03_308a.gif 183 406 0 1 0 15 15 15 * When you paste data from an Ex isave 51 449 274 364 text1 textbox 51 449 274 364 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_309a.gif 286 400 0 1 0 15 15 15 * This has the advantage that th isave 51 369 274 296 text2 growbox 51 369 274 296 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_310a.gif 273 308 0 1 0 15 15 15 * However, you cannot update or isave 51 301 274 211 text3 growbox 51 301 274 211 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 51 301 image memory text2 0 51 369 image memory text1 0 51 449 * eff.exe a03_311a.gif 86 383 0 1 0 15 15 15 * Embedding and linking Excel da isave 3 447 250 345 text1 textbox 3 447 250 345 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** qcall AW03q 030301 eff.exe a03_312a.gif 201 398 0 1 0 15 15 15 * All the applications in Office isave 3 350 250 260 text2 growbox 3 350 250 260 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 3 350 image memory text1 0 3 447 * eff.exe a03_313a.gif 86 424 0 1 0 15 15 15 * Embedded data has the advantag isave 11 287 291 185 text1 textbox 11 287 291 185 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_314a.gif 197 371 0 1 0 15 15 15 eff.exe a03_314b.gif 385 396 0 1 0 15 15 15 * You can easily edit embedded d isave 11 190 291 100 text2 growbox 11 190 291 100 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_315a.gif 197 424 0 1 0 15 15 15 * However, if you have embedded isave 11 105 291 15 text3 growbox 11 105 291 15 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 11 105 image memory text2 0 11 190 image memory text1 0 11 287 * qcall AW03q 030302 eff.exe a03_316a.gif 275 437 0 1 0 15 15 15 * Unlike embedded data, changes isave 4 450 254 348 text1 textbox 4 450 254 348 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_317a.gif 287 304 0 1 0 15 15 15 * However, if you send a documen isave 4 353 254 229 text2 growbox 4 353 254 229 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 4 353 image memory text1 0 4 450 * Simscrn 3 9 16 ********************************* eff.exe a03_318.gif 0 459 0 1 0 15 15 15 * Let's take a look at how these isave 370 290 627 205 text1 textbox 370 290 627 205 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_319a.gif 0 459 0 1 0 15 15 15 * Vicky Jones has created an Exc isave 370 210 627 154 text2 growbox 370 210 627 154 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_320a.gif 0 457 0 1 0 15 15 15 * And she now wants to paste thi isave 370 159 627 86 text3 growbox 370 159 627 86 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 370 159 image memory text2 0 370 210 image memory text1 0 370 290 * eff.exe a03_321a.gif 0 459 0 1 0 15 15 15 * Vicky opens both her Word docu isave 355 307 604 222 text1 textbox 355 307 604 222 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_322a.gif 16 447 0 1 0 15 15 15 eff.exe a03_322b.gif 536 408 0 1 0 15 15 15 * She then clicks the Copy butto isave 355 227 604 154 text2 growbox 355 227 604 154 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_323a.gif 0 458 0 1 0 15 15 15 * And returns to Word, where she isave 355 159 604 86 text3 growbox 355 159 604 86 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 355 159 image memory text2 0 355 227 image memory text1 0 355 307 * qcall AW03q 030303 eff.exe a03_324a.gif 93 447 0 1 0 15 15 15 eff.exe a03_324b.gif 264 447 0 1 0 15 15 15 * To do this, Vicky places the i isave 366 264 636 179 text1 textbox 366 264 636 179 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_325a.gif 46 457 0 1 0 15 15 15 * Or selects Paste Cells from th isave 366 184 636 128 text2 growbox 366 184 636 128 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_326a.gif 23 457 0 1 0 15 15 15 eff.exe a03_326b.gif 23 20 0 1 0 15 15 15 * Either method pastes the infor isave 366 133 636 60 text3 growbox 366 133 636 60 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 366 133 image memory text2 0 366 184 image memory text1 0 366 264 * eff.exe a03_327a.gif 17 434 0 1 0 15 15 15 eff.exe a03_327b.gif 17 20 0 1 0 15 15 15 * A table created in this manner isave 419 309 625 224 text1 textbox 419 309 625 224 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_328a.gif 22 430 0 1 0 15 15 15 eff.exe a03_328b.gif 535 408 0 1 0 15 15 15 eff.exe a03_328c.gif 22 20 0 1 0 15 15 15 eff.exe a03_328d.gif 535 20 0 1 0 15 15 15 * And formulas can be inserted i isave 419 229 625 139 text2 growbox 419 229 625 139 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 419 229 image memory text1 0 419 309 * qcall AW03q 030304 eff.exe a03_329a.gif 191 408 0 1 0 15 15 15 eff.exe a03_329b.gif 212 286 0 1 0 15 15 15 * Because data pasted into Word isave 27 288 249 203 text1 textbox 27 288 249 203 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_330a.gif 0 458 0 1 0 15 15 15 * To edit this data in Excel you isave 27 208 249 84 text2 growbox 27 208 249 84 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 27 208 image memory text1 0 27 288 * Simscrn 3 10 16 ********************************* eff.exe a03_331.gif 0 459 0 1 0 15 15 15 * Vicky decides to embed the Exc isave 24 205 318 120 text1 textbox 24 205 318 120 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_332a.gif 0 458 0 1 0 15 15 15 * To embed the data, she selects isave 24 125 318 69 text2 growbox 24 125 318 69 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_333a.gif 41 457 0 1 0 15 15 15 * This opens the Paste Special d isave 24 74 318 35 text3 growbox 24 74 318 35 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 24 74 image memory text2 0 24 125 image memory text1 0 24 205 * eff.exe a03a333a.gif 259 289 0 1 0 15 15 15 qcall AW03q 030305 eff.exe a03_334a.gif 138 313 0 1 0 15 15 15 eff.exe a03_334b.gif 514 244 0 1 0 15 15 15 * Vicky selects the Microsoft Ex isave 6 444 258 376 text1 textbox 6 444 258 376 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_335a.gif 138 313 0 1 0 15 15 15 * The Float over text checkbox h isave 6 381 258 257 text2 growbox 6 381 258 257 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_336a.gif 432 274 0 1 0 15 15 15 * If she cleared this checkbox, isave 6 262 258 172 text3 growbox 6 262 258 172 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 6 262 image memory text2 0 6 381 image memory text1 0 6 444 * eff.exe a03_337a.gif 259 302 0 1 0 15 15 15 eff.exe a03_337b.gif 198 242 0 1 0 15 15 15 eff.exe a03_337c.gif 393 242 0 1 0 15 15 15 * Vicky could select the Display isave 13 434 276 349 text1 textbox 13 434 276 349 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_338a.gif 2 430 0 1 0 15 15 15 * When this icon is inserted int isave 13 354 276 281 text2 growbox 13 354 276 281 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 13 354 image memory text1 0 13 434 * eff.exe a03_339a.gif 2 430 0 1 0 15 15 15 * Vicky chooses to insert the wo isave 175 405 398 337 text1 textbox 175 405 398 337 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_340a.gif 2 430 0 1 0 15 15 15 * This embeds the worksheet data isave 175 342 398 286 text2 growbox 175 342 398 286 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 175 342 image memory text1 0 175 405 * eff.exe a03_341a.gif 145 261 0 1 0 15 15 15 eff.exe a03_341b.gif 4 15 0 1 0 15 15 15 * As this worksheet object has b isave 10 456 276 371 text1 textbox 10 456 276 371 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_342a.gif 4 427 0 1 0 15 15 15 eff.exe a03_342b.gif 4 264 0 1 0 15 15 15 * She can place it wherever she isave 10 376 276 337 text2 growbox 10 376 276 337 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_343a.gif 145 261 0 1 0 15 15 15 eff.exe a03_343b.gif 4 15 0 1 0 15 15 15 * She can also drag the handles isave 10 342 276 286 text3 growbox 10 342 276 286 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 10 342 image memory text2 0 10 376 image memory text1 0 10 456 * eff.exe a03_344a.gif 0 458 0 1 0 15 15 15 * If Vicky wants to edit the emb isave 365 410 637 325 text1 textbox 365 410 637 325 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_345a.gif 0 431 0 1 0 15 15 15 eff.exe a03_345b.gif 485 431 0 1 0 15 15 15 eff.exe a03_345c.gif 123 134 0 1 0 15 15 15 eff.exe a03_345d.gif 490 108 0 1 0 15 15 15 * She can then edit the workshee isave 365 330 637 274 text2 growbox 365 330 637 274 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 365 330 image memory text1 0 365 410 * Simscrn 3 11 16 ********************************* eff.exe a03_346.gif 0 459 0 1 0 15 15 15 * Suppose Vicky wanted to embed isave 381 321 624 253 text1 textbox 381 321 624 253 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_347a.gif 111 457 0 1 0 15 15 15 * She can do this by selecting O isave 381 258 624 202 text2 growbox 381 258 624 202 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_348a.gif 99 457 0 1 0 15 15 15 * This opens the Object dialog b isave 381 207 624 168 text3 growbox 381 207 624 168 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 381 207 image memory text2 0 381 258 image memory text1 0 381 321 * eff.exe a03_349a.gif 106 336 0 1 0 15 15 15 eff.exe a03_349b.gif 106 268 0 1 0 15 15 15 * In the Create New tab, Vicky s isave 117 215 322 147 text1 textbox 117 215 322 147 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_350a.gif 106 268 0 1 0 15 15 15 eff.exe a03_350b.gif 445 98 0 1 0 15 15 15 * And clicks OK isave 117 152 322 113 text2 growbox 117 152 322 113 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 117 152 image memory text1 0 117 215 * eff.exe a03_351a.gif 0 458 0 1 0 15 15 15 * Word embeds a blank worksheet isave 211 373 480 322 text1 textbox 211 373 480 322 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_352a.gif 36 381 0 1 0 15 15 15 eff.exe a03_352b.gif 189 431 0 1 0 15 15 15 eff.exe a03_352c.gif 36 46 0 1 0 15 15 15 eff.exe a03_352d.gif 189 46 0 1 0 15 15 15 * Vicky can use these to enter a isave 211 327 480 271 text2 growbox 211 327 480 271 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 211 327 image memory text1 0 211 373 * qcall AW03q 030306 eff.exe a03_353a.gif 267 282 0 1 0 15 15 15 * Although any recipient of this isave 191 361 415 259 text1 textbox 191 361 415 259 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 191 361 * Simscrn 3 12 16 ********************************* eff.exe a03_354.gif 0 459 0 1 0 15 15 15 * If Vicky wanted to link the da isave 12 300 253 164 text1 textbox 12 300 253 164 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_355a.gif 99 457 0 1 0 15 15 15 * This opens the Object dialog b isave 12 169 253 96 text2 growbox 12 169 253 96 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_356a.gif 108 427 0 1 0 15 15 15 eff.exe a03_356b.gif 108 388 0 1 0 15 15 15 eff.exe a03_356c.gif 416 335 0 1 0 15 15 15 * This time, however, Vicky sele isave 12 101 253 45 text3 growbox 12 101 253 45 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 12 101 image memory text2 0 12 169 image memory text1 0 12 300 * eff.exe a03_357a.gif 101 388 0 1 0 15 15 15 * Vicky can now type a path in t isave 18 308 289 257 text1 textbox 18 308 289 257 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_358a.gif 101 363 0 1 0 15 15 15 * Or click the Browse button isave 18 262 289 223 text2 growbox 18 262 289 223 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_359a.gif 10 433 0 1 0 15 15 15 * The Browse dialog box enables isave 18 228 289 155 text3 growbox 18 228 289 155 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 18 228 image memory text2 0 18 262 image memory text1 0 18 308 * eff.exe a03_360a.gif 10 433 0 1 0 15 15 15 * When she has selected the work isave 54 335 287 233 text1 textbox 54 335 287 233 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_361a.gif 297 297 0 1 0 15 15 15 eff.exe a03_361b.gif 272 105 0 1 0 15 15 15 * And clicks OK isave 54 238 287 199 text2 growbox 54 238 287 199 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 54 238 image memory text1 0 54 335 * eff.exe a03_362a.gif 2 430 0 1 0 15 15 15 * Word then inserts the informat isave 157 436 476 368 text1 textbox 157 436 476 368 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_363a.gif 2 439 0 1 0 15 15 15 eff.exe a03_363b.gif 4 15 0 1 0 15 15 15 * When Vicky double-clicks the i isave 157 373 476 283 text2 growbox 157 373 476 283 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 157 373 image memory text1 0 157 436 * qcall AW03q 030307 eff.exe a03_364a.gif 2 312 0 1 0 15 15 15 eff.exe a03_364b.gif 269 303 0 1 0 15 15 15 * Although the worksheet informa isave 47 317 330 232 text1 textbox 47 317 330 232 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_365a.gif 269 303 0 1 0 15 15 15 * This helps minimize the size o isave 47 237 330 147 text2 growbox 47 237 330 147 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 47 237 image memory text1 0 47 317 * * Topic: Creating charts Topic No.: 4 **** Screen 3 13 16 ********************************* eff.exe a03_401.gif 86 443 0 1 0 15 15 15 * Charts can be a more effective isave 5 445 310 394 text1 textbox 5 445 310 394 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_402a.gif 175 237 0 1 0 15 15 15 eff.exe a03_402b.gif 280 293 0 1 0 15 15 15 * They can show important trends isave 5 399 310 309 text2 growbox 5 399 310 309 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_403a.gif 175 237 0 1 0 15 15 15 eff.exe a03_403b.gif 280 293 0 1 0 15 15 15 * Word 97's charting tool, which isave 5 314 310 224 text3 growbox 5 314 310 224 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 5 314 image memory text2 0 5 399 image memory text1 0 5 445 * eff.exe a03_404a.gif 287 251 0 1 0 15 15 15 * Charts are created using a Gra isave 9 452 234 384 text1 textbox 9 452 234 384 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_405a.gif 245 190 0 1 0 15 15 15 eff.exe a03_405b.gif 201 144 0 1 0 15 15 15 * You can enter text and numbers isave 9 389 234 282 text2 growbox 9 389 234 282 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_406a.gif 231 335 0 1 0 15 15 15 eff.exe a03_406b.gif 201 144 0 1 0 15 15 15 * ≥ copying the data from a Word isave 9 287 234 231 text3 growbox 9 287 234 231 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_407a.gif 231 345 0 1 0 15 15 15 * ≥ copying the data from a tabb isave 9 236 234 163 text4 growbox 9 236 234 163 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 qcall AW03q 030401 ** image memory text4 0 9 236 image memory text3 0 9 287 image memory text2 0 9 389 image memory text1 0 9 452 * eff.exe a03_408a.gif 226 388 0 1 0 15 15 15 * Excel also uses Microsoft Grap isave 366 246 615 161 text1 textbox 366 246 615 161 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_409.gif 86 443 0 1 0 15 15 15 * Alternatively, you can import isave 366 166 615 93 text2 growbox 366 166 615 93 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 366 166 image memory text1 0 366 246 * eff.exe a03_410a.gif 226 388 0 1 0 15 15 15 * Graph offers you a choice of 1 isave 175 444 423 393 text1 textbox 175 444 423 393 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_411a.gif 343 327 0 1 0 15 15 15 * It also offers a custom chart isave 175 398 423 325 text2 growbox 175 398 423 325 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 175 398 image memory text1 0 175 444 * eff.exe a03_412a.gif 287 319 0 1 0 15 15 15 * Graph also provides a number o isave 30 447 265 311 text1 textbox 30 447 265 311 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_413a.gif 294 339 0 1 0 15 15 15 * ≥ data label isave 30 316 265 277 text2 growbox 30 316 265 277 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_414a.gif 294 339 0 1 0 15 15 15 eff.exe a03_414b.gif 373 274 0 1 0 15 15 15 * ≥ 3-D view isave 30 282 265 243 text3 growbox 30 282 265 243 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 30 282 image memory text2 0 30 316 image memory text1 0 30 447 * Simscrn 3 14 16 ********************************* eff.exe a03_415.gif 0 459 0 1 0 15 15 15 * Let's see how Vicky goes about isave 351 455 637 370 text1 textbox 351 455 637 370 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_416a.gif 27 388 0 1 0 15 15 15 * Vicky wants to use more of the isave 351 375 637 302 text2 growbox 351 375 637 302 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_417a.gif 27 388 0 1 0 15 15 15 eff.exe a03_417b.gif 171 178 0 1 0 15 15 15 * This is known as "landscape" o isave 351 307 637 234 text3 growbox 351 307 637 234 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 351 307 image memory text2 0 351 375 image memory text1 0 351 455 * eff.exe a03_418a.gif 21 457 0 1 0 15 15 15 * She begins by selecting Page S isave 290 252 558 201 text1 textbox 290 252 558 201 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_419a.gif 21 457 0 1 0 15 15 15 eff.exe a03_419b.gif 562 19 0 1 0 15 15 15 * This opens the Page Setup dial isave 290 206 558 167 text2 growbox 290 206 558 167 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_420a.gif 120 388 0 1 0 15 15 15 eff.exe a03_420b.gif 120 149 0 1 0 15 15 15 * And she selects the Paper Size isave 290 172 558 133 text3 growbox 290 172 558 133 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 290 172 image memory text2 0 290 206 image memory text1 0 290 252 * eff.exe a03a420a.gif 166 388 0 1 0 15 15 15 eff.exe a03a420b.gif 166 250 0 1 0 15 15 15 qcall AW03q 030402 eff.exe a03_421a.gif 180 232 0 1 0 15 15 15 * Vicky changes the page orienta isave 359 239 572 171 text1 textbox 359 239 572 171 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_422a.gif 147 379 0 1 0 15 15 15 eff.exe a03_422b.gif 147 321 0 1 0 15 15 15 eff.exe a03_422c.gif 330 321 0 1 0 15 15 15 * This has increased the availab isave 359 176 572 120 text2 growbox 359 176 572 120 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 359 176 image memory text1 0 359 239 * eff.exe a03_423a.gif 180 232 0 1 0 15 15 15 eff.exe a03_423b.gif 366 198 0 1 0 15 15 15 * Finally, Vicky ensures that th isave 31 262 303 177 text1 textbox 31 262 303 177 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_424a.gif 366 198 0 1 0 15 15 15 * She clicks OK isave 31 182 303 143 text2 growbox 31 182 303 143 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_425a.gif 7 351 0 1 0 15 15 15 eff.exe a03_425b.gif 36 428 0 1 0 15 15 15 * When she returns to her docume isave 31 148 303 75 text3 growbox 31 148 303 75 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_426a.gif 56 328 0 1 0 15 15 15 eff.exe a03_426b.gif 56 20 0 1 0 15 15 15 * And places the insertion point isave 31 80 303 24 text4 growbox 31 80 303 24 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 31 80 image memory text3 0 31 148 image memory text2 0 31 182 image memory text1 0 31 262 * eff.exe a03_427a.gif 89 457 0 1 0 15 15 15 eff.exe a03_427b.gif 103 457 0 1 0 15 15 15 * Next Vicky inserts her chart i isave 353 409 609 341 text1 textbox 353 409 609 341 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_428a.gif 99 457 0 1 0 15 15 15 eff.exe a03_428b.gif 99 20 0 1 0 15 15 15 * This opens the Object dialog b isave 353 346 609 256 text2 growbox 353 346 609 256 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_429a.gif 106 258 0 1 0 15 15 15 eff.exe a03_429b.gif 377 116 0 1 0 15 15 15 * And clicks OK isave 353 261 609 222 text3 growbox 353 261 609 222 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 353 261 image memory text2 0 353 346 image memory text1 0 353 409 * qcall AW03q 030403 eff.exe a03_430a.gif 0 458 0 1 0 15 15 15 * Because Vicky has not yet spec isave 301 351 569 266 text1 textbox 301 351 569 266 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_431a.gif 42 454 0 1 0 15 15 15 * To make it easier to edit, Wor isave 301 271 569 181 text2 growbox 301 271 569 181 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 301 271 image memory text1 0 301 351 * Simscrn 3 15 16 ********************************* eff.exe a03_432.gif 0 459 0 1 0 15 15 15 * Now that she has inserted the isave 357 440 624 355 text1 textbox 357 440 624 355 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_433a.gif 0 458 0 1 0 15 15 15 * She chooses to copy her data a isave 357 360 624 270 text2 growbox 357 360 624 270 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_434a.gif 22 447 0 1 0 15 15 15 eff.exe a03_434b.gif 614 447 0 1 0 15 15 15 eff.exe a03_434c.gif 22 20 0 1 0 15 15 15 eff.exe a03_434d.gif 614 20 0 1 0 15 15 15 * Vicky selects the cells in the isave 357 275 624 185 text3 growbox 357 275 624 185 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 357 275 image memory text2 0 357 360 image memory text1 0 357 440 * eff.exe a03_435a.gif 0 458 0 1 0 15 15 15 * Next she returns to the docume isave 377 438 626 370 text1 textbox 377 438 626 370 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_436a.gif 41 457 0 1 0 15 15 15 * And deletes them by selecting isave 377 375 626 319 text2 growbox 377 375 626 319 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * You can also delete the select notebox 109 419 366 ** eff.exe a03_438a.gif 41 457 0 1 0 15 15 15 eff.exe a03_438b.gif 4 194 0 1 0 15 15 15 * Vicky can now insert her own d isave 377 324 626 268 text3 growbox 377 324 626 268 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 377 324 image memory text2 0 377 375 image memory text1 0 377 438 * eff.exe a03_439a.gif 172 430 0 1 0 15 15 15 eff.exe a03_439b.gif 172 169 0 1 0 15 15 15 * Vicky places the insertion poi isave 345 318 601 267 text1 textbox 345 318 601 267 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_440a.gif 385 447 0 1 0 15 15 15 eff.exe a03_440b.gif 172 169 0 1 0 15 15 15 * She then clicks the Paste butt isave 345 272 601 233 text2 growbox 345 272 601 233 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_441a.gif 385 447 0 1 0 15 15 15 eff.exe a03_441b.gif 101 206 0 1 0 15 15 15 * Which pastes the data into the isave 345 238 601 182 text3 growbox 345 238 601 182 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 345 238 image memory text2 0 345 272 image memory text1 0 345 318 * eff.exe a03_442a.gif 101 206 0 1 0 15 15 15 eff.exe a03_442b.gif 4 29 0 1 0 15 15 15 * If Vicky wants to import the f isave 309 324 601 239 text1 textbox 309 324 601 239 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * You need to have Word's worksh notebox 22 364 291 ** eff.exe a03_444a.gif 280 447 0 1 0 15 15 15 eff.exe a03_444b.gif 4 201 0 1 0 15 15 15 * Then, instead of copying and p isave 309 244 601 171 text2 growbox 309 244 601 171 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 309 244 image memory text1 0 309 324 * eff.exe a03_445a.gif 9 447 0 1 0 15 15 15 * This displays the Import File isave 150 358 404 290 text1 textbox 150 358 404 290 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_446a.gif 428 366 0 1 0 15 15 15 * When she finds and selects the isave 150 295 404 222 text2 growbox 150 295 404 222 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 150 295 image memory text1 0 150 358 * eff.exe a03_447a.gif 9 435 0 1 0 15 15 15 * This opens the Import Data Opt isave 4 384 248 299 text1 textbox 4 384 248 299 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** qcall AW03q 030404 eff.exe a03_448.gif 0 459 0 1 0 15 15 15 * Vicky can also specify if she isave 4 304 248 231 text2 growbox 4 304 248 231 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_449a.gif 138 313 0 1 0 15 15 15 * She does this by clicking the isave 4 236 248 163 text3 growbox 4 236 248 163 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 4 236 image memory text2 0 4 304 image memory text1 0 4 384 * eff.exe a03_450a.gif 138 192 0 1 0 15 15 15 * As the correct options are alr isave 362 305 620 254 text1 textbox 362 305 620 254 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_451a.gif 12 434 0 1 0 15 15 15 eff.exe a03_451b.gif 294 434 0 1 0 15 15 15 eff.exe a03_451c.gif 12 344 0 1 0 15 15 15 eff.exe a03_451d.gif 60 344 0 1 0 15 15 15 * The data from the worksheet is isave 362 259 620 186 text2 growbox 362 259 620 186 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 362 259 image memory text1 0 362 305 * Simscrn 3 16 16 ********************************* eff.exe a03_452.gif 0 459 0 1 0 15 15 15 * Now that Vicky has the correct isave 36 371 266 286 text1 textbox 36 371 266 286 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_453a.gif 0 458 0 1 0 15 15 15 eff.exe a03_453b.gif 0 20 0 1 0 15 15 15 * She begins by clicking outside isave 36 291 266 218 text2 growbox 36 291 266 218 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 36 291 image memory text1 0 36 371 * eff.exe a03_454a.gif 106 430 0 1 0 15 15 15 eff.exe a03_454b.gif 4 358 0 1 0 15 15 15 * Vicky can move the chart by cl isave 323 303 597 252 text1 textbox 323 303 597 252 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_455a.gif 259 434 0 1 0 15 15 15 eff.exe a03_455b.gif 4 358 0 1 0 15 15 15 eff.exe a03_455c.gif 622 358 0 1 0 15 15 15 * She places it in the center of isave 323 257 597 218 text2 growbox 323 257 597 218 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 323 257 image memory text1 0 323 303 * eff.exe a03_456a.gif 259 359 0 1 0 15 15 15 eff.exe a03_456b.gif 4 15 0 1 0 15 15 15 * She then drags the handles at isave 37 399 286 331 text1 textbox 37 399 286 331 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_457a.gif 16 434 0 1 0 15 15 15 eff.exe a03_457b.gif 4 290 0 1 0 15 15 15 eff.exe a03_457c.gif 621 355 0 1 0 15 15 15 * And drags it until it fills th isave 37 336 286 297 text2 growbox 37 336 286 297 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 37 336 image memory text1 0 37 399 * eff.exe a03_458a.gif 532 359 0 1 0 15 15 15 eff.exe a03_458b.gif 137 194 0 1 0 15 15 15 * Vicky does not like the chart isave 4 459 313 408 text1 textbox 4 459 313 408 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_459.gif 0 459 0 1 0 15 15 15 * The sales columns hardly show, isave 4 413 313 340 text2 growbox 4 413 313 340 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** qcall AW03q 030405 eff.exe a03_460a.gif 137 258 0 1 0 15 15 15 * The scale 0-250,000 has been d isave 4 345 313 289 text3 growbox 4 345 313 289 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_461a.gif 153 258 0 1 0 15 15 15 eff.exe a03_461b.gif 395 102 0 1 0 15 15 15 * However, the highest figure in isave 4 294 313 221 text4 growbox 4 294 313 221 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 4 294 image memory text3 0 4 345 image memory text2 0 4 413 image memory text1 0 4 459 * eff.exe a03_462a.gif 0 458 0 1 0 15 15 15 * Vicky decides to remove the to isave 386 456 619 371 text1 textbox 386 456 619 371 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_463a.gif 153 334 0 1 0 15 15 15 eff.exe a03_463b.gif 17 148 0 1 0 15 15 15 * She then scrolls down to the c isave 386 376 619 269 text2 growbox 386 376 619 269 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_464a.gif 41 457 0 1 0 15 15 15 eff.exe a03_464b.gif 31 148 0 1 0 15 15 15 * She then selects Delete from t isave 386 274 619 218 text3 growbox 386 274 619 218 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 386 274 image memory text2 0 386 376 image memory text1 0 386 456 * eff.exe a03_465a.gif 7 457 0 1 0 15 15 15 eff.exe a03_465b.gif 41 457 0 1 0 15 15 15 eff.exe a03_465c.gif 7 42 0 1 0 15 15 15 eff.exe a03_465d.gif 41 42 0 1 0 15 15 15 * This opens the Delete dialog b isave 19 417 260 383 text1 textbox 19 417 260 383 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_466a.gif 191 316 0 1 0 15 15 15 eff.exe a03_466b.gif 7 42 0 1 0 15 15 15 eff.exe a03_466c.gif 191 42 0 1 0 15 15 15 * And Vicky makes her selection isave 19 388 260 315 text2 growbox 19 388 260 315 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 19 388 image memory text1 0 19 417 * eff.exe a03_467a.gif 16 316 0 1 0 15 15 15 * The totals data has been delet isave 22 454 264 386 text1 textbox 22 454 264 386 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_468.gif 0 459 0 1 0 15 15 15 * The scale on the Y axis of the isave 22 391 264 335 text2 growbox 22 391 264 335 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * The horizontal axis of a chart notebox 23 308 264 ** eff.exe a03_470a.gif 360 298 0 1 0 15 15 15 * Vicky is quite happy with the isave 22 340 264 250 text3 growbox 22 340 264 250 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 22 340 image memory text2 0 22 391 image memory text1 0 22 454 * eff.exe a03_471a.gif 10 434 0 1 0 15 15 15 * To change the chart type, Vick isave 11 436 287 368 text1 textbox 11 436 287 368 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_472a.gif 388 413 0 1 0 15 15 15 eff.exe a03_472b.gif 10 42 0 1 0 15 15 15 eff.exe a03_472c.gif 388 42 0 1 0 15 15 15 * She selects the Chart type she isave 11 373 287 317 text2 growbox 11 373 287 317 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe a03_473a.gif 128 434 0 1 0 15 15 15 eff.exe a03_473b.gif 10 42 0 1 0 15 15 15 eff.exe a03_473c.gif 128 42 0 1 0 15 15 15 * And the chart is immediately c isave 11 322 287 232 text3 growbox 11 322 287 232 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 11 322 image memory text2 0 11 373 image memory text1 0 11 436 *