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

Wrap

Text File | 1997-03-26 | 34.6 KB | 1,300 lines

* SimScrn 2 1 12 MoveCtrl 1 493 410 0 ********************************* * Course: Beginning Excel * Unit: Manipulating data Unit No.:02 * Topic: Entering and changing data Topic No.: 1 **** eff.exe b02_101.gif 0 459 0 1 0 15 15 15 * Each worksheet in a workbook i isave 4 261 267 159 text1 textbox 4 261 267 159 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_102a.gif 298 335 0 1 0 15 15 15 eff.exe b02_102b.gif 298 203 0 1 0 15 15 15 * ≥ tex isave 4 164 267 125 text2 growbox 4 164 267 125 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_103a.gif 305 328 0 1 0 15 15 15 * ≥ a logical value (true or fal isave 4 130 267 91 text3 growbox 4 130 267 91 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_104a.gif 281 336 0 1 0 15 15 15 eff.exe b02_104b.gif 281 122 0 1 0 15 15 15 * ≥ a formula, which returns a v isave 4 96 267 40 text4 growbox 4 96 267 40 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * An Excel worksheet can also co notebox 278 241 559 ** image memory text4 0 4 96 image memory text3 0 4 130 image memory text2 0 4 164 image memory text1 0 4 261 * eff.exe b02_106a.gif 281 336 0 1 0 15 15 15 eff.exe b02_106b.gif 281 122 0 1 0 15 15 15 * In Excel 97, text is any combi isave 31 311 269 243 text1 textbox 31 311 269 243 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_107a.gif 380 298 0 1 0 15 15 15 * For example, Excel treats the isave 31 248 269 158 text2 growbox 31 248 269 158 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_108a.gif 377 298 0 1 0 15 15 15 * ≥ 345SW isave 31 163 269 124 text3 growbox 31 163 269 124 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_109a.gif 377 281 0 1 0 15 15 15 * ≥ 44-65 isave 31 129 269 90 text4 growbox 31 129 269 90 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_110a.gif 378 266 0 1 0 15 15 15 * ≥ 989 332 isave 31 95 269 56 text5 growbox 31 95 269 56 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text5 0 31 95 image memory text4 0 31 129 image memory text3 0 31 163 image memory text2 0 31 248 image memory text1 0 31 311 * eff.exe b02_111a.gif 83 331 0 1 0 15 15 15 eff.exe b02_111b.gif 297 336 0 1 0 15 15 15 * You enter text by clicking the isave 205 332 394 264 text1 textbox 205 332 394 264 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_112a.gif 83 375 0 1 0 15 15 15 * Then you simply type whatever isave 205 269 394 196 text2 growbox 205 269 394 196 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 205 269 image memory text1 0 205 332 * qcall BE02q 020101 eff.exe b02_113a.gif 2 431 0 1 0 15 15 15 eff.exe b02_113b.gif 558 432 0 1 0 15 15 15 eff.exe b02_113c.gif 2 16 0 1 0 15 15 15 eff.exe b02_113d.gif 558 16 0 1 0 15 15 15 * If you are typing data into ro isave 43 255 278 170 text1 textbox 43 255 278 170 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_114a.gif 0 459 0 1 0 15 15 15 * If you are typing data into co isave 43 175 278 85 text2 growbox 43 175 278 85 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 43 175 image memory text1 0 43 255 * eff.exe b02_115a.gif 0 458 0 1 0 15 15 15 * Entering the same data many ti isave 93 181 361 113 text1 textbox 93 181 361 113 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_116a.gif 0 459 0 1 0 15 15 15 * More importantly, you may find t isave 93 118 361 45 text2 growbox 93 118 361 45 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 93 118 image memory text1 0 93 181 * eff.exe b02_117a.gif 0 459 0 1 0 15 15 15 * For example, you might enter a isave 8 232 288 147 text1 textbox 8 232 288 147 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_118a.gif 466 288 0 1 0 15 15 15 eff.exe b02_118b.gif 301 130 0 1 0 15 15 15 eff.exe b02_118c.gif 364 95 0 1 0 15 15 15 * When you tally the sales for e isave 8 152 288 62 text2 growbox 8 152 288 62 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 8 152 image memory text1 0 8 232 * eff.exe b02_119a.gif 0 455 0 1 0 15 15 15 * The AutoComplete function look isave 5 455 314 353 text1 textbox 5 455 314 353 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** * You switch the AutoComplete option notebox 7 330 305 ** eff.exe b02_120a.gif 362 318 0 1 0 15 15 15 eff.exe b02_120b.gif 610 318 0 1 0 15 15 15 * As soon as the letter T is typ isave 5 358 314 285 text2 growbox 5 358 314 285 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_121a.gif 395 284 0 1 0 15 15 15 * The same is true of B - it wil isave 5 290 314 234 text3 growbox 5 290 314 234 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_122a.gif 395 286 0 1 0 15 15 15 * If this is a new entry, ignore isave 5 239 314 166 text4 growbox 5 239 314 166 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 5 239 image memory text3 0 5 290 image memory text2 0 5 358 image memory text1 0 5 455 * eff.exe b02_123a.gif 0 459 0 1 0 15 15 15 * The Pick List feature works isave 229 276 439 225 text1 textbox 229 276 439 225 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * It is important to note that t notebox 211 197 453 ** image memory text1 0 229 276 * eff.exe b02_127a.gif 2 379 0 1 0 15 15 15 * As you type in a column of inf isave 186 333 476 282 text1 textbox 186 333 476 282 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_128a.gif 2 446 0 1 0 15 15 15 * You can access this list by ri isave 186 287 476 214 text2 growbox 186 287 476 214 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_129a.gif 27 446 0 1 0 15 15 15 * The Pick List list is displayed isave 186 219 476 146 text3 growbox 186 219 476 146 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 186 219 image memory text2 0 186 287 image memory text1 0 186 333 * eff.exe b02_130a.gif 20 234 0 1 0 15 15 15 * You highlight the item you wis isave 204 235 408 184 text1 textbox 204 235 408 184 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_131a.gif 190 381 0 1 0 15 15 15 eff.exe b02_131b.gif 20 234 0 1 0 15 15 15 * Then you click the item to isave 204 189 408 133 text2 growbox 204 189 408 133 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 204 189 image memory text1 0 204 235 * SimScrn 2 2 12 MoveCtrl 1 493 410 0 ********************************* eff.exe b02_132.gif 0 459 0 1 0 15 15 15 * Numbers that you type in a cel isave 24 263 258 212 text1 textbox 24 263 258 212 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_133a.gif 278 332 0 1 0 15 15 15 eff.exe b02_133b.gif 549 16 0 1 0 15 15 15 * In spreadsheets, a constant is isave 24 217 258 144 text2 growbox 24 217 258 144 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 24 217 image memory text1 0 24 263 * eff.exe b02_134a.gif 0 311 0 1 0 15 15 15 eff.exe b02_134b.gif 334 311 0 1 0 15 15 15 eff.exe b02_134c.gif 0 17 0 1 0 15 15 15 eff.exe b02_134d.gif 334 17 0 1 0 15 15 15 * In Excel 97, a number can cont isave 26 303 266 184 text1 textbox 26 303 266 184 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_136a.gif 1 17 0 1 0 15 15 15 eff.exe b02_136b.gif 421 17 0 1 0 15 15 15 * All other combinations of numb isave 26 189 266 116 text2 growbox 26 189 266 116 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 26 189 image memory text1 0 26 303 * eff.exe b02_137a.gif 278 332 0 1 0 15 15 15 eff.exe b02_137b.gif 551 16 0 1 0 15 15 15 * Excel ignores leading plus sig isave 6 272 246 204 text1 textbox 6 272 246 204 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall BE02q 020102 eff.exe b02_138a.gif 2 330 0 1 0 15 15 15 eff.exe b02_138b.gif 339 330 0 1 0 15 15 15 eff.exe b02_138c.gif 2 17 0 1 0 15 15 15 eff.exe b02_138d.gif 339 17 0 1 0 15 15 15 * If a number is negative, you n isave 6 209 246 102 text2 growbox 6 209 246 102 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 6 209 image memory text1 0 6 272 * eff.exe b02_139a.gif 0 459 0 1 0 15 15 15 * You enter dates using a slash isave 38 292 285 224 text1 textbox 38 292 285 224 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_140a.gif 2 431 0 1 0 15 15 15 eff.exe b02_140b.gif 558 432 0 1 0 15 15 15 eff.exe b02_140c.gif 2 16 0 1 0 15 15 15 eff.exe b02_140d.gif 558 16 0 1 0 15 15 15 * For example, you can type Jun- isave 38 229 285 156 text2 growbox 38 229 285 156 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 38 229 image memory text1 0 38 292 * eff.exe b02_141a.gif 2 432 0 1 0 15 15 15 eff.exe b02_141b.gif 558 432 0 1 0 15 15 15 eff.exe b02_141c.gif 2 405 0 1 0 15 15 15 * Most Excel users will enter times isave 61 301 306 250 text1 textbox 61 301 306 250 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_141.gif 0 459 0 1 0 15 15 15 * To enter a time based on the 1 isave 61 255 306 165 text2 growbox 61 255 306 165 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_142a.gif 2 431 0 1 0 15 15 15 eff.exe b02_142b.gif 558 432 0 1 0 15 15 15 eff.exe b02_142c.gif 2 16 0 1 0 15 15 15 eff.exe b02_142d.gif 558 16 0 1 0 15 15 15 * In our example we used eight a isave 61 170 306 97 text3 growbox 61 170 306 97 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * Excel defaults to a.m. when re notebox 66 431 293 ** image memory text3 0 61 170 image memory text2 0 61 255 image memory text1 0 61 301 * eff.exe b02_144a.gif 2 431 0 1 0 15 15 15 eff.exe b02_144b.gif 558 432 0 1 0 15 15 15 eff.exe b02_144c.gif 8 287 0 1 0 15 15 15 * To enter today's date, you pre isave 46 284 273 233 text1 textbox 46 284 273 233 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_145a.gif 39 379 0 1 0 15 15 15 eff.exe b02_145b.gif 226 380 0 1 0 15 15 15 eff.exe b02_145c.gif 319 274 0 1 0 15 15 15 * To enter today's time, you pre isave 46 238 273 182 text2 growbox 46 238 273 182 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 46 238 image memory text1 0 46 284 * SimScrn 2 3 12 MoveCtrl 1 493 410 0 ********************************* eff.exe b02_146.gif 0 459 0 1 0 15 15 15 * Excel 97 has various features isave 33 261 272 210 text1 textbox 33 261 272 210 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_147a.gif 375 75 0 1 0 15 15 15 * One of these is what is known isave 33 215 272 142 text2 growbox 33 215 272 142 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_148a.gif 284 226 0 1 0 15 15 15 * In a series, for example, you isave 33 147 272 40 text3 growbox 33 147 272 40 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 33 147 image memory text2 0 33 215 image memory text1 0 33 261 * eff.exe b02_149a.gif 2 379 0 1 0 15 15 15 eff.exe b02_149b.gif 2 348 0 1 0 15 15 15 * Let's suppose that we need a s isave 36 181 319 113 text1 textbox 36 181 319 113 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_150a.gif 123 410 0 1 0 15 15 15 eff.exe b02_150b.gif 381 195 0 1 0 15 15 15 * The first step is to type the isave 36 118 319 45 text2 growbox 36 118 319 45 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * The Checkmark button is also called notebox 71 283 281 ** image memory text2 0 36 118 image memory text1 0 36 181 * eff.exe b02_151a.gif 28 410 0 1 0 15 15 15 eff.exe b02_151b.gif 8 16 0 1 0 15 15 15 * You place the pointer over the isave 38 195 376 144 text1 textbox 38 195 376 144 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_152a.gif 90 338 0 1 0 15 15 15 eff.exe b02_152b.gif 119 367 0 1 0 15 15 15 * The cursor changes shape to fo isave 38 149 376 110 text2 growbox 38 149 376 110 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_153a.gif 51 367 0 1 0 15 15 15 eff.exe b02_153b.gif 531 365 0 1 0 15 15 15 * While pressing and holding the isave 38 115 376 42 text3 growbox 38 115 376 42 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 38 115 image memory text2 0 38 149 image memory text1 0 38 195 * eff.exe b02_154a.gif 618 426 0 1 0 15 15 15 eff.exe b02_154b.gif 149 348 0 1 0 15 15 15 * You will notice that as you dr isave 46 206 266 121 text1 textbox 46 206 266 121 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_155a.gif 28 365 0 1 0 15 15 15 eff.exe b02_155b.gif 610 365 0 1 0 15 15 15 eff.exe b02_155c.gif 8 184 0 1 0 15 15 15 * When you release the mouse but isave 46 126 266 53 text2 growbox 46 126 266 53 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 46 126 image memory text1 0 46 206 * ** eff.exe b02_157a.gif 0 459 0 1 0 15 15 15 * You can use the AutoFill featu isave 326 344 616 225 text1 textbox 326 344 616 225 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_158a.gif 2 381 0 1 0 15 15 15 eff.exe b02_158b.gif 374 16 0 1 0 15 15 15 * ≥ a mixture of text and number isave 326 230 616 157 text2 growbox 326 230 616 157 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_159a.gif 1 381 0 1 0 15 15 15 eff.exe b02_159b.gif 1 344 0 1 0 15 15 15 * ≥ cell contents repeated isave 326 162 616 106 text3 growbox 326 162 616 106 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_160a.gif 190 408 0 1 0 15 15 15 eff.exe b02_160b.gif 2 344 0 1 0 15 15 15 eff.exe b02_160c.gif 120 259 0 1 0 15 15 15 * ≥ repeated blocks of informati isave 326 111 616 55 text4 growbox 326 111 616 55 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 326 111 image memory text3 0 326 162 image memory text2 0 326 230 image memory text1 0 326 344 * SimScrn 2 4 12 MoveCtrl 1 493 410 0 ********************************* eff.exe b02_161.gif 0 459 0 1 0 15 15 15 * You will find editing text and isave 49 176 287 125 text1 textbox 49 176 287 125 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_162a.gif 153 303 0 1 0 15 15 15 * Click the cell that needs edit isave 49 130 287 74 text2 growbox 49 130 287 74 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_163a.gif 20 430 0 1 0 15 15 15 eff.exe b02_163b.gif 20 377 0 1 0 15 15 15 eff.exe b02_163c.gif 342 305 0 1 0 15 15 15 * Then simply type in the correc isave 49 79 287 23 text3 growbox 49 79 287 23 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * It is also possible to edit ce notebox 19 375 330 ** image memory text3 0 49 79 image memory text2 0 49 130 image memory text1 0 49 176 * eff.exe b02_165a.gif 2 432 0 1 0 15 15 15 * To clear the contents of a cel isave 346 340 611 289 text1 textbox 346 340 611 289 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_166a.gif 20 375 0 1 0 15 15 15 * Then right-click to access the isave 346 294 611 238 text2 growbox 346 294 611 238 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_167a.gif 20 307 0 1 0 15 15 15 * Choose the Clear Contents opti isave 346 243 611 204 text3 growbox 346 243 611 204 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_168a.gif 86 381 0 1 0 15 15 15 * The contents of the cell will isave 346 209 611 153 text4 growbox 346 209 611 153 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * You can perform this operation notebox 354 434 599 ** image memory text4 0 346 209 image memory text3 0 346 243 image memory text2 0 346 294 image memory text1 0 346 340 * eff.exe b02_170a.gif 2 457 0 1 0 15 15 15 * The Clear Contents option is a isave 394 286 577 201 text1 textbox 394 286 577 201 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_171a.gif 49 321 0 1 0 15 15 15 * However, this might be a longe isave 394 206 577 150 text2 growbox 394 206 577 150 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * This function will also operat notebox 372 383 585 ** image memory text2 0 394 206 image memory text1 0 394 286 * eff.exe b02_173a.gif 2 457 0 1 0 15 15 15 * A very useful feature is the A isave 385 340 616 272 text1 textbox 385 340 616 272 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_174.gif 0 459 0 1 0 15 15 15 * For example, as soon as you ty isave 385 277 616 187 text2 growbox 385 277 616 187 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_175a.gif 190 447 0 1 0 15 15 15 * You access AutoCorrect by sele isave 385 192 616 119 text3 growbox 385 192 616 119 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 385 192 image memory text2 0 385 277 image memory text1 0 385 340 * eff.exe b02_176a.gif 117 457 0 1 0 15 15 15 * The AutoCorrect dialog box all isave 393 321 617 253 text1 textbox 393 321 617 253 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_177a.gif 153 288 0 1 0 15 15 15 eff.exe b02_177b.gif 153 222 0 1 0 15 15 15 eff.exe b02_177c.gif 476 211 0 1 0 15 15 15 * These errors include a list of isave 393 258 617 185 text2 growbox 393 258 617 185 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 393 258 image memory text1 0 393 321 * eff.exe b02_178a.gif 2 457 0 1 0 15 15 15 * The Undo function in the Edit isave 281 362 514 294 text1 textbox 281 362 514 294 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_179.gif 0 459 0 1 0 15 15 15 * You are able to undo up to the isave 281 299 514 226 text2 growbox 281 299 514 226 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * You can delete a worksheet in notebox 34 313 271 ** image memory text2 0 281 299 image memory text1 0 281 362 * eff.exe b02_180a.gif 2 178 0 1 0 15 15 15 eff.exe b02_180b.gif 42 457 0 1 0 15 15 15 * Undo also has a complementary isave 377 304 611 253 text1 textbox 377 304 611 253 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_181a.gif 259 441 0 1 0 15 15 15 * This function repeats your las isave 377 258 611 185 text2 growbox 377 258 611 185 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 377 258 image memory text1 0 377 304 * * Topic: Hands-on: Entering data Topic No.: 2 **** SimScrn 2 5 12 MoveCtrl 1 493 500 0 * exercise 01 1 120 70 task 01 0201 372 300 265 7 120 67 35 75 *task 01 0201 402 300 300 7 120 67 35 75 pause 1 1 1 1 1 1 1 1 ********************* ********************************* * * Topic: Working with rows and columns Topic No.: 3 **** SimScrn 2 6 12 MoveCtrl 1 493 410 0 ********************************* eff.exe b02_301.gif 0 459 0 1 0 15 15 15 * As with any project, there are isave 133 198 429 130 text1 textbox 133 198 429 130 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_302a.gif 2 430 0 1 0 15 15 15 eff.exe b02_302b.gif 452 174 0 1 0 15 15 15 * You insert a new row by select isave 133 135 429 45 text2 growbox 133 135 429 45 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 133 135 image memory text1 0 133 198 * eff.exe b02_303a.gif 174 325 0 1 0 15 15 15 eff.exe b02_303b.gif 220 189 0 1 0 15 15 15 * For example, you have a series isave 301 208 597 140 text1 textbox 301 208 597 140 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_304.gif 0 459 0 1 0 15 15 15 * You want to add a new contract isave 301 145 597 72 text2 growbox 301 145 597 72 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 301 145 image memory text1 0 301 208 * eff.exe b02_305a.gif 71 370 0 1 0 15 15 15 * In this case you would click t isave 407 265 617 163 text1 textbox 407 265 617 163 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_306a.gif 71 370 0 1 0 15 15 15 * You will be asked whether to i isave 407 168 617 112 text2 growbox 407 168 617 112 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_307a.gif 30 381 0 1 0 15 15 15 eff.exe b02_307b.gif 30 325 0 1 0 15 15 15 * On clicking Entire Row the new isave 407 117 617 61 text3 growbox 407 117 617 61 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 407 117 image memory text2 0 407 168 image memory text1 0 407 265 * eff.exe b02_308a.gif 2 393 0 1 0 15 15 15 * To insert a number of rows, cl isave 156 456 377 354 text1 textbox 156 456 377 354 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_309.gif 0 459 0 1 0 15 15 15 *eff.exe b02_309a.gif 431 393 0 1 0 15 15 15 *eff.exe b02_309b.gif 19 247 0 1 0 15 15 15 *eff.exe b02_309c.gif 431 247 0 1 0 15 15 15 * Once the entire set of rows is isave 156 359 377 269 text2 growbox 156 359 377 269 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_310a.gif 2 383 0 1 0 15 15 15 * The same number of rows will b isave 156 274 377 201 text3 growbox 156 274 377 201 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 156 274 image memory text2 0 156 359 image memory text1 0 156 456 * SimScrn 2 7 12 MoveCtrl 1 493 410 0 ********************************* eff.exe b02_311.gif 0 459 0 1 0 15 15 15 * Selection of rows for deletion isave 192 188 398 120 text1 textbox 192 188 398 120 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_312a.gif 2 430 0 1 0 15 15 15 eff.exe b02_312b.gif 423 157 0 1 0 15 15 15 * When deleting a row, you selec isave 192 125 398 52 text2 growbox 192 125 398 52 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 192 125 image memory text1 0 192 188 * eff.exe b02_313a.gif 2 379 0 1 0 15 15 15 eff.exe b02_313b.gif 187 381 0 1 0 15 15 15 * For instance, if you want to r isave 366 384 623 299 text1 textbox 366 384 623 299 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_314a.gif 31 350 0 1 0 15 15 15 eff.exe b02_314b.gif 31 307 0 1 0 15 15 15 eff.exe b02_314c.gif 423 157 0 1 0 15 15 15 * Right-click to access the pop- isave 366 304 623 248 text2 growbox 366 304 623 248 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_315a.gif 30 381 0 1 0 15 15 15 eff.exe b02_315b.gif 30 310 0 1 0 15 15 15 * The row you selected will no l isave 366 253 623 197 text3 growbox 366 253 623 197 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 366 253 image memory text2 0 366 304 image memory text1 0 366 384 * eff.exe b02_316a.gif 28 381 0 1 0 15 15 15 eff.exe b02_316b.gif 2 316 0 1 0 15 15 15 * You can delete an entire row s isave 354 456 606 371 text1 textbox 354 456 606 371 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_317a.gif 95 403 0 1 0 15 15 15 * However, in this case a specia isave 354 376 606 320 text2 growbox 354 376 606 320 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_318a.gif 194 305 0 1 0 15 15 15 eff.exe b02_318b.gif 317 245 0 1 0 15 15 15 * You click the appropriate radi isave 354 325 606 269 text3 growbox 354 325 606 269 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_319a.gif 28 408 0 1 0 15 15 15 * The row is removed instantly isave 354 274 606 235 text4 growbox 354 274 606 235 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 354 274 image memory text3 0 354 325 image memory text2 0 354 376 image memory text1 0 354 456 * eff.exe b02_320a.gif 2 408 0 1 0 15 15 15 eff.exe b02_320b.gif 2 19 0 1 0 15 15 15 * You can delete a number of row isave 169 278 363 193 text1 textbox 169 278 363 193 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_321a.gif 19 434 0 1 0 15 15 15 eff.exe b02_321b.gif 297 427 0 1 0 15 15 15 * Then you right-click to access isave 169 198 363 125 text2 growbox 169 198 363 125 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_322a.gif 2 434 0 1 0 15 15 15 eff.exe b02_322b.gif 2 19 0 1 0 15 15 15 * The entire range of rows will isave 169 130 363 74 text3 growbox 169 130 363 74 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * The alternative to using the p notebox 158 410 365 ** image memory text3 0 169 130 image memory text2 0 169 198 image memory text1 0 169 278 * SimScrn 2 8 12 MoveCtrl 1 493 410 0 ********************************* eff.exe b02_324.gif 0 459 0 1 0 15 15 15 * Working with columns is the sa isave 5 382 221 331 text1 textbox 5 382 221 331 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** qcall BE02q 020301 eff.exe b02_325a.gif 2 430 0 1 0 15 15 15 eff.exe b02_325b.gif 2 316 0 1 0 15 15 15 * The same menus and options are isave 5 336 221 263 text2 growbox 5 336 221 263 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 5 336 image memory text1 0 5 382 * eff.exe b02_326a.gif 246 395 0 1 0 15 15 15 eff.exe b02_326b.gif 222 233 0 1 0 15 15 15 * To insert a column, you select isave 383 310 616 225 text1 textbox 383 310 616 225 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_327a.gif 0 458 0 1 0 15 15 15 * To delete a column, you select isave 383 230 616 157 text2 growbox 383 230 616 157 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_328a.gif 0 458 0 1 0 15 15 15 * Selecting a single cell and ri isave 383 162 616 72 text3 growbox 383 162 616 72 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** * It is important to note that t notebox 134 392 375 ** image memory text3 0 383 162 image memory text2 0 383 230 image memory text1 0 383 310 * * Topic: Hands-on: Inserting a column Topic No.: 4 **** SimScrn 2 9 12 MoveCtrl 1 493 500 0 * exercise 02 1 120 70 task 02 0202 402 300 235 3 120 67 35 75 * pause 1 1 1 1 1 1 1 1 ********************* ********************************* * * Topic: Working with rows and columns Topic No.: 5 **** SimScrn 2 10 12 MoveCtrl 1 493 410 0 ********************************* eff.exe b02_501.gif 0 459 0 1 0 15 15 15 * One way to cut (move) or copy isave 222 345 491 260 text1 textbox 222 345 491 260 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 222 345 * qcall BE02q 020501 eff.exe b02_502a.gif 0 459 0 1 0 15 15 15 * The status bar instructs you t isave 11 269 249 218 text1 textbox 11 269 249 218 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_503a.gif 0 459 0 1 0 15 15 15 * You then have three options isave 11 223 249 150 text2 growbox 11 223 249 150 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_504a.gif 48 457 0 1 0 15 15 15 * ≥ select Edit - Past isave 11 155 249 116 text3 growbox 11 155 249 116 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_505a.gif 2 457 0 1 0 15 15 15 eff.exe b02_505b.gif 364 318 0 1 0 15 15 15 * ≥ press Ente isave 11 121 249 82 text4 growbox 11 121 249 82 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 11 121 image memory text3 0 11 155 image memory text2 0 11 223 image memory text1 0 11 269 * eff.exe b02_506a.gif 2 440 0 1 0 15 15 15 eff.exe b02_506b.gif 297 427 0 1 0 15 15 15 * Cutting data in this manner do isave 31 245 269 160 text1 textbox 31 245 269 160 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_507a.gif 127 440 0 1 0 15 15 15 * When you want to repaste the d isave 31 165 269 75 text2 growbox 31 165 269 75 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 31 165 image memory text1 0 31 245 * eff.exe b02_508a.gif 142 440 0 1 0 15 15 15 * If you are copying data, you c isave 33 217 251 149 text1 textbox 33 217 251 149 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_509a.gif 142 440 0 1 0 15 15 15 eff.exe b02_509b.gif 382 328 0 1 0 15 15 15 * When you are pasting data into isave 33 154 251 81 text2 growbox 33 154 251 81 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 33 154 image memory text1 0 33 217 * qcall BE02q 020502 eff.exe b02_510a.gif 2 434 0 1 0 15 15 15 eff.exe b02_510b.gif 389 322 0 1 0 15 15 15 eff.exe b02_510c.gif 2 78 0 1 0 15 15 15 eff.exe b02_510d.gif 389 78 0 1 0 15 15 15 * You select several non-sequent isave 93 252 356 167 text1 textbox 93 252 356 167 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 93 252 * eff.exe b02_511a.gif 2 430 0 1 0 15 15 15 eff.exe b02_511b.gif 2 381 0 1 0 15 15 15 * For example you want to copy t isave 160 455 395 404 text1 textbox 160 455 395 404 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_512a.gif 189 274 0 1 0 15 15 15 eff.exe b02_512b.gif 374 324 0 1 0 15 15 15 * Hold down the CTRL key while y isave 160 409 395 336 text2 growbox 160 409 395 336 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_513a.gif 2 430 0 1 0 15 15 15 eff.exe b02_513b.gif 2 381 0 1 0 15 15 15 * You press Enter to copy the co isave 160 341 395 268 text3 growbox 160 341 395 268 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 160 341 image memory text2 0 160 409 image memory text1 0 160 455 * eff.exe b02_514a.gif 2 430 0 1 0 15 15 15 eff.exe b02_514b.gif 2 381 0 1 0 15 15 15 * You can also cut data by point isave 374 195 613 127 text1 textbox 374 195 613 127 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_515a.gif 2 379 0 1 0 15 15 15 eff.exe b02_515b.gif 2 160 0 1 0 15 15 15 * The cursor adopts the shape of isave 374 132 613 59 text2 growbox 374 132 613 59 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * When you drag data to a cell a notebox 324 376 615 ** image memory text2 0 374 132 image memory text1 0 374 195 * SimScrn 2 11 12 MoveCtrl 1 493 410 0 ********************************* eff.exe b02_517.gif 0 459 0 1 0 15 15 15 * Entire columns or rows of data isave 49 121 303 53 text1 textbox 49 121 303 53 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * This is also true for copying notebox 60 221 292 ** image memory text1 0 49 121 * eff.exe b02_519a.gif 200 376 0 1 0 15 15 15 eff.exe b02_519b.gif 330 191 0 1 0 15 15 15 * For example, we wish to copy c isave 24 231 323 180 text1 textbox 24 231 323 180 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_520a.gif 28 457 0 1 0 15 15 15 eff.exe b02_520b.gif 2 381 0 1 0 15 15 15 eff.exe b02_520c.gif 312 393 0 1 0 15 15 15 * The first step is to select th isave 24 185 323 129 text2 growbox 24 185 323 129 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_521a.gif 28 457 0 1 0 15 15 15 eff.exe b02_521b.gif 404 393 0 1 0 15 15 15 eff.exe b02_521c.gif 26 127 0 1 0 15 15 15 eff.exe b02_521d.gif 404 127 0 1 0 15 15 15 * With the column selected you p isave 24 134 323 78 text3 growbox 24 134 323 78 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe b02_522a.gif 26 434 0 1 0 15 15 15 * Then you select the destinatio isave 24 83 323 44 text4 growbox 24 83 323 44 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 24 83 image memory text3 0 24 134 image memory text2 0 24 185 image memory text1 0 24 231 * eff.exe b02_523a.gif 28 457 0 1 0 15 15 15 eff.exe b02_523b.gif 26 381 0 1 0 15 15 15 eff.exe b02_523c.gif 446 391 0 1 0 15 15 15 * Once you press Enter, column D isave 282 118 522 67 text1 textbox 282 118 522 67 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 282 118 * * Topic: Hands-on: Copying a column Topic No.: 4 **** SimScrn 2 12 12 MoveCtrl 1 493 500 0 * exercise 03 1 120 70 task 03 0203 402 300 235 4 120 67 35 75 * pause 1 1 1 1 1 1 1 1 **