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 / msoie / IE01.CTL < prev next >

Wrap

Text File | 1997-03-26 | 56.5 KB | 1,995 lines

SimScrn 1 1 14 MoveCtrl 1 490 408 0 0 eff.exe i01_101.gif 0 459 0 1 0 15 15 15 * In large worksheets it would b isave 38 282 298 214 text1 textbox 38 282 298 214 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_102a.gif 342 366 0 1 0 15 15 15 eff.exe i01_102b.gif 501 366 0 1 0 15 15 15 eff.exe i01_102c.gif 364 166 0 1 0 15 15 15 eff.exe i01_102d.gif 501 166 0 1 0 15 15 15 * Excel allows you to carry out isave 38 219 298 163 text2 growbox 38 219 298 163 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_103a.gif 364 158 0 1 0 15 15 15 eff.exe i01_103b.gif 458 147 0 1 0 15 15 15 eff.exe i01_103c.gif 458 74 0 1 0 15 15 15 * For example, you can move, cop isave 38 168 298 112 text3 growbox 38 168 298 112 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 38 168 image memory text2 0 38 219 image memory text1 0 38 282 * qcall IE01q 010101 eff.exe i01_104a.gif 0 456 0 1 0 15 15 15 * In Excel, a group of cells is isave 321 457 620 423 text1 textbox 321 457 620 423 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_105a.gif 2 408 0 1 0 15 15 15 eff.exe i01_105b.gif 623 343 0 1 0 15 15 15 * Before performing an operation isave 321 428 620 355 text2 growbox 321 428 620 355 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_106a.gif 542 375 0 1 0 15 15 15 eff.exe i01_106b.gif 148 288 0 1 0 15 15 15 * The easiest way to do this is isave 321 360 620 304 text3 growbox 321 360 620 304 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_107a.gif 154 375 0 1 0 15 15 15 eff.exe i01_107b.gif 2 229 0 1 0 15 15 15 eff.exe i01_107c.gif 154 240 0 1 0 15 15 15 * You click the top left-hand ce isave 321 309 620 253 text4 growbox 321 309 620 253 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_108a.gif 266 248 0 1 0 15 15 15 * Holding down the mouse button, isave 321 258 620 185 text5 growbox 321 258 620 185 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text5 0 321 258 image memory text4 0 321 309 image memory text3 0 321 360 image memory text2 0 321 428 image memory text1 0 321 457 * eff.exe i01_109a.gif 148 254 0 1 0 15 15 15 * Suppose you want to move the r isave 361 342 597 257 text1 textbox 361 342 597 257 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_110a.gif 148 254 0 1 0 15 15 15 * You place your cursor anywher isave 361 262 597 189 text2 growbox 361 262 597 189 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 361 262 image memory text1 0 361 342 eff.exe i01_111a.gif 2 345 0 1 0 15 15 15 eff.exe i01_111b.gif 623 343 0 1 0 15 15 15 eff.exe i01_111c.gif 2 16 0 1 0 15 15 15 eff.exe i01_111d.gif 623 16 0 1 0 15 15 15 * You move the shadow block isave 408 454 626 403 text1 textbox 408 454 626 403 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** qcall IE01q 010102 eff.exe i01_112a.gif 2 379 0 1 0 15 15 15 eff.exe i01_112b.gif 135 365 0 1 0 15 15 15 eff.exe i01_112c.gif 135 17 0 1 0 15 15 15 * If there is any data in the de isave 408 408 626 301 text2 growbox 408 408 626 301 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_113a.gif 155 196 0 1 0 15 15 15 * You click OK isave 408 306 626 267 text3 growbox 408 306 626 267 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 408 306 image memory text2 0 408 408 image memory text1 0 408 454 * eff.exe i01_114a.gif 2 427 0 1 0 15 15 15 eff.exe i01_114b.gif 2 16 0 1 0 15 15 15 * Let's say you want to copy the isave 325 460 638 409 text1 textbox 325 460 638 409 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_115a.gif 2 345 0 1 0 15 15 15 * You first select the range you isave 325 414 638 375 text2 growbox 325 414 638 375 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_116a.gif 20 434 0 1 0 15 15 15 eff.exe i01_116b.gif 7 16 0 1 0 15 15 15 * Then you click the Copy button isave 325 380 638 324 text3 growbox 325 380 638 324 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall IE01q 010103 eff.exe i01_117a.gif 2 434 0 1 0 15 15 15 eff.exe i01_117b.gif 623 343 0 1 0 15 15 15 * You hold down the Ctrl key and isave 325 329 638 273 text4 growbox 325 329 638 273 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_118a.gif 2 434 0 1 0 15 15 15 eff.exe i01_118b.gif 2 209 0 1 0 15 15 15 eff.exe i01_118c.gif 624 209 0 1 0 15 15 15 * Then you click the Paste butto isave 325 278 638 239 text5 growbox 325 278 638 239 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text5 0 325 278 image memory text4 0 325 329 image memory text3 0 325 380 image memory text2 0 325 414 image memory text1 0 325 460 * eff.exe i01_119a.gif 19 427 0 1 0 15 15 15 eff.exe i01_119b.gif 19 179 0 1 0 15 15 15 * Suppose you want to paste the isave 30 324 375 273 text1 textbox 30 324 375 273 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_120a.gif 82 113 0 1 0 15 15 15 * You first click the other she isave 30 278 375 239 text2 growbox 30 278 375 239 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_121a.gif 2 434 0 1 0 15 15 15 * In the top left-hand cell of t isave 30 244 375 188 text3 growbox 30 244 375 188 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_122a.gif 20 434 0 1 0 15 15 15 * Excel copies the headings to P isave 30 193 375 154 text4 growbox 30 193 375 154 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 30 193 image memory text3 0 30 244 image memory text2 0 30 278 image memory text1 0 30 324 * SimScrn 1 2 14 ********************************* MoveCtrl 1 493 460 0 eff.exe i01_125.gif 0 459 0 1 0 15 15 15 * Suppose you need to prepare a isave 11 216 310 148 text1 textbox 11 216 310 148 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_126a.gif 209 430 0 1 0 15 15 15 eff.exe i01_126b.gif 209 365 0 1 0 15 15 15 eff.exe i01_126c.gif 337 365 0 1 0 15 15 15 * Although you can make the chan isave 11 153 310 63 text2 growbox 11 153 310 63 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_127a.gif 188 430 0 1 0 15 15 15 eff.exe i01_127b.gif 188 92 0 1 0 15 15 15 * The Autoformat uses distinctiv isave 11 68 310 12 text3 growbox 11 68 310 12 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 11 68 image memory text2 0 11 153 image memory text1 0 11 216 * eff.exe i01_128a.gif 2 457 0 1 0 15 15 15 eff.exe i01_128b.gif 2 19 0 1 0 15 15 15 * To apply an Autoformat, you se isave 403 414 627 329 text1 textbox 403 414 627 329 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_129a.gif 20 457 0 1 0 15 15 15 eff.exe i01_129b.gif 436 198 0 1 0 15 15 15 * On the Format menu, you click isave 403 334 627 278 text2 growbox 403 334 627 278 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_130a.gif 20 457 0 1 0 15 15 15 * In the Table format box, you c isave 403 283 627 193 text3 growbox 403 283 627 193 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 403 283 image memory text2 0 403 334 image memory text1 0 403 414 * eff.exe i01_131a.gif 28 210 0 1 0 15 15 15 eff.exe i01_131b.gif 395 207 0 1 0 15 15 15 * Let's say you want to use only isave 33 330 322 279 text1 textbox 33 330 322 279 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_132a.gif 342 429 0 1 0 15 15 15 eff.exe i01_132b.gif 37 223 0 1 0 15 15 15 eff.exe i01_132c.gif 342 223 0 1 0 15 15 15 * To do this, you click Options isave 33 284 322 245 text2 growbox 33 284 322 245 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_133a.gif 26 238 0 1 0 15 15 15 * Then you click the check box t isave 33 250 322 177 text3 growbox 33 250 322 177 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_134a.gif 633 312 0 1 0 15 15 15 eff.exe i01_134b.gif 26 282 0 1 0 15 15 15 * Now you click OK to apply the isave 33 182 322 143 text4 growbox 33 182 322 143 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 33 182 image memory text3 0 33 250 image memory text2 0 33 284 image memory text1 0 33 330 eff.exe i01_135a.gif 265 429 0 1 0 15 15 15 eff.exe i01_135b.gif 633 429 0 1 0 15 15 15 eff.exe i01_135c.gif 2 365 0 1 0 15 15 15 eff.exe i01_135d.gif 633 365 0 1 0 15 15 15 * On the worksheet the new forma isave 397 150 598 82 text1 textbox 397 150 598 82 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 397 150 * eff.exe i01_136a.gif 222 338 0 1 0 15 15 15 * Suppose you now want to copy t isave 5 183 217 81 text1 textbox 5 183 217 81 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_137a.gif 229 434 0 1 0 15 15 15 eff.exe i01_137b.gif 19 338 0 1 0 15 15 15 * Remember that you have selecte isave 5 86 217 13 text2 growbox 5 86 217 13 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 5 86 image memory text1 0 5 183 * qcall IE01q 010104 eff.exe i01_138a.gif 19 434 0 1 0 15 15 15 eff.exe i01_138b.gif 510 434 0 1 0 15 15 15 eff.exe i01_138c.gif 7 16 0 1 0 15 15 15 eff.exe i01_138d.gif 510 16 0 1 0 15 15 15 * You click the Format Painter isave 26 156 319 105 text1 textbox 26 156 319 105 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_139a.gif 2 415 0 1 0 15 15 15 * Then you select the destinatio isave 26 110 319 54 text2 growbox 26 110 319 54 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_140a.gif 209 434 0 1 0 15 15 15 eff.exe i01_140b.gif 2 365 0 1 0 15 15 15 * When you press Enter, Excel copie isave 26 59 319 3 text3 growbox 26 59 319 3 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 26 59 image memory text2 0 26 110 image memory text1 0 26 156 * eff.exe i01_141a.gif 209 431 0 1 0 15 15 15 eff.exe i01_141b.gif 2 365 0 1 0 15 15 15 * Let's say you want to clear a isave 392 456 618 405 text1 textbox 392 456 618 405 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_142a.gif 209 431 0 1 0 15 15 15 eff.exe i01_142b.gif 2 365 0 1 0 15 15 15 * You first select the ran isave 392 410 618 354 text2 growbox 392 410 618 354 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_143a.gif 20 457 0 1 0 15 15 15 * Now you choose Edit - Cl isave 392 359 618 320 text3 growbox 392 359 618 320 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_144a.gif 79 443 0 1 0 15 15 15 eff.exe i01_144b.gif 49 310 0 1 0 15 15 15 * Then you click Formats isave 392 325 618 286 text4 growbox 392 325 618 286 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_145a.gif 2 457 0 1 0 15 15 15 * Microsoft Excel removes only t isave 392 291 618 235 text5 growbox 392 291 618 235 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text5 0 392 291 image memory text4 0 392 325 image memory text3 0 392 359 image memory text2 0 392 410 image memory text1 0 392 456 * SimScrn 1 3 14 ********************************* MoveCtrl 1 493 460 0 eff.exe i01_146.gif 0 459 0 1 0 15 15 15 * Let's suppose you have a fairl isave 368 454 623 369 text1 textbox 368 454 623 369 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** qcall IE01q 010105 eff.exe i01_147a.gif 85 434 0 1 0 15 15 15 eff.exe i01_147b.gif 311 365 0 1 0 15 15 15 * Excel allows you to print a se isave 368 374 623 318 text2 growbox 368 374 623 318 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall IE01q 010106 eff.exe i01_148a.gif 85 454 0 1 0 15 15 15 eff.exe i01_148b.gif 311 158 0 1 0 15 15 15 * The Print button only allows y isave 368 323 623 267 text3 growbox 368 323 623 267 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_149a.gif 2 457 0 1 0 15 15 15 eff.exe i01_149b.gif 336 430 0 1 0 15 15 15 eff.exe i01_149c.gif 2 16 0 1 0 15 15 15 eff.exe i01_149d.gif 336 16 0 1 0 15 15 15 * To print a selected range, you isave 368 272 623 216 text4 growbox 368 272 623 216 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 368 272 image memory text3 0 368 323 image memory text2 0 368 374 image memory text1 0 368 454 * eff.exe i01_150a.gif 2 457 0 1 0 15 15 15 eff.exe i01_150b.gif 336 430 0 1 0 15 15 15 eff.exe i01_150c.gif 2 16 0 1 0 15 15 15 eff.exe i01_150d.gif 336 16 0 1 0 15 15 15 * Since you need to print two ra isave 330 455 633 370 text1 textbox 330 455 633 370 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_151a.gif 2 457 0 1 0 15 15 15 eff.exe i01_151b.gif 336 430 0 1 0 15 15 15 * Next you choose File-Print isave 330 375 633 336 text2 growbox 330 375 633 336 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01a152a.gif 26 457 0 1 0 15 15 15 qcall IE01q 010107 eff.exe i01_152a.gif 85 434 0 1 0 15 15 15 eff.exe i01_152b.gif 49 365 0 1 0 15 15 15 eff.exe i01_152c.gif 324 365 0 1 0 15 15 15 * In the Print dialog box, you c isave 330 341 633 285 text3 growbox 330 341 633 285 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_153a.gif 221 365 0 1 0 15 15 15 eff.exe i01_153b.gif 51 179 0 1 0 15 15 15 eff.exe i01_153c.gif 229 121 0 1 0 15 15 15 * Then you click OK isave 330 290 633 251 text4 growbox 330 290 633 251 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 330 290 image memory text3 0 330 341 image memory text2 0 330 375 image memory text1 0 330 455 * eff.exe i01_154a.gif 45 430 0 1 0 15 15 15 eff.exe i01_154b.gif 2 350 0 1 0 15 15 15 * Each range you print begins on isave 371 456 635 405 text1 textbox 371 456 635 405 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_155a.gif 342 129 0 1 0 15 15 15 eff.exe i01_155b.gif 457 129 0 1 0 15 15 15 eff.exe i01_155c.gif 457 73 0 1 0 15 15 15 * If you'd like the ranges print isave 371 410 635 320 text2 growbox 371 410 635 320 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_156a.gif 2 434 0 1 0 15 15 15 eff.exe i01_156b.gif 153 434 0 1 0 15 15 15 eff.exe i01_156c.gif 153 17 0 1 0 15 15 15 * To do this, you click t isave 371 325 635 269 text3 growbox 371 325 635 269 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_157a.gif 2 434 0 1 0 15 15 15 eff.exe i01_157b.gif 2 16 0 1 0 15 15 15 * Then in an empty area of the w isave 371 274 635 201 text4 growbox 371 274 635 201 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 371 274 image memory text3 0 371 325 image memory text2 0 371 410 image memory text1 0 371 456 * eff.exe i01_158a.gif 2 434 0 1 0 15 15 15 eff.exe i01_158b.gif 419 17 0 1 0 15 15 15 * Now you select the entire area isave 362 323 612 272 text1 textbox 362 323 612 272 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_159a.gif 20 457 0 1 0 15 15 15 * Next you click File - Print isave 362 277 612 238 text2 growbox 362 277 612 238 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_160a.gif 27 457 0 1 0 15 15 15 * In the Print dialog box, you c isave 362 243 612 187 text3 growbox 362 243 612 187 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_161a.gif 230 429 0 1 0 15 15 15 eff.exe i01_161b.gif 51 179 0 1 0 15 15 15 eff.exe i01_161c.gif 230 121 0 1 0 15 15 15 * You click OK to print the rang isave 362 192 612 136 text4 growbox 362 192 612 136 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 362 192 image memory text3 0 362 243 image memory text2 0 362 277 image memory text1 0 362 323 * SimScrn 1 4 14 ********************************* MoveCtrl 1 493 460 0 eff.exe i01_162.gif 0 459 0 1 0 15 15 15 * Although using your cursor to isave 23 339 256 220 text1 textbox 23 339 256 220 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** qcall IE01q 010108 eff.exe i01_163a.gif 0 429 0 1 0 15 15 15 eff.exe i01_163b.gif 365 203 0 1 0 15 15 15 * Instances where you need to re isave 23 225 256 33 text2 growbox 23 225 256 33 showtext 0 0 11 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 23 339 * eff.exe i01_167a.gif 2 381 0 1 0 15 15 15 eff.exe i01_167b.gif 188 381 0 1 0 15 15 15 eff.exe i01_167c.gif 2 248 0 1 0 15 15 15 eff.exe i01_167d.gif 229 258 0 1 0 15 15 15 * Let's say you want to refer to isave 260 452 626 401 text1 textbox 260 452 626 401 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_168a.gif 0 428 0 1 0 15 15 15 eff.exe i01_168b.gif 0 267 0 1 0 15 15 15 eff.exe i01_168c.gif 332 304 0 1 0 15 15 15 * You enter the address of the c isave 260 406 626 350 text2 growbox 260 406 626 350 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_169a.gif 104 243 0 1 0 15 15 15 eff.exe i01_169b.gif 189 304 0 1 0 15 15 15 eff.exe i01_169c.gif 201 66 0 1 0 15 15 15 * You use a colon (:), and then isave 260 355 626 299 text3 growbox 260 355 626 299 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_170a.gif 0 428 0 1 0 15 15 15 * Similarly, the range of cells isave 260 304 626 248 text4 growbox 260 304 626 248 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 260 304 image memory text3 0 260 355 image memory text2 0 260 406 image memory text1 0 260 452 * qcall IE01q 010109 eff.exe i01_171a.gif 2 408 0 1 0 15 15 15 * All cells in column B are refe isave 430 436 607 385 text1 textbox 430 436 607 385 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** qcall IE01q 010110 eff.exe i01_172a.gif 9 408 0 1 0 15 15 15 * Similarly all cells in columns isave 430 390 607 300 text2 growbox 430 390 607 300 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 430 390 image memory text1 0 430 436 * SimScrn 1 5 14 ********************************* MoveCtrl 1 493 460 0 eff.exe i01_173.gif 0 459 0 1 0 15 15 15 * Excel uses special code which isave 32 183 280 115 text1 textbox 32 183 280 115 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall IE01q 010111 eff.exe i01_174a.gif 0 459 0 1 0 15 15 15 * Reference operators combine ra isave 32 120 280 47 text2 growbox 32 120 280 47 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 32 120 image memory text1 0 32 183 * eff.exe i01_175a.gif 466 177 0 1 0 15 15 15 * The operator you've used befor isave 15 455 283 404 text1 textbox 15 455 283 404 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_176a.gif 145 365 0 1 0 15 15 15 eff.exe i01_176b.gif 2 248 0 1 0 15 15 15 eff.exe i01_176c.gif 135 258 0 1 0 15 15 15 * It indicates a range of cells isave 15 409 283 370 text2 growbox 15 409 283 370 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** qcall IE01q 010112 eff.exe i01_177a.gif 466 177 0 1 0 15 15 15 * The Union operator (the comma) isave 15 375 283 319 text3 growbox 15 375 283 319 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_178a.gif 500 317 0 1 0 15 15 15 * For example, =SUM(B5,B8) refer isave 15 324 283 268 text4 growbox 15 324 283 268 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 15 324 image memory text3 0 15 375 image memory text2 0 15 409 image memory text1 0 15 455 * eff.exe i01_179a.gif 2 365 0 1 0 15 15 15 eff.exe i01_179b.gif 469 343 0 1 0 15 15 15 * The Intersection operator (the isave 169 447 428 379 text1 textbox 169 447 428 379 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_180a.gif 0 459 0 1 0 15 15 15 * For example, =SUM(B6:B15 B8:B1 isave 169 384 428 294 text2 growbox 169 384 428 294 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 169 384 image memory text1 0 169 447 * * Topic: Defining names Topic No.: 2 **** SimScrn 1 6 14 ********************************* MoveCtrl 1 493 460 0 eff.exe i01_201.gif 0 459 0 1 0 15 15 15 * Aside from using cell addresse isave 20 343 278 258 text1 textbox 20 343 278 258 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_202a.gif 285 376 0 1 0 15 15 15 * One advantage is that a meanin isave 20 263 278 173 text2 growbox 20 263 278 173 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_203a.gif 285 376 0 1 0 15 15 15 eff.exe i01_203b.gif 331 174 0 1 0 15 15 15 * You also decrease your data in isave 20 178 278 105 text3 growbox 20 178 278 105 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_204a.gif 0 459 0 1 0 15 15 15 * Range names that you create ca isave 20 110 278 37 text4 growbox 20 110 278 37 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 20 110 image memory text3 0 20 178 image memory text2 0 20 263 image memory text1 0 20 343 * qcall IE01q 010201 eff.exe i01_205a.gif 289 241 0 1 0 15 15 15 eff.exe i01_205b.gif 421 241 0 1 0 15 15 15 * Although Excel is flexible abo isave 9 246 274 178 text1 textbox 9 246 274 178 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_206a.gif 365 308 0 1 0 15 15 15 eff.exe i01_206b.gif 290 239 0 1 0 15 15 15 * You can use any combination of isave 9 183 274 93 text2 growbox 9 183 274 93 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_207a.gif 359 206 0 1 0 15 15 15 eff.exe i01_207b.gif 421 206 0 1 0 15 15 15 eff.exe i01_207c.gif 359 147 0 1 0 15 15 15 eff.exe i01_207d.gif 421 147 0 1 0 15 15 15 * The remaining characters in th isave 9 98 274 25 text3 growbox 9 98 274 25 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 9 98 image memory text2 0 9 183 image memory text1 0 9 246 * qcall IE01q 010202 eff.exe i01_208a.gif 290 247 0 1 0 15 15 15 * Microsoft Excel does not disti isave 41 257 251 172 text1 textbox 41 257 251 172 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_209a.gif 328 308 0 1 0 15 15 15 eff.exe i01_209b.gif 301 248 0 1 0 15 15 15 * This means that if you've crea isave 41 177 251 53 text2 growbox 41 177 251 53 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 41 177 image memory text1 0 41 257 * eff.exe i01_210a.gif 0 459 0 1 0 15 15 15 * Although range names can be up isave 32 193 337 142 text1 textbox 32 193 337 142 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_211a.gif 322 338 0 1 0 15 15 15 * It makes keying easier and nam isave 32 147 337 74 text2 growbox 32 147 337 74 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * Excel also uses a few names in notebox 75 339 292 ** image memory text2 0 32 147 image memory text1 0 32 193 * eff.exe i01_213a.gif 0 456 0 1 0 15 15 15 * An easy way of naming a range isave 383 323 615 255 text1 textbox 383 323 615 255 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_214a.gif 30 376 0 1 0 15 15 15 eff.exe i01_214b.gif 63 135 0 1 0 15 15 15 eff.exe i01_214c.gif 187 43 0 1 0 15 15 15 * Let's say you want to name a r isave 383 260 615 187 text2 growbox 383 260 615 187 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_215a.gif 0 381 0 1 0 15 15 15 * You highlight the range of cel isave 383 192 615 136 text3 growbox 383 192 615 136 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_216a.gif 8 383 0 1 0 15 15 15 eff.exe i01_216b.gif 0 111 0 1 0 15 15 15 * Next you click the Name box at isave 383 141 615 68 text4 growbox 383 141 615 68 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 383 141 image memory text3 0 383 192 image memory text2 0 383 260 image memory text1 0 383 323 * eff.exe i01_217a.gif 8 383 0 1 0 15 15 15 eff.exe i01_217b.gif 361 166 0 1 0 15 15 15 * Then you type the name for the isave 411 445 623 377 text1 textbox 411 445 623 377 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_218a.gif 0 383 0 1 0 15 15 15 eff.exe i01_218b.gif 361 166 0 1 0 15 15 15 * To see the new range names in isave 411 382 623 292 text2 growbox 411 382 623 292 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 411 382 image memory text1 0 411 445 * qcall IE01q 010203 eff.exe i01_219a.gif 0 373 0 1 0 15 15 15 * Excel allows you to automatica isave 408 153 608 68 text1 textbox 408 153 608 68 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 408 153 * eff.exe i01_220a.gif 0 408 0 1 0 15 15 15 eff.exe i01_220b.gif 0 18 0 1 0 15 15 15 * Suppose you want to use the to isave 383 452 628 384 text1 textbox 383 452 628 384 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall IE01q 010204 eff.exe i01_221a.gif 2 457 0 1 0 15 15 15 eff.exe i01_221b.gif 2 18 0 1 0 15 15 15 * To use the column labels as ra isave 383 389 628 299 text2 growbox 383 389 628 299 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_222a.gif 26 440 0 1 0 15 15 15 eff.exe i01_222b.gif 152 440 0 1 0 15 15 15 eff.exe i01_222c.gif 26 301 0 1 0 15 15 15 eff.exe i01_222d.gif 108 301 0 1 0 15 15 15 * Then you click Create isave 383 304 628 265 text3 growbox 383 304 628 265 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_223a.gif 70 457 0 1 0 15 15 15 * In this case, you click the To isave 383 270 628 197 text4 growbox 383 270 628 197 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_224a.gif 70 429 0 1 0 15 15 15 eff.exe i01_224b.gif 70 331 0 1 0 15 15 15 eff.exe i01_224c.gif 458 331 0 1 0 15 15 15 * Then you click OK isave 383 202 628 163 text5 growbox 383 202 628 163 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_225a.gif 0 429 0 1 0 15 15 15 eff.exe i01_225b.gif 0 383 0 1 0 15 15 15 eff.exe i01_225c.gif 458 383 0 1 0 15 15 15 * As before the names are listed isave 383 168 628 112 text6 growbox 383 168 628 112 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text6 0 383 168 image memory text5 0 383 202 image memory text4 0 383 270 image memory text3 0 383 304 image memory text2 0 383 389 image memory text1 0 383 452 * eff.exe i01_226a.gif 0 394 0 1 0 15 15 15 * In a large, complicated worksh isave 125 349 377 264 text1 textbox 125 349 377 264 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * Using Ctrl+G or F5 also has th notebox 152 236 346 ** image memory text1 0 125 349 * eff.exe i01_228a.gif 0 457 0 1 0 15 15 15 eff.exe i01_228b.gif 0 19 0 1 0 15 15 15 * To use the Go to command from isave 333 457 636 406 text1 textbox 333 457 636 406 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_229a.gif 2 457 0 1 0 15 15 15 eff.exe i01_229b.gif 493 201 0 1 0 15 15 15 * From the alphabetical drop-dow isave 333 411 636 338 text2 growbox 333 411 636 338 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_230a.gif 102 235 0 1 0 15 15 15 eff.exe i01_230b.gif 359 307 0 1 0 15 15 15 * Then you click OK isave 333 343 636 304 text3 growbox 333 343 636 304 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_231a.gif 2 429 0 1 0 15 15 15 eff.exe i01_231b.gif 2 17 0 1 0 15 15 15 * Excel highlights the relevant isave 333 309 636 270 text4 growbox 333 309 636 270 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 333 309 image memory text3 0 333 343 image memory text2 0 333 411 image memory text1 0 333 457 * qcall IE01q 010205 eff.exe i01_232a.gif 145 235 0 1 0 15 15 15 eff.exe i01_232b.gif 187 43 0 1 0 15 15 15 * Although a name that you creat isave 32 315 284 213 text1 textbox 32 315 284 213 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 32 315 * eff.exe i01_233a.gif 361 229 0 1 0 15 15 15 eff.exe i01_233b.gif 187 43 0 1 0 15 15 15 * Suppose you have several works isave 33 196 310 111 text1 textbox 33 196 310 111 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_234a.gif 172 394 0 1 0 15 15 15 eff.exe i01_234b.gif 361 229 0 1 0 15 15 15 * You need to create sheet level isave 33 116 310 43 text2 growbox 33 116 310 43 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 33 116 image memory text1 0 33 196 * eff.exe i01_235a.gif 5 408 0 1 0 15 15 15 eff.exe i01_235b.gif 2 227 0 1 0 15 15 15 * To create a sheet level range isave 383 412 620 344 text1 textbox 383 412 620 344 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_236a.gif 8 383 0 1 0 15 15 15 eff.exe i01_236b.gif 19 123 0 1 0 15 15 15 * Next you click the Name box isave 383 349 620 310 text2 growbox 383 349 620 310 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** qcall IE01q 010206 eff.exe i01_237a.gif 0 427 0 1 0 15 15 15 eff.exe i01_237b.gif 509 436 0 1 0 15 15 15 eff.exe i01_237c.gif 0 36 0 1 0 15 15 15 eff.exe i01_237d.gif 509 36 0 1 0 15 15 15 * You enter the sheet's name -DC isave 383 315 620 225 text3 growbox 383 315 620 225 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_238a.gif 0 394 0 1 0 15 15 15 eff.exe i01_238b.gif 361 166 0 1 0 15 15 15 * Then you press Enter isave 383 230 620 191 text4 growbox 383 230 620 191 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 383 230 image memory text3 0 383 315 image memory text2 0 383 349 image memory text1 0 383 412 * eff.exe i01_239a.gif 2 436 0 1 0 15 15 15 eff.exe i01_239b.gif 62 34 0 1 0 15 15 15 * When you write a formula that isave 27 197 270 95 text1 textbox 27 197 270 95 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_240a.gif 364 287 0 1 0 15 15 15 eff.exe i01_240b.gif 63 36 0 1 0 15 15 15 eff.exe i01_240c.gif 364 36 0 1 0 15 15 15 * If you use the name in a formu isave 27 100 270 10 text2 growbox 27 100 270 10 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 27 100 image memory text1 0 27 197 * eff.exe i01_241a.gif 363 286 0 1 0 15 15 15 eff.exe i01_241b.gif 363 220 0 1 0 15 15 15 eff.exe i01_241c.gif 405 220 0 1 0 15 15 15 * You can also refer to range na isave 10 190 285 139 text1 textbox 10 190 285 139 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_242a.gif 301 287 0 1 0 15 15 15 eff.exe i01_242b.gif 364 220 0 1 0 15 15 15 * The reference to the Expenses isave 10 144 285 54 text2 growbox 10 144 285 54 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 10 144 image memory text1 0 10 190 * SimScrn 1 7 14 ********************************* MoveCtrl 1 493 460 0 eff.exe i01_243.gif 0 459 0 1 0 15 15 15 * In some cases you may no longe isave 350 454 624 403 text1 textbox 350 454 624 403 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_244a.gif 2 457 0 1 0 15 15 15 eff.exe i01_244b.gif 62 34 0 1 0 15 15 15 * First you choose the Ins isave 350 408 624 352 text2 growbox 350 408 624 352 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_245a.gif 107 457 0 1 0 15 15 15 * In the Define Name dialog box, isave 350 357 624 284 text3 growbox 350 357 624 284 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_246a.gif 11 431 0 1 0 15 15 15 eff.exe i01_246b.gif 121 235 0 1 0 15 15 15 * Then you click the Delete butt isave 350 289 624 250 text4 growbox 350 289 624 250 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 350 289 image memory text3 0 350 357 image memory text2 0 350 408 image memory text1 0 350 454 * qcall IE01q 010207 eff.exe i01_247a.gif 2 436 0 1 0 15 15 15 eff.exe i01_247b.gif 62 34 0 1 0 15 15 15 * Clicking the Undo button after isave 21 162 316 111 text1 textbox 21 162 316 111 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** qcall IE01q 010208 eff.exe i01_248a.gif 161 420 0 1 0 15 15 15 eff.exe i01_248b.gif 485 235 0 1 0 15 15 15 * If the name is used in a isave 21 116 316 43 text2 growbox 21 116 316 43 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 21 116 image memory text1 0 21 162 * eff.exe i01_249a.gif 5 408 0 1 0 15 15 15 eff.exe i01_249b.gif 2 235 0 1 0 15 15 15 * Suppose you've defined a name isave 131 457 369 389 text1 textbox 131 457 369 389 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_250a.gif 2 436 0 1 0 15 15 15 eff.exe i01_250b.gif 62 34 0 1 0 15 15 15 * In the Define Name dialog box, isave 131 394 369 321 text2 growbox 131 394 369 321 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_251a.gif 56 233 0 1 0 15 15 15 eff.exe i01_251b.gif 50 121 0 1 0 15 15 15 * In the Refers to box, you then isave 131 326 369 270 text3 growbox 131 326 369 270 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_252a.gif 2 381 0 1 0 15 15 15 * Then you click OK isave 131 275 369 236 text4 growbox 131 275 369 236 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 131 275 image memory text3 0 131 326 image memory text2 0 131 394 image memory text1 0 131 457 * * Topic: Hands-on: Naming a range Topic No.: 3 **** SimScrn 1 8 14 ********************************* exercise 01 1 120 70 * MoveCtrl 1 493 460 0 * task 01 0101 400 317 238 3 50 67 5 5 pause 1 1 1 1 1 1 1 1 * * Topic: Using functions Topic No.: 4 **** SimScrn 1 9 14 ********************************* MoveCtrl 1 493 460 0 eff.exe i01_401.gif 0 459 0 1 0 15 15 15 * A function is a special pre-wr isave 31 386 286 301 text1 textbox 31 386 286 301 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_402a.gif 338 202 0 1 0 15 15 15 eff.exe i01_402b.gif 462 240 0 1 0 15 15 15 * Functions can be used alone or isave 31 306 286 250 text2 growbox 31 306 286 250 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 31 306 image memory text1 0 31 386 * eff.exe i01_403a.gif 290 344 0 1 0 15 15 15 * Most functions contain at leas isave 26 391 262 306 text1 textbox 26 391 262 306 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_404a.gif 334 205 0 1 0 15 15 15 * Arguments can be data, a range isave 26 311 262 238 text2 growbox 26 311 262 238 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_405a.gif 334 205 0 1 0 15 15 15 * Some arguments are required, o isave 26 243 262 170 text3 growbox 26 243 262 170 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 26 243 image memory text2 0 26 311 image memory text1 0 26 391 * eff.exe i01_406a.gif 0 459 0 1 0 15 15 15 * Using functions simplifies and isave 33 366 243 298 text1 textbox 33 366 243 298 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_407a.gif 0 459 0 1 0 15 15 15 * For example, instead of typing isave 33 303 243 230 text2 growbox 33 303 243 230 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * In all formulas and calculatio notebox 13 203 258 ** image memory text2 0 33 303 image memory text1 0 33 366 * eff.exe i01_409a.gif 251 302 0 1 0 15 15 15 * If you are familiar with the f isave 4 273 250 171 text1 textbox 4 273 250 171 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_410a.gif 0 459 0 1 0 15 15 15 * When you enter a function, Exc isave 4 176 250 120 text2 growbox 4 176 250 120 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_411a.gif 259 266 0 1 0 15 15 15 * It's a good idea to use lowerc isave 4 125 250 18 text3 growbox 4 125 250 18 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 4 125 image memory text2 0 4 176 image memory text1 0 4 273 * eff.exe i01_412a.gif 0 459 0 1 0 15 15 15 * Suppose you wanted to find the isave 95 413 338 345 text1 textbox 95 413 338 345 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_413a.gif 118 131 0 1 0 15 15 15 * Your cursor has to be in the c isave 95 350 338 277 text2 growbox 95 350 338 277 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_414a.gif 2 431 0 1 0 15 15 15 eff.exe i01_414b.gif 369 434 0 1 0 15 15 15 eff.exe i01_414c.gif 2 161 0 1 0 15 15 15 * You type = Max(Sales) at the f isave 95 282 338 226 text3 growbox 95 282 338 226 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_415a.gif 3 457 0 1 0 15 15 15 eff.exe i01_415b.gif 291 431 0 1 0 15 15 15 eff.exe i01_415c.gif 2 146 0 1 0 15 15 15 eff.exe i01_415d.gif 331 205 0 1 0 15 15 15 * Then you press Enter isave 95 231 338 192 text4 growbox 95 231 338 192 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 95 231 image memory text3 0 95 282 image memory text2 0 95 350 image memory text1 0 95 413 * eff.exe i01_416a.gif 28 457 0 1 0 15 15 15 eff.exe i01_416b.gif 2 116 0 1 0 15 15 15 eff.exe i01_416c.gif 331 205 0 1 0 15 15 15 * An easy way to calculate the A isave 356 253 611 168 text1 textbox 356 253 611 168 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_417a.gif 2 431 0 1 0 15 15 15 eff.exe i01_417b.gif 8 108 0 1 0 15 15 15 * Then you click the Formula Bar isave 356 173 611 117 text2 growbox 356 173 611 117 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_418a.gif 2 431 0 1 0 15 15 15 eff.exe i01_418b.gif 2 119 0 1 0 15 15 15 * Excel then returns an average isave 356 122 611 66 text3 growbox 356 122 611 66 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 356 122 image memory text2 0 356 173 image memory text1 0 356 253 * eff.exe i01_419a.gif 168 119 0 1 0 15 15 15 eff.exe i01_419b.gif 569 25 0 1 0 15 15 15 * movectrl 1 0 410 0 Excel 97 provides a AutoCalcul isave 296 187 624 119 text1 textbox 296 187 624 119 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_420a.gif 63 138 0 1 0 15 15 15 eff.exe i01_420b.gif 569 25 0 1 0 15 15 15 * You can use this feature to fi isave 296 124 624 68 text2 growbox 296 124 624 68 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 296 124 image memory text1 0 296 187 movectrl 1 493 460 0 * eff.exe i01_421a.gif 46 381 0 1 0 15 15 15 eff.exe i01_421b.gif 2 277 0 1 0 15 15 15 eff.exe i01_421c.gif 63 291 0 1 0 15 15 15 * To use the AutoCalculate featu isave 364 374 626 323 text1 textbox 364 374 626 323 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_422a.gif 26 350 0 1 0 15 15 15 eff.exe i01_422b.gif 26 291 0 1 0 15 15 15 * Then you right-click the Statu isave 364 328 626 272 text2 growbox 364 328 626 272 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_423a.gif 26 350 0 1 0 15 15 15 eff.exe i01_423b.gif 26 291 0 1 0 15 15 15 * Excel returns the minimum valu isave 364 277 626 221 text3 growbox 364 277 626 221 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 364 277 image memory text2 0 364 328 image memory text1 0 364 374 * SimScrn 1 10 14 ********************************* MoveCtrl 1 493 460 0 0 eff.exe i01_424.gif 0 459 0 1 0 15 15 15 * Although you may find it faste isave 3 450 258 331 text1 textbox 3 450 258 331 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_425c.gif 406 434 0 1 0 15 15 15 eff.exe i01_425d.gif 394 197 0 1 0 15 15 15 * Let's suppose that your compan isave 3 336 258 229 text2 growbox 3 336 258 229 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_426e.gif 2 379 0 1 0 15 15 15 eff.exe i01_426f.gif 187 430 0 1 0 15 15 15 eff.exe i01_426g.gif 2 179 0 1 0 15 15 15 eff.exe i01_426h.gif 185 197 0 1 0 15 15 15 * To do this, you click cell C10 isave 3 234 258 195 text3 growbox 3 234 258 195 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 3 234 image memory text2 0 3 336 image memory text1 0 3 450 eff.exe i01_427.gif 0 459 0 1 0 15 15 15 * You click the Paste Funct isave 29 455 269 404 text1 textbox 29 455 269 404 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * If you are not sure which func notebox 12 378 282 ** eff.exe i01_429a.gif 2 434 0 1 0 15 15 15 eff.exe i01_429b.gif 485 432 0 1 0 15 15 15 eff.exe i01_429c.gif 2 16 0 1 0 15 15 15 eff.exe i01_429d.gif 485 16 0 1 0 15 15 15 * In this case, you click Financ isave 29 409 269 353 text2 growbox 29 409 269 353 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_430a.gif 46 294 0 1 0 15 15 15 eff.exe i01_430b.gif 520 321 0 1 0 15 15 15 * You click the function named P isave 29 358 269 251 text3 growbox 29 358 269 251 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_431a.gif 34 345 0 1 0 15 15 15 eff.exe i01_431b.gif 46 345 0 1 0 15 15 15 * Then you click OK isave 29 256 269 217 text4 growbox 29 256 269 217 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 29 256 image memory text3 0 29 358 image memory text2 0 29 409 image memory text1 0 29 455 * eff.exe i01_432a.gif 0 430 0 1 0 15 15 15 eff.exe i01_432b.gif 0 384 0 1 0 15 15 15 * In the PMT dialog box , you ty isave 335 274 625 206 text1 textbox 335 274 625 206 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_433a.gif 89 430 0 1 0 15 15 15 eff.exe i01_433b.gif 70 182 0 1 0 15 15 15 eff.exe i01_433c.gif 449 127 0 1 0 15 15 15 * You press the Tab key, and you isave 335 211 625 138 text2 growbox 335 211 625 138 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_434a.gif 88 381 0 1 0 15 15 15 eff.exe i01_434b.gif 71 222 0 1 0 15 15 15 * Next you click the cell addres isave 335 143 625 70 text3 growbox 335 143 625 70 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 335 143 image memory text2 0 335 211 image memory text1 0 335 274 * qcall IE01q 010301 eff.exe i01_435a.gif 57 356 0 1 0 15 15 15 eff.exe i01_435b.gif 350 412 0 1 0 15 15 15 * The Paste Function displays al isave 1 457 301 389 text1 textbox 1 457 301 389 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_436a.gif 16 356 0 1 0 15 15 15 eff.exe i01_436b.gif 350 412 0 1 0 15 15 15 * This means you don't have to f isave 1 394 301 338 text2 growbox 1 394 301 338 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 1 394 image memory text1 0 1 457 * eff.exe i01_437a.gif 16 309 0 1 0 15 15 15 * Excel automatically returns th isave 352 438 628 387 text1 textbox 352 438 628 387 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_438a.gif 210 174 0 1 0 15 15 15 * Then you click OK to have the isave 352 392 628 336 text2 growbox 352 392 628 336 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_439a.gif 0 434 0 1 0 15 15 15 eff.exe i01_439b.gif 558 432 0 1 0 15 15 15 eff.exe i01_439c.gif 0 16 0 1 0 15 15 15 eff.exe i01_439d.gif 558 16 0 1 0 15 15 15 * You can copy the formula to th isave 352 341 628 268 text3 growbox 352 341 628 268 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 352 341 image memory text2 0 352 392 image memory text1 0 352 438 * eff.exe i01_440a.gif 2 434 0 1 0 15 15 15 eff.exe i01_440b.gif 188 434 0 1 0 15 15 15 eff.exe i01_440c.gif 2 179 0 1 0 15 15 15 eff.exe i01_440d.gif 126 280 0 1 0 15 15 15 * The Paste Function can also be isave 34 113 272 62 text1 textbox 34 113 272 62 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 34 113 * eff.exe i01_441a.gif 355 434 0 1 0 15 15 15 eff.exe i01_441b.gif 109 280 0 1 0 15 15 15 * Let's say that you want to see isave 311 453 626 385 text1 textbox 311 453 626 385 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_442a.gif 2 408 0 1 0 15 15 15 eff.exe i01_442b.gif 484 408 0 1 0 15 15 15 eff.exe i01_442c.gif 2 194 0 1 0 15 15 15 * You copy the formula to cell C isave 311 390 626 351 text2 growbox 311 390 626 351 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_443a.gif 2 430 0 1 0 15 15 15 eff.exe i01_443b.gif 484 408 0 1 0 15 15 15 eff.exe i01_443c.gif 2 16 0 1 0 15 15 15 eff.exe i01_443d.gif 484 16 0 1 0 15 15 15 * Then you click the Edit Formul isave 311 356 626 317 text3 growbox 311 356 626 317 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 311 356 image memory text2 0 311 390 image memory text1 0 311 453 * eff.exe i01_444a.gif 0 431 0 1 0 15 15 15 eff.exe i01_444b.gif 558 432 0 1 0 15 15 15 eff.exe i01_444c.gif 0 16 0 1 0 15 15 15 eff.exe i01_444d.gif 558 16 0 1 0 15 15 15 * In the Paste Function dialog b isave 386 373 633 322 text1 textbox 386 373 633 322 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_445a.gif 88 339 0 1 0 15 15 15 eff.exe i01_445b.gif 69 231 0 1 0 15 15 15 * Now you click OK isave 386 327 633 288 text2 growbox 386 327 633 288 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_446a.gif 0 431 0 1 0 15 15 15 eff.exe i01_446b.gif 558 432 0 1 0 15 15 15 eff.exe i01_446c.gif 0 16 0 1 0 15 15 15 eff.exe i01_446d.gif 558 16 0 1 0 15 15 15 * Excel displays the result of t isave 386 293 633 237 text3 growbox 386 293 633 237 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 386 293 image memory text2 0 386 327 image memory text1 0 386 373 * * Topic: Hands-on: Using the MAX functions Topic No.: 5 **** SimScrn 1 11 14 ********************************* exercise 02 1 120 70 * MoveCtrl 1 493 460 0 * task 02 0102 400 317 238 3 50 67 5 5 *task 02 0102 400 317 238 3 50 67 5 5 * pause 1 1 1 1 1 1 1 1 * * * Topic: Sorting Topic No.: 6 **** SimScrn 1 12 14 ********************************* MoveCtrl 1 493 460 0 eff.exe i01_601.gif 0 459 0 1 0 15 15 15 * Sorting a list involves rearra isave 123 388 410 303 text1 textbox 123 388 410 303 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** qcall IE01q 010401 eff.exe i01_602a.gif 390 113 0 1 0 15 15 15 eff.exe i01_602b.gif 436 133 0 1 0 15 15 15 * Excel sorts text from left to isave 123 308 410 252 text2 growbox 123 308 410 252 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_603a.gif 349 188 0 1 0 15 15 15 * For example, if a cell contain isave 123 257 410 167 text3 growbox 123 257 410 167 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 123 257 image memory text2 0 123 308 image memory text1 0 123 388 * qcall IE01q 010402 eff.exe i01_604a.gif 349 188 0 1 0 15 15 15 * You can sort lists in ascendin isave 162 291 387 223 text1 textbox 162 291 387 223 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 162 291 * eff.exe i01_605a.gif 0 456 0 1 0 15 15 15 * Let's suppose that the salespe isave 376 381 637 313 text1 textbox 376 381 637 313 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_606a.gif 143 21 0 1 0 15 15 15 * You now want to sort the Last isave 376 318 637 228 text2 growbox 376 318 637 228 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** qcall IE01q 010403 eff.exe i01_607a.gif 2 430 0 1 0 15 15 15 * To sort the name column in alp isave 376 233 637 143 text3 growbox 376 233 637 143 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_608a.gif 13 434 0 1 0 15 15 15 eff.exe i01_608b.gif 430 434 0 1 0 15 15 15 eff.exe i01_608c.gif 13 302 0 1 0 15 15 15 * Remember that the active cell isave 376 148 637 75 text4 growbox 376 148 637 75 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * Unless you select both the nam notebox 55 184 320 ** image memory text4 0 376 148 image memory text3 0 376 233 image memory text2 0 376 318 image memory text1 0 376 381 * eff.exe i01_610a.gif 13 323 0 1 0 15 15 15 eff.exe i01_610b.gif 328 414 0 1 0 15 15 15 * Since you want to sort by name isave 383 194 613 126 text1 textbox 383 194 613 126 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_611a.gif 13 323 0 1 0 15 15 15 eff.exe i01_611b.gif 246 414 0 1 0 15 15 15 * Your salespersons' names now a isave 383 131 613 75 text2 growbox 383 131 613 75 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 383 131 image memory text1 0 383 194 * SimScrn 1 13 14 ********************************* MoveCtrl 1 493 460 0 eff.exe i01_612.gif 0 459 0 1 0 15 15 15 * In Excel, you can also perform isave 4 457 276 355 text1 textbox 4 457 276 355 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_613a.gif 2 430 0 1 0 15 15 15 eff.exe i01_613b.gif 2 305 0 1 0 15 15 15 * To do this multiple sort, you isave 4 360 276 304 text2 growbox 4 360 276 304 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 4 360 image memory text1 0 4 457 * eff.exe i01_614a.gif 13 459 0 1 0 15 15 15 * Instead of using the Sort butt isave 403 288 624 203 text1 textbox 403 288 624 203 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_615a.gif 2 459 0 1 0 15 15 15 * Click Sold to date in the Sort isave 403 208 624 152 text2 growbox 403 208 624 152 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_616a.gif 40 297 0 1 0 15 15 15 * You'll notice that Last Names isave 403 157 624 67 text3 growbox 403 157 624 67 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 403 157 image memory text2 0 403 208 image memory text1 0 403 288 * eff.exe i01_617a.gif 2 381 0 1 0 15 15 15 eff.exe i01_617b.gif 7 16 0 1 0 15 15 15 * To sort in descending order, y isave 359 167 611 99 text1 textbox 359 167 611 99 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 359 167 * eff.exe i01_618a.gif 2 429 0 1 0 15 15 15 eff.exe i01_618b.gif 2 381 0 1 0 15 15 15 * In column G, the actual sales isave 159 167 447 116 text1 textbox 159 167 447 116 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_619a.gif 430 434 0 1 0 15 15 15 eff.exe i01_619b.gif 2 365 0 1 0 15 15 15 * In column A, the salespersons' isave 159 121 447 65 text2 growbox 159 121 447 65 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 159 121 image memory text1 0 159 167 * qcall IE01q 010404 eff.exe i01_620a.gif 13 323 0 1 0 15 15 15 * Excel will, by default, sort a isave 323 282 611 248 text1 textbox 323 282 611 248 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_621a.gif 2 434 0 1 0 15 15 15 * Suppose you need to sort month isave 323 253 611 180 text2 growbox 323 253 611 180 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_622a.gif 28 348 0 1 0 15 15 15 eff.exe i01_622b.gif 103 310 0 1 0 15 15 15 * To do this, you use a custom s isave 323 185 611 146 text3 growbox 323 185 611 146 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 323 185 image memory text2 0 323 253 image memory text1 0 323 282 * eff.exe i01_623a.gif 29 333 0 1 0 15 15 15 eff.exe i01_623b.gif 232 457 0 1 0 15 15 15 * You choose Data - Sort isave 406 202 610 168 text1 textbox 406 202 610 168 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_624a.gif 6 457 0 1 0 15 15 15 * In the Sort dialog box, you cl isave 406 173 610 117 text2 growbox 406 173 610 117 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_625a.gif 411 429 0 1 0 15 15 15 eff.exe i01_625b.gif 6 347 0 1 0 15 15 15 * Next you click First key sort isave 406 122 610 66 text3 growbox 406 122 610 66 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 406 122 image memory text2 0 406 173 image memory text1 0 406 202 * eff.exe i01_626a.gif 100 288 0 1 0 15 15 15 * In the drop-down list displaye isave 369 432 625 381 text1 textbox 369 432 625 381 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_627a.gif 26 429 0 1 0 15 15 15 eff.exe i01_627b.gif 91 429 0 1 0 15 15 15 eff.exe i01_627c.gif 26 350 0 1 0 15 15 15 eff.exe i01_627d.gif 91 350 0 1 0 15 15 15 * Then you click OK isave 369 386 625 347 text2 growbox 369 386 625 347 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_628a.gif 26 429 0 1 0 15 15 15 eff.exe i01_628b.gif 91 429 0 1 0 15 15 15 eff.exe i01_628c.gif 26 350 0 1 0 15 15 15 eff.exe i01_628d.gif 91 350 0 1 0 15 15 15 * And you click OK to close the isave 369 352 625 296 text3 growbox 369 352 625 296 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe i01_629a.gif 411 429 0 1 0 15 15 15 eff.exe i01_629b.gif 15 381 0 1 0 15 15 15 * The months are now sorted in t isave 369 301 625 245 text4 growbox 369 301 625 245 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 369 301 image memory text3 0 369 352 image memory text2 0 369 386 image memory text1 0 369 432 * * * Topic: Hands-on: Sorting data Topic No.: 7 **** SimScrn 1 14 14 ********************************* exercise 03 1 120 70 * MoveCtrl 1 493 460 0 * task 03 0103 400 317 238 6 50 67 5 5 *task 03 0103 400 317 238 5 50 67 5 5 * pause 1 1 1 1 1 1 1 1