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 / msobe / BE04.CTL < prev next >

Wrap

Text File | 1997-03-26 | 33.8 KB | 1,174 lines

* SimScrn 4 1 7 MoveCtrl 1 493 410 0 ********************************* * Course: Beginning Excel 97 * Unit: Formulas Unit No.:04 * Topic: Creating formulas Topic No.: 1 **** eff.exe b04_101.gif 0 459 0 1 0 15 15 15 * Formulas are the engines of sp isave 195 243 482 192 text1 textbox 195 243 482 192 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_102a.gif 2 431 0 1 0 15 15 15 eff.exe b04_102b.gif 558 432 0 1 0 15 15 15 eff.exe b04_102c.gif 2 16 0 1 0 15 15 15 eff.exe b04_102d.gif 558 16 0 1 0 15 15 15 * If they are incorrect, the int isave 195 197 482 141 text2 growbox 195 197 482 141 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 195 197 image memory text1 0 195 243 * eff.exe b04_103a.gif 2 431 0 1 0 15 15 15 eff.exe b04_103b.gif 558 432 0 1 0 15 15 15 eff.exe b04_103c.gif 2 16 0 1 0 15 15 15 eff.exe b04_103d.gif 558 16 0 1 0 15 15 15 * A formula can consist of sever isave 363 341 611 273 text1 textbox 363 341 611 273 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_104a.gif 24 354 0 1 0 15 15 15 eff.exe b04_104b.gif 139 394 0 1 0 15 15 15 * You can follow the equal sign isave 363 278 611 205 text2 growbox 363 278 611 205 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_105.gif 0 459 0 1 0 15 15 15 *eff.exe b04_105a.gif 24 430 0 1 0 15 15 15 *eff.exe b04_105b.gif 24 394 0 1 0 15 15 15 *eff.exe b04_105c.gif 531 365 0 1 0 15 15 15 * ≥ functions, such as SU isave 363 210 611 171 text3 growbox 363 210 611 171 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_106a.gif 205 336 0 1 0 15 15 15 eff.exe b04_106b.gif 270 332 0 1 0 15 15 15 * ≥ parenthese isave 363 176 611 137 text4 growbox 363 176 611 137 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_107a.gif 28 430 0 1 0 15 15 15 eff.exe b04_107b.gif 28 394 0 1 0 15 15 15 eff.exe b04_107c.gif 531 365 0 1 0 15 15 15 * ≥ and other component isave 363 142 611 103 text5 growbox 363 142 611 103 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text5 0 363 142 image memory text4 0 363 176 image memory text3 0 363 210 image memory text2 0 363 278 image memory text1 0 363 341 * eff.exe b04_108a.gif 129 394 0 1 0 15 15 15 * Excel 97 gives you various way isave 418 405 628 337 text1 textbox 418 405 628 337 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_109a.gif 129 372 0 1 0 15 15 15 * The most common way of enterin isave 418 342 628 269 text2 growbox 418 342 628 269 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_110a.gif 2 431 0 1 0 15 15 15 eff.exe b04_110b.gif 558 432 0 1 0 15 15 15 eff.exe b04_110c.gif 2 16 0 1 0 15 15 15 eff.exe b04_110d.gif 558 16 0 1 0 15 15 15 * For example, to find the total isave 418 274 628 184 text3 growbox 418 274 628 184 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_111a.gif 295 394 0 1 0 15 15 15 * Although this works, it is not isave 418 189 628 99 text4 growbox 418 189 628 99 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 418 189 image memory text3 0 418 274 image memory text2 0 418 342 image memory text1 0 418 405 * eff.exe b04_112a.gif 2 431 0 1 0 15 15 15 eff.exe b04_112b.gif 558 432 0 1 0 15 15 15 eff.exe b04_112c.gif 2 16 0 1 0 15 15 15 eff.exe b04_112d.gif 558 16 0 1 0 15 15 15 * As you type, the characters ap isave 318 295 601 244 text1 textbox 318 295 601 244 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * The Formula bar is to the righ notebox 360 216 574 ** eff.exe b04_114a.gif 129 399 0 1 0 15 15 15 * You can use all the normal edi isave 318 249 601 176 text2 growbox 318 249 601 176 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 318 249 image memory text1 0 318 295 * eff.exe b04_115a.gif 2 431 0 1 0 15 15 15 eff.exe b04_115b.gif 558 432 0 1 0 15 15 15 eff.exe b04_115c.gif 2 16 0 1 0 15 15 15 eff.exe b04_115d.gif 558 16 0 1 0 15 15 15 * Another way to add a group of isave 162 203 477 152 text1 textbox 162 203 477 152 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_116a.gif 0 434 0 1 0 15 15 15 eff.exe b04_116b.gif 558 432 0 1 0 15 15 15 eff.exe b04_116c.gif 0 16 0 1 0 15 15 15 eff.exe b04_116d.gif 558 16 0 1 0 15 15 15 * To type the same formula =B3+B isave 162 157 477 101 text2 growbox 162 157 477 101 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_117a.gif 0 434 0 1 0 15 15 15 eff.exe b04_117b.gif 558 432 0 1 0 15 15 15 eff.exe b04_117c.gif 0 16 0 1 0 15 15 15 eff.exe b04_117d.gif 558 16 0 1 0 15 15 15 * In this case SUM is the functi isave 162 106 477 67 text3 growbox 162 106 477 67 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_118a.gif 174 394 0 1 0 15 15 15 * The range of cells to be summe isave 162 72 477 16 text4 growbox 162 72 477 16 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 162 72 image memory text3 0 162 106 image memory text2 0 162 157 image memory text1 0 162 203 * qcall BE04q 040101 eff.exe b04_119a.gif 194 393 0 1 0 15 15 15 * The cell addresses are separat isave 352 339 602 288 text1 textbox 352 339 602 288 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_120a.gif 194 389 0 1 0 15 15 15 * However, you can use a comma i isave 352 293 602 237 text2 growbox 352 293 602 237 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_121.gif 0 459 0 1 0 15 15 15 *eff.exe b04_121a.gif 53 426 0 1 0 15 15 15 *eff.exe b04_121b.gif 2 389 0 1 0 15 15 15 *eff.exe b04_121c.gif 53 389 0 1 0 15 15 15 * Commas indicate individual cel isave 352 242 602 169 text3 growbox 352 242 602 169 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 352 242 image memory text2 0 352 293 image memory text1 0 352 339 * eff.exe b04_121.gif 0 459 0 1 0 15 15 15 *eff.exe b04_122a.gif 2 431 0 1 0 15 15 15 *eff.exe b04_122b.gif 558 432 0 1 0 15 15 15 *eff.exe b04_122c.gif 2 16 0 1 0 15 15 15 *eff.exe b04_122d.gif 558 16 0 1 0 15 15 15 * You don't have to worry about isave 365 331 604 263 text1 textbox 365 331 604 263 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_123.gif 0 459 0 1 0 15 15 15 *eff.exe b04_123a.gif 2 431 0 1 0 15 15 15 *eff.exe b04_123b.gif 558 432 0 1 0 15 15 15 *eff.exe b04_123c.gif 2 16 0 1 0 15 15 15 *eff.exe b04_123d.gif 558 16 0 1 0 15 15 15 * As soon as you press Enter or isave 365 268 604 195 text2 growbox 365 268 604 195 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 365 268 image memory text1 0 365 331 * eff.exe b04_124a.gif 176 397 0 1 0 15 15 15 eff.exe b04_124b.gif 81 317 0 1 0 15 15 15 * In addition to typing formulas isave 291 256 607 188 text1 textbox 291 256 607 188 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_125a.gif 30 317 0 1 0 15 15 15 * After entering an operator, Ex isave 291 193 607 120 text2 growbox 291 193 607 120 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 291 193 image memory text1 0 291 256 * eff.exe b04_126a.gif 2 431 0 1 0 15 15 15 eff.exe b04_126b.gif 558 432 0 1 0 15 15 15 eff.exe b04_126c.gif 2 16 0 1 0 15 15 15 eff.exe b04_126d.gif 558 16 0 1 0 15 15 15 * To add cells C1 to C9 as well isave 388 453 631 385 text1 textbox 388 453 631 385 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_127a.gif 139 430 0 1 0 15 15 15 eff.exe b04_127b.gif 8 19 0 1 0 15 15 15 eff.exe b04_127c.gif 139 19 0 1 0 15 15 15 * You then click cell C1 while h isave 388 390 631 317 text2 growbox 388 390 631 317 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_128a.gif 28 457 0 1 0 15 15 15 eff.exe b04_128b.gif 139 399 0 1 0 15 15 15 * Excel automatically places the isave 388 322 631 266 text3 growbox 388 322 631 266 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_129a.gif 2 457 0 1 0 15 15 15 eff.exe b04_129b.gif 558 432 0 1 0 15 15 15 eff.exe b04_129c.gif 2 16 0 1 0 15 15 15 eff.exe b04_129d.gif 558 16 0 1 0 15 15 15 * When you have finished enterin isave 388 271 631 147 text4 growbox 388 271 631 147 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_130a.gif 240 411 0 1 0 15 15 15 * Excel automatically calculates isave 388 152 631 96 text5 growbox 388 152 631 96 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * If you don't type the first pa notebox 108 273 375 ** image memory text5 0 388 152 image memory text4 0 388 271 image memory text3 0 388 322 image memory text2 0 388 390 image memory text1 0 388 453 * eff.exe b04_132a.gif 51 426 0 1 0 15 15 15 eff.exe b04_132b.gif 2 395 0 1 0 15 15 15 eff.exe b04_132c.gif 51 395 0 1 0 15 15 15 * Operator precedence is the set isave 352 345 615 277 text1 textbox 352 345 615 277 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_133a.gif 67 395 0 1 0 15 15 15 * In the simple arithmetic formu isave 352 282 615 175 text2 growbox 352 282 615 175 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_134a.gif 222 381 0 1 0 15 15 15 eff.exe b04_134b.gif 104 344 0 1 0 15 15 15 eff.exe b04_134c.gif 227 344 0 1 0 15 15 15 * ≥ division (/) before addition isave 352 180 615 141 text3 growbox 352 180 615 141 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_135a.gif 213 381 0 1 0 15 15 15 eff.exe b04_135b.gif 104 344 0 1 0 15 15 15 eff.exe b04_135c.gif 236 344 0 1 0 15 15 15 * ≥ addition (+) before subtract isave 352 146 615 90 text4 growbox 352 146 615 90 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 352 146 image memory text3 0 352 180 image memory text2 0 352 282 image memory text1 0 352 345 * eff.exe b04_136a.gif 119 327 0 1 0 15 15 15 eff.exe b04_136b.gif 197 381 0 1 0 15 15 15 eff.exe b04_136c.gif 181 242 0 1 0 15 15 15 * You can override operator prec isave 138 199 441 148 text1 textbox 138 199 441 148 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_137a.gif 171 381 0 1 0 15 15 15 eff.exe b04_137b.gif 93 327 0 1 0 15 15 15 eff.exe b04_137c.gif 171 323 0 1 0 15 15 15 * If an addition or subtraction isave 138 153 441 80 text2 growbox 138 153 441 80 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 138 153 image memory text1 0 138 199 * * Topic: Hands-on: Entering a formula Topic No.: 2 **** SimScrn 4 2 7 MoveCtrl 1 493 410 0 ********************************* * MoveCtrl 1 493 500 0 * exercise 01 1 120 70 task 01 0101 402 300 235 3 120 67 35 75 * pause 1 1 1 1 1 1 1 1 * Topic: Automatic features and filling formulas Topic No.: 3 **** SimScrn 4 3 7 MoveCtrl 1 493 410 0 ********************************* eff.exe b04_301.gif 0 459 0 1 0 15 15 15 * The AutoSum feature allows you isave 297 261 567 193 text1 textbox 297 261 567 193 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_302a.gif 2 444 0 1 0 15 15 15 eff.exe b04_302b.gif 591 432 0 1 0 15 15 15 eff.exe b04_302c.gif 2 16 0 1 0 15 15 15 eff.exe b04_302d.gif 591 16 0 1 0 15 15 15 * When you click on the AutoSum isave 297 198 567 91 text2 growbox 297 198 567 91 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_303a.gif 2 434 0 1 0 15 15 15 eff.exe b04_303b.gif 591 432 0 1 0 15 15 15 eff.exe b04_303c.gif 2 16 0 1 0 15 15 15 eff.exe b04_303d.gif 591 16 0 1 0 15 15 15 * You press Enter to sum the cel isave 297 96 567 57 text3 growbox 297 96 567 57 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 297 96 image memory text2 0 297 198 image memory text1 0 297 261 * eff.exe b04_304.gif 0 459 0 1 0 15 15 15 *eff.exe b04_304a.gif 2 434 0 1 0 15 15 15 *eff.exe b04_304b.gif 557 432 0 1 0 15 15 15 *eff.exe b04_304c.gif 2 19 0 1 0 15 15 15 *eff.exe b04_304d.gif 557 19 0 1 0 15 15 15 * If the correct cells are alrea isave 288 300 628 249 text1 textbox 288 300 628 249 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** qcall BE04q 040301 eff.exe b04_305.gif 0 459 0 1 0 15 15 15 *eff.exe b04_305a.gif 2 379 0 1 0 15 15 15 *eff.exe b04_305b.gif 164 434 0 1 0 15 15 15 *eff.exe b04_305c.gif 164 19 0 1 0 15 15 15 * When there are cells both to t isave 288 254 628 164 text2 growbox 288 254 628 164 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_306.gif 0 459 0 1 0 15 15 15 *eff.exe b04_306a.gif 28 348 0 1 0 15 15 15 *eff.exe b04_306b.gif 397 415 0 1 0 15 15 15 *eff.exe b04_306c.gif 11 16 0 1 0 15 15 15 *eff.exe b04_306d.gif 397 16 0 1 0 15 15 15 * AutoSum automatically totals t isave 288 169 628 113 text3 growbox 288 169 628 113 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_307a.gif 21 267 0 1 0 15 15 15 * You would have to drag the mou isave 288 118 628 62 text4 growbox 288 118 628 62 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 288 118 image memory text3 0 288 169 image memory text2 0 288 254 image memory text1 0 288 300 * eff.exe b04_308a.gif 2 434 0 1 0 15 15 15 * If you have a table surrounded isave 193 159 434 91 text1 textbox 193 159 434 91 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 193 159 * eff.exe b04_309a.gif 48 430 0 1 0 15 15 15 eff.exe b04_309b.gif 2 272 0 1 0 15 15 15 eff.exe b04_309c.gif 76 274 0 1 0 15 15 15 * To select the entire table, cl isave 412 215 621 164 text1 textbox 412 215 621 164 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** qcall BE04q 040302 eff.exe b04_310a.gif 2 379 0 1 0 15 15 15 eff.exe b04_310b.gif 84 381 0 1 0 15 15 15 eff.exe b04_310c.gif 84 19 0 1 0 15 15 15 * You then press Ctrl+* and the isave 412 169 621 113 text2 growbox 412 169 621 113 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_311a.gif 2 434 0 1 0 15 15 15 eff.exe b04_311b.gif 2 19 0 1 0 15 15 15 * You click AutoSum to total all isave 412 118 621 62 text3 growbox 412 118 621 62 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 412 118 image memory text2 0 412 169 image memory text1 0 412 215 * eff.exe b04_312a.gif 2 434 0 1 0 15 15 15 eff.exe b04_312b.gif 384 87 0 1 0 15 15 15 * The AutoCalculate feature is h isave 32 208 289 106 text1 textbox 32 208 289 106 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_313a.gif 36 379 0 1 0 15 15 15 eff.exe b04_313b.gif 156 376 0 1 0 15 15 15 eff.exe b04_313c.gif 384 214 0 1 0 15 15 15 * When you right-click the runni isave 32 111 289 38 text2 growbox 32 111 289 38 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * The default for AutoCalculate notebox 32 305 254 ** image memory text2 0 32 111 image memory text1 0 32 208 * eff.exe b04_315a.gif 211 376 0 1 0 15 15 15 eff.exe b04_315b.gif 425 214 0 1 0 15 15 15 * The AutoCalculate menu allows isave 16 241 326 173 text1 textbox 16 241 326 173 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_316a.gif 466 186 0 1 0 15 15 15 eff.exe b04_316b.gif 605 186 0 1 0 15 15 15 eff.exe b04_316c.gif 605 51 0 1 0 15 15 15 * ≥ count the number of cells hi isave 16 178 326 139 text2 growbox 16 178 326 139 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_317a.gif 466 171 0 1 0 15 15 15 eff.exe b04_317b.gif 605 171 0 1 0 15 15 15 eff.exe b04_317c.gif 605 51 0 1 0 15 15 15 * ≥ count the number of highligh isave 16 144 326 88 text3 growbox 16 144 326 88 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_318a.gif 466 210 0 1 0 15 15 15 eff.exe b04_318b.gif 466 151 0 1 0 15 15 15 * ≥ display the maximum or minim isave 16 93 326 37 text4 growbox 16 93 326 37 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_319a.gif 158 309 0 1 0 15 15 15 eff.exe b04_319b.gif 425 309 0 1 0 15 15 15 eff.exe b04_319c.gif 425 148 0 1 0 15 15 15 * ≥ sum the selected cell isave 16 42 326 3 text5 growbox 16 42 326 3 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text5 0 16 42 image memory text4 0 16 93 image memory text3 0 16 144 image memory text2 0 16 178 image memory text1 0 16 241 * eff.exe b04_320a.gif 246 365 0 1 0 15 15 15 eff.exe b04_320b.gif 2 272 0 1 0 15 15 15 eff.exe b04_320c.gif 158 309 0 1 0 15 15 15 * You choose an option from the isave 33 196 254 128 text1 textbox 33 196 254 128 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_321a.gif 246 365 0 1 0 15 15 15 eff.exe b04_321b.gif 2 272 0 1 0 15 15 15 eff.exe b04_321c.gif 168 295 0 1 0 15 15 15 * Now when you hold down Shift a isave 33 133 254 43 text2 growbox 33 133 254 43 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** * Note that the option must be c notebox 31 362 263 ** image memory text2 0 33 133 image memory text1 0 33 196 * eff.exe b04a321a.gif 246 365 0 1 0 15 15 15 eff.exe b04a321b.gif 2 272 0 1 0 15 15 15 eff.exe b04a321c.gif 168 295 0 1 0 15 15 15 qcall BE04q 040303 SimScrn 4 4 7 MoveCtrl 1 493 410 0 ********************************* eff.exe b04_323.gif 0 459 0 1 0 15 15 15 * An absolute cell reference or isave 30 217 299 149 text1 textbox 30 217 299 149 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_324a.gif 2 431 0 1 0 15 15 15 eff.exe b04_324b.gif 369 432 0 1 0 15 15 15 eff.exe b04_324c.gif 2 16 0 1 0 15 15 15 eff.exe b04_324d.gif 369 16 0 1 0 15 15 15 * An absolute reference includes isave 30 154 299 81 text2 growbox 30 154 299 81 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_325a.gif 2 431 0 1 0 15 15 15 * You use absolute cell referenc isave 30 86 299 30 text3 growbox 30 86 299 30 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Examples of absolute reference notebox 311 193 573 ** image memory text3 0 30 86 image memory text2 0 30 154 image memory text1 0 30 217 * eff.exe b04_327a.gif 2 431 0 1 0 15 15 15 * A relative cell reference in a isave 4 258 294 190 text1 textbox 4 258 294 190 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_328a.gif 0 458 0 1 0 15 15 15 * Once you have entered the form isave 4 195 294 88 text2 growbox 4 195 294 88 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** * For example, you can copy a cr notebox 301 161 592 ** eff.exe b04_329a.gif 0 458 0 1 0 15 15 15 * The moment you release the mou isave 4 93 294 20 text3 growbox 4 93 294 20 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * The process of entering a form notebox 302 171 506 ** image memory text3 0 4 93 image memory text2 0 4 195 image memory text1 0 4 258 * eff.exe b04_331a.gif 2 431 0 1 0 15 15 15 * Excel also allows mixed refere isave 380 362 633 294 text1 textbox 380 362 633 294 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_332a.gif 2 431 0 1 0 15 15 15 eff.exe b04_332b.gif 558 432 0 1 0 15 15 15 eff.exe b04_332c.gif 8 34 0 1 0 15 15 15 * The following are all the poss isave 380 299 633 209 text2 growbox 380 299 633 209 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_333a.gif 172 397 0 1 0 15 15 15 eff.exe b04_333b.gif 85 345 0 1 0 15 15 15 * ≥ $A$1 - absolute referenc isave 380 214 633 175 text3 growbox 380 214 633 175 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_334a.gif 213 384 0 1 0 15 15 15 eff.exe b04_334b.gif 109 354 0 1 0 15 15 15 * ≥ $A1 - mixed reference in whi isave 380 180 633 124 text4 growbox 380 180 633 124 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_335a.gif 134 384 0 1 0 15 15 15 eff.exe b04_335b.gif 19 354 0 1 0 15 15 15 eff.exe b04_335c.gif 134 354 0 1 0 15 15 15 * ≥ A$1 - mixed reference in whi isave 380 129 633 73 text5 growbox 380 129 633 73 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text5 0 380 129 image memory text4 0 380 180 image memory text3 0 380 214 image memory text2 0 380 299 image memory text1 0 380 362 * eff.exe b04_336a.gif 0 458 0 1 0 15 15 15 * You can examine the formulas w isave 153 203 397 135 text1 textbox 153 203 397 135 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_337a.gif 0 458 0 1 0 15 15 15 * This allows you to see the for isave 153 140 397 84 text2 growbox 153 140 397 84 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 153 140 image memory text1 0 153 203 * eff.exe b04_338a.gif 140 457 0 1 0 15 15 15 * To view the formulas, you sele isave 333 243 634 192 text1 textbox 333 243 634 192 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_339a.gif 63 457 0 1 0 15 15 15 * You click the View tab in the isave 333 197 634 141 text2 growbox 333 197 634 141 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_340a.gif 11 406 0 1 0 15 15 15 eff.exe b04_340b.gif 76 405 0 1 0 15 15 15 eff.exe b04_340c.gif 77 227 0 1 0 15 15 15 * Then you check the box entitle isave 333 146 634 107 text3 growbox 333 146 634 107 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_341a.gif 0 458 0 1 0 15 15 15 * The result is a display of the isave 333 112 634 56 text4 growbox 333 112 634 56 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 333 112 image memory text3 0 333 146 image memory text2 0 333 197 image memory text1 0 333 243 * * Topic: Hands-on: Using AutoSum Topic No.: 4 **** SimScrn 4 5 7 MoveCtrl 1 493 500 0 exercise 02 1 120 70 task 02 0102 402 300 235 2 120 67 35 75 * pause 1 1 1 1 1 1 1 1 ********************************* * * Topic: Date formulas Topic No.: 5 **** SimScrn 4 6 7 MoveCtrl 1 493 410 0 ********************************* eff.exe b04_501.gif 0 459 0 1 0 15 15 15 * If you plan to use dates in fo isave 174 241 450 139 text1 textbox 174 241 450 139 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_502a.gif 0 459 0 1 0 15 15 15 * You do this by making sure tha isave 174 144 450 54 text2 growbox 174 144 450 54 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 174 144 image memory text1 0 174 241 * eff.exe b04_503a.gif 0 459 0 1 0 15 15 15 * Excel 97 recognizes entries as isave 215 344 524 293 text1 textbox 215 344 524 293 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * For example, if Jun 97 is ente notebox 241 261 486 ** eff.exe b04_505a.gif 13 430 0 1 0 15 15 15 eff.exe b04_505b.gif 13 397 0 1 0 15 15 15 * You can enter dates in cells isave 215 298 524 208 text2 growbox 215 298 524 208 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** isave 215 213 524 106 text3 growbox 215 213 524 106 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 215 213 image memory text2 0 215 298 image memory text1 0 215 344 * eff.exe b04_506a.gif 48 338 0 1 0 15 15 15 eff.exe b04_506b.gif 81 338 0 1 0 15 15 15 * You can create a formula to isave 272 337 542 235 text1 textbox 272 337 542 235 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 * isave 272 240 542 167 text2 growbox 272 240 542 167 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 * image memory text2 0 272 240 image memory text1 0 272 337 * eff.exe b04_508a.gif 15 431 0 1 0 15 15 15 eff.exe b04_508b.gif 552 432 0 1 0 15 15 15 eff.exe b04_508c.gif 8 16 0 1 0 15 15 15 eff.exe b04_508d.gif 552 16 0 1 0 15 15 15 * Microsoft Excel stores dates a isave 406 367 624 248 text1 textbox 406 367 624 248 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_509a.gif 40 397 0 1 0 15 15 15 * Dates and times are values and isave 406 253 624 163 text2 growbox 406 253 624 163 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_510a.gif 440 426 0 1 0 15 15 15 eff.exe b04_510b.gif 40 397 0 1 0 15 15 15 eff.exe b04_510c.gif 440 365 0 1 0 15 15 15 * For example, to determine the isave 406 168 624 61 text3 growbox 406 168 624 61 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** * You can view a date or time as notebox 160 283 389 ** image memory text3 0 406 168 image memory text2 0 406 253 image memory text1 0 406 367 * eff.exe b04_516a.gif 0 459 0 1 0 15 15 15 * The best way to deal with time isave 377 429 612 361 text1 textbox 377 429 612 361 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_517a.gif 0 459 0 1 0 15 15 15 * Some examples are isave 377 366 612 293 text2 growbox 377 366 612 293 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_518a.gif 11 363 0 1 0 15 15 15 eff.exe b04_518b.gif 240 375 0 1 0 15 15 15 * ≥ 11:30:00 AM for 11:30 a.m isave 377 298 612 259 text3 growbox 377 298 612 259 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_519a.gif 263 427 0 1 0 15 15 15 eff.exe b04_519b.gif 12 379 0 1 0 15 15 15 * ≥ 11:30 for 11:30 a.m isave 377 264 612 225 text4 growbox 377 264 612 225 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_520a.gif 12 431 0 1 0 15 15 15 eff.exe b04_520b.gif 558 432 0 1 0 15 15 15 eff.exe b04_520c.gif 8 16 0 1 0 15 15 15 eff.exe b04_520d.gif 558 16 0 1 0 15 15 15 * ≥ 11:30 pm for 11:30:00 p.m isave 377 230 612 191 text5 growbox 377 230 612 191 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_521a.gif 12 431 0 1 0 15 15 15 eff.exe b04_521b.gif 558 432 0 1 0 15 15 15 eff.exe b04_521c.gif 8 16 0 1 0 15 15 15 eff.exe b04_521d.gif 558 16 0 1 0 15 15 15 * An example of an unrecognized isave 377 196 612 140 text6 growbox 377 196 612 140 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall BE04q 040501 eff.exe b04_522a.gif 12 431 0 1 0 15 15 15 eff.exe b04_522b.gif 558 432 0 1 0 15 15 15 eff.exe b04_522c.gif 8 16 0 1 0 15 15 15 eff.exe b04_522d.gif 558 16 0 1 0 15 15 15 * You can also combine dates and isave 377 145 612 72 text7 growbox 377 145 612 72 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text7 0 377 145 image memory text6 0 377 196 image memory text5 0 377 230 image memory text4 0 377 264 image memory text3 0 377 298 image memory text2 0 377 366 image memory text1 0 377 429 * eff.exe b04_523a.gif 11 431 0 1 0 15 15 15 eff.exe b04_523b.gif 11 15 0 1 0 15 15 15 * Excel 97 supports two date sys isave 392 202 611 134 text1 textbox 392 202 611 134 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_524.gif 0 459 0 1 0 15 15 15 * The default date system for Ex isave 392 139 611 83 text2 growbox 392 139 611 83 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * You can change to the 1904 dat notebox 337 350 623 ** image memory text2 0 392 139 image memory text1 0 392 202 * eff.exe b04_526a.gif 11 431 0 1 0 15 15 15 eff.exe b04_526b.gif 608 365 0 1 0 15 15 15 * The 1900 data system uses Janu isave 381 327 575 259 text1 textbox 381 327 575 259 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_527a.gif 132 359 0 1 0 15 15 15 * Each date has a serial number isave 381 264 575 174 text2 growbox 381 264 575 174 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_528a.gif 2 436 0 1 0 15 15 15 eff.exe b04_528b.gif 356 365 0 1 0 15 15 15 * So January 1, 1900 has the ser isave 381 179 575 89 text3 growbox 381 179 575 89 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 381 179 image memory text2 0 381 264 image memory text1 0 381 327 * eff.exe b04_529a.gif 2 436 0 1 0 15 15 15 eff.exe b04_529b.gif 551 365 0 1 0 15 15 15 * When you enter a date in Excel isave 31 212 333 144 text1 textbox 31 212 333 144 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Excel presumes a century of 20 notebox 360 319 589 ** eff.exe b04_530a.gif 12 397 0 1 0 15 15 15 * For example, if you type "5/28 isave 31 149 333 93 text2 growbox 31 149 333 93 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall BE04q 040502 eff.exe b04_531a.gif 216 381 0 1 0 15 15 15 eff.exe b04_531b.gif 66 352 0 1 0 15 15 15 eff.exe b04_531c.gif 216 352 0 1 0 15 15 15 * Another example is "5/28/91". isave 31 98 333 42 text3 growbox 31 98 333 42 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 31 98 image memory text2 0 31 149 image memory text1 0 31 212 * eff.exe b04_532a.gif 12 431 0 1 0 15 15 15 eff.exe b04_532b.gif 558 432 0 1 0 15 15 15 eff.exe b04_532c.gif 8 16 0 1 0 15 15 15 eff.exe b04_532d.gif 558 16 0 1 0 15 15 15 * Microsoft Excel calculates the isave 354 446 583 378 text1 textbox 354 446 583 378 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall BE04q 040503 eff.exe b04_533a.gif 15 431 0 1 0 15 15 15 eff.exe b04_533b.gif 552 432 0 1 0 15 15 15 eff.exe b04_533c.gif 8 16 0 1 0 15 15 15 eff.exe b04_533d.gif 552 16 0 1 0 15 15 15 * The value you see on the scree isave 354 383 583 293 text2 growbox 354 383 583 293 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_534a.gif 15 431 0 1 0 15 15 15 eff.exe b04_534b.gif 552 432 0 1 0 15 15 15 eff.exe b04_534c.gif 8 16 0 1 0 15 15 15 eff.exe b04_534d.gif 552 16 0 1 0 15 15 15 * For example, a cell that displ isave 354 298 583 191 text3 growbox 354 298 583 191 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_535a.gif 48 380 0 1 0 15 15 15 eff.exe b04_535b.gif 101 380 0 1 0 15 15 15 eff.exe b04_535c.gif 48 359 0 1 0 15 15 15 eff.exe b04_535d.gif 101 359 0 1 0 15 15 15 * You can change the display of isave 354 196 583 72 text4 growbox 354 196 583 72 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 354 196 image memory text3 0 354 298 image memory text2 0 354 383 image memory text1 0 354 446 * eff.exe b04_536a.gif 8 432 0 1 0 15 15 15 eff.exe b04_536b.gif 558 432 0 1 0 15 15 15 eff.exe b04_536c.gif 8 405 0 1 0 15 15 15 eff.exe b04_536d.gif 552 365 0 1 0 15 15 15 * When you enter a date formula, isave 377 361 589 259 text1 textbox 377 361 589 259 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** * When you enter date formulas t notebox 355 231 604 ** eff.exe b04_538a.gif 123 394 0 1 0 15 15 15 * It then converts the dates to isave 377 264 589 157 text2 growbox 377 264 589 157 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe b04_539a.gif 2 430 0 1 0 15 15 15 eff.exe b04_539b.gif 419 426 0 1 0 15 15 15 * To accommodate leap years when isave 377 162 589 72 text3 growbox 377 162 589 72 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 377 162 image memory text2 0 377 264 image memory text1 0 377 361 * ** eff.exe b04_540a.gif 0 458 0 1 0 15 15 15 * Some types of worksheets may isave 2 196 219 145 text1 textbox 2 196 219 145 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** ** eff.exe b04_541.gif 0 459 0 1 0 15 15 15 * An outline lets you display isave 2 150 219 77 text2 growbox 2 150 219 77 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** ** eff.exe b04_542a.gif 2 457 0 1 0 15 15 15 eff.exe b04_542b.gif 610 365 0 1 0 15 15 15 * To do this you would choose isave 2 82 219 9 text3 growbox 2 82 219 9 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * For more information on outlining notebox 9 309 215 ** image memory text3 0 2 82 image memory text2 0 2 150 image memory text1 0 2 196 * * Topic: Hands-on: Using a date formula Topic No.: 6 **** SimScrn 4 7 7 MoveCtrl 1 493 500 0 * exercise 03 1 120 70 task 03 0103 402 300 235 6 120 67 35 75 * pause 1 1 1 1 1 1 1 1 *