Microsoft Office 2010

Introduction to Computers - Page 27
What Is a Computer? - Page 28
The Components of a Computer - Page 29
Personal Computers and Mobile Devices - Page 30
Input Devices - Page 31
Mouse and Other Pointing Devices - Page 32
Mouse and Other Pointing Devices - Page 33
System Unit - Page 34
Output Devices - Page 35
Display Devices - Page 36
Hard Disks - Page 37
Flash Memory Storage - Page 38
Flash Memory Storage - Page 39
Flash Memory Storage - Page 40
Optical Discs - Page 41
Optical Discs - Page 42
Cloud Storage - Page 43
Computer Software - Page 44
Computer Software - Page 45
Computer Software - Page 46
Networks and the Internet - Page 47
The Internet - Page 48
The Internet - Page 49
The World Wide Web - Page 50
Searching the Web - Page 51
Computer Viruses and Other Malware - Page 52
Buyer’s Guide: How to Purchase Computers and Mobile Devices - Page 53
How to Purchase a Desktop Computer - Page 54
How to Purchase a Desktop Computer - Page 55
How to Purchase a Desktop Computer - Page 56
How to Purchase a Desktop Computer - Page 57
How to Purchase a Notebook Computer - Page 58
How to Purchase a Notebook Computer - Page 59
How to Purchase a Notebook Computer - Page 60
How to Purchase a Smart Phone - Page 61
How to Purchase a Portable Media Player - Page 62
How to Purchase a Digital Camera - Page 63
How to Purchase a Digital Camera - Page 64
Learn It Online - Page 65
Index - Page 66
Microsoft Office 2010 and Windows 7 - Page 67
Office 2010 and Windows 7 - Page 68
Office 2010 and Windows 7 - Page 69
Office 2010 and Windows 7 - Page 70
Office 2010 and Windows 7 - Page 71
Office 2010 and Windows 7 - Page 72
Introduction to Microsoft Office 2010 - Page 73
Introduction to Microsoft Office 2010 - Page 74
Starting and Using a Program - Page 75
Starting and Using a Program - Page 76
Starting and Using a Program - Page 77
Starting and Using a Program - Page 78
Starting and Using a Program - Page 79
Starting and Using a Program - Page 80
Starting and Using a Program - Page 81
Starting and Using a Program - Page 82
Starting and Using a Program - Page 83
Starting and Using a Program - Page 84
Starting and Using a Program - Page 85
Starting and Using a Program - Page 86
Saving and Organizing Files - Page 87
Saving and Organizing Files - Page 88
Saving and Organizing Files - Page 89
Saving and Organizing Files - Page 90
Saving and Organizing Files - Page 91
Saving and Organizing Files - Page 92
Saving and Organizing Files - Page 93
Saving and Organizing Files - Page 94
Saving and Organizing Files - Page 95
Saving and Organizing Files - Page 96
Screen Resolution - Page 97
Screen Resolution - Page 98
Screen Resolution - Page 99
Screen Resolution - Page 100
Screen Resolution - Page 101
Additional Microsoft Office Programs - Page 102
Additional Microsoft Office Programs - Page 103
Additional Microsoft Office Programs - Page 104
Additional Microsoft Office Programs - Page 105
Additional Microsoft Office Programs - Page 106
Additional Microsoft Office Programs - Page 107
Additional Microsoft Office Programs - Page 108
Additional Microsoft Office Programs - Page 109
Additional Microsoft Office Programs - Page 110
Additional Microsoft Office Programs - Page 111
Additional Microsoft Office Programs - Page 112
Additional Microsoft Office Programs - Page 113
Additional Microsoft Office Programs - Page 114
Additional Microsoft Office Programs - Page 115
Additional Microsoft Office Programs - Page 116
Additional Microsoft Office Programs - Page 117
Additional Microsoft Office Programs - Page 118
Additional Microsoft Office Programs - Page 119
Additional Microsoft Office Programs - Page 120
Additional Microsoft Office Programs - Page 121
Additional Microsoft Office Programs - Page 122
Additional Microsoft Office Programs - Page 123
Other Office Programs - Page 124
Other Office Programs - Page 125
Other Office Programs - Page 126
Other Office Programs - Page 127
Moving, Renaming, and Deleting Files - Page 128
Moving, Renaming, and Deleting Files - Page 129
Moving, Renaming, and Deleting Files - Page 130
Moving, Renaming, and Deleting Files - Page 131
Microsoft Office and Windows Help - Page 132
Microsoft Office and Windows Help - Page 133
Microsoft Office and Windows Help - Page 134
Microsoft Office and Windows Help - Page 135
Microsoft Office and Windows Help - Page 136
Microsoft Office and Windows Help - Page 137
Microsoft Office and Windows Help - Page 138
Microsoft Office and Windows Help - Page 139
Chapter Summary - Page 140
Learn It Online - Page 141
Apply Your Knowledge - Page 142
Make It Right - Page 143
In the Lab - Page 144
In the Lab - Page 145
Cases and Places - Page 146
Microsoft Word 2010 - Page 147
Introduction - Page 148
Introduction - Page 149
Introduction - Page 150
Entering Text - Page 151
Entering Text - Page 152
Entering Text - Page 153
Entering Text - Page 154
Entering Text - Page 155
Entering Text - Page 156
Entering Text - Page 157
Formatting Paragraphs and Characters - Page 158
Formatting Paragraphs and Characters - Page 159
Formatting Paragraphs and Characters - Page 160
Formatting Paragraphs and Characters - Page 161
Formatting Paragraphs and Characters - Page 162
Formatting Paragraphs and Characters - Page 163
Formatting Paragraphs and Characters - Page 164
Formatting Paragraphs and Characters - Page 165
Formatting Paragraphs and Characters - Page 166
Formatting Paragraphs and Characters - Page 167
Formatting Paragraphs and Characters - Page 168
Formatting Paragraphs and Characters - Page 169
Formatting Paragraphs and Characters - Page 170
Formatting Paragraphs and Characters - Page 171
Formatting Paragraphs and Characters - Page 172
Formatting Paragraphs and Characters - Page 173
Formatting Paragraphs and Characters - Page 174
Formatting Paragraphs and Characters - Page 175
Inserting and Formatting Pictures in a Word Document - Page 176
Inserting and Formatting Pictures in a Word Document - Page 177
Inserting and Formatting Pictures in a Word Document - Page 178
Inserting and Formatting Pictures in a Word Document - Page 179
Inserting and Formatting Pictures in a Word Document - Page 180
Inserting and Formatting Pictures in a Word Document - Page 181
Inserting and Formatting Pictures in a Word Document - Page 182
Inserting and Formatting Pictures in a Word Document - Page 183
Inserting and Formatting Pictures in a Word Document - Page 184
Inserting and Formatting Pictures in a Word Document - Page 185
Enhancing the Page - Page 186
Enhancing the Page - Page 187
Enhancing the Page - Page 188
Enhancing the Page - Page 189
Correcting Errors and Revising a Document - Page 190
Correcting Errors and Revising a Document - Page 191
Correcting Errors and Revising a Document - Page 192
Correcting Errors and Revising a Document - Page 193
Correcting Errors and Revising a Document - Page 194
Changing Document Properties - Page 195
Changing Document Properties - Page 196
Printing a Document - Page 197
Printing a Document - Page 198
Chapter Summary - Page 199
Learn It Online - Page 200
Learn It Online - Page 201
Extend Your Knowledge - Page 202
Make It Right - Page 203
In the Lab - Page 204
In the Lab - Page 205
Cases and Places - Page 206
Cases and Places - Page 207
Cases and Places - Page 208
Cases and Places - Page 209
Cases and Places - Page 210
CHAPTER TWO Creating a Research Paper with Citations and References - Page 211
Introduction - Page 212
Introduction - Page 213
Introduction - Page 214
Changing Document Settings - Page 215
Changing Document Settings - Page 216
Changing Document Settings - Page 217
Changing Document Settings - Page 218
Changing Document Settings - Page 219
Changing Document Settings - Page 220
Changing Document Settings - Page 221
Changing Document Settings - Page 222
Changing Document Settings - Page 223
Typing the Research Paper Text - Page 224
Typing the Research Paper Text - Page 225
Typing the Research Paper Text - Page 226
Typing the Research Paper Text - Page 227
Typing the Research Paper Text - Page 228
Typing the Research Paper Text - Page 229
Typing the Research Paper Text - Page 230
Typing the Research Paper Text - Page 231
Typing the Research Paper Text - Page 232
Typing the Research Paper Text - Page 233
Typing the Research Paper Text - Page 234
Typing the Research Paper Text - Page 235
Typing the Research Paper Text - Page 236
Typing the Research Paper Text - Page 237
Typing the Research Paper Text - Page 238
Typing the Research Paper Text - Page 239
Typing the Research Paper Text - Page 240
Typing the Research Paper Text - Page 241
Typing the Research Paper Text - Page 242
Typing the Research Paper Text - Page 243
Typing the Research Paper Text - Page 244
Typing the Research Paper Text - Page 245
Typing the Research Paper Text - Page 246
Typing the Research Paper Text - Page 247
Typing the Research Paper Text - Page 248
Typing the Research Paper Text - Page 249
Typing the Research Paper Text - Page 250
Creating an Alphabetical Works Cited Page - Page 251
Creating an Alphabetical Works Cited Page - Page 252
Creating an Alphabetical Works Cited Page - Page 253
Creating an Alphabetical Works Cited Page - Page 254
Creating an Alphabetical Works Cited Page - Page 255
Creating an Alphabetical Works Cited Page - Page 256
Creating an Alphabetical Works Cited Page - Page 257
Proofing and Revising the Research Paper - Page 258
Proofing and Revising the Research Paper - Page 259
Proofing and Revising the Research Paper - Page 260
Proofing and Revising the Research Paper - Page 261
Proofing and Revising the Research Paper - Page 262
Proofing and Revising the Research Paper - Page 263
Proofing and Revising the Research Paper - Page 264
Proofing and Revising the Research Paper - Page 265
Proofing and Revising the Research Paper - Page 266
Proofing and Revising the Research Paper - Page 267
Proofing and Revising the Research Paper - Page 268
Proofing and Revising the Research Paper - Page 269
Proofing and Revising the Research Paper - Page 270
Chapter Summary - Page 271
Learn It Online - Page 272
Learn It Online - Page 273
Extend Your Knowledge - Page 274
Make It Right - Page 275
In the Lab - Page 276
In the Lab - Page 277
In the Lab - Page 278
In the Lab - Page 279
In the Lab - Page 280
In the Lab - Page 281
Cases and Places - Page 282
CHAPTER THREE Creating a Business Letter with a Letterhead and Table - Page 283
Introduction - Page 284
Introduction - Page 285
Introduction - Page 286
Introduction - Page 287
Creating a Letterhead - Page 288
Creating a Letterhead - Page 289
Creating a Letterhead - Page 290
Creating a Letterhead - Page 291
Creating a Letterhead - Page 292
Creating a Letterhead - Page 293
Creating a Letterhead - Page 294
Creating a Letterhead - Page 295
Creating a Letterhead - Page 296
Creating a Letterhead - Page 297
Creating a Letterhead - Page 298
Creating a Letterhead - Page 299
Creating a Letterhead - Page 300
Creating a Letterhead - Page 301
Creating a Letterhead - Page 302
Creating a Letterhead - Page 303
Creating a Letterhead - Page 304
Creating a Letterhead - Page 305
Creating a Letterhead - Page 306
Creating a Letterhead - Page 307
Creating a Letterhead - Page 308
Creating a Letterhead - Page 309
Creating a Business Letter - Page 310
Creating a Business Letter - Page 311
Creating a Business Letter - Page 312
Creating a Business Letter - Page 313
Creating a Business Letter - Page 314
Creating a Business Letter - Page 315
Creating a Business Letter - Page 316
Creating a Business Letter - Page 317
Creating a Business Letter - Page 318
Creating a Business Letter - Page 319
Creating a Business Letter - Page 320
Creating a Business Letter - Page 321
Creating a Business Letter - Page 322
Creating a Business Letter - Page 323
Creating a Business Letter - Page 324
Creating a Business Letter - Page 325
Creating a Business Letter - Page 326
Creating a Business Letter - Page 327
Creating a Business Letter - Page 328
Creating a Business Letter - Page 329
Creating a Business Letter - Page 330
Creating a Business Letter - Page 331
Creating a Business Letter - Page 332
Creating a Business Letter - Page 333
Creating a Business Letter - Page 334
Addressing and Printing Envelopes and Mailing Labels - Page 335
Chapter Summary - Page 336
Learn It Online - Page 337
Extend Your Knowledge - Page 338
Extend Your Knowledge - Page 339
Make It Right - Page 340
In the Lab - Page 341
In the Lab - Page 342
In the Lab - Page 343
In the Lab - Page 344
Cases and Places - Page 345
Cases and Places - Page 346
Microsoft PowerPoint 2010 - Page 347
Introduction - Page 348
Introduction - Page 349
Introduction - Page 350
Choosing a Document Theme - Page 351
Choosing a Document Theme - Page 352
Creating a Title Slide - Page 353
Creating a Title Slide - Page 354
Creating a Title Slide - Page 355
Formatting Characters in a Presentation - Page 356
Formatting Characters in a Presentation - Page 357
Formatting Characters in a Presentation - Page 358
Formatting Characters in a Presentation - Page 359
Adding a New Slide to a Presentation - Page 360
Creating a Text Slide with a Multi-Level Bulleted List - Page 361
Creating a Text Slide with a Multi-Level Bulleted List - Page 362
Creating a Text Slide with a Multi-Level Bulleted List - Page 363
Creating a Text Slide with a Multi-Level Bulleted List - Page 364
Creating a Text Slide with a Multi-Level Bulleted List - Page 365
Creating a Text Slide with a Multi-Level Bulleted List - Page 366
Adding New Slides and Changing the Slide Layouts - Page 367
Adding New Slides and Changing the Slide Layouts - Page 368
Adding New Slides and Changing the Slide Layouts - Page 369
PowerPoint Views - Page 370
PowerPoint Views - Page 371
Inserting Clip Art and Photographs into Slides - Page 372
Inserting Clip Art and Photographs into Slides - Page 373
Inserting Clip Art and Photographs into Slides - Page 374
Inserting Clip Art and Photographs into Slides - Page 375
Inserting Clip Art and Photographs into Slides - Page 376
Photographs and the Clip Organizer - Page 377
Photographs and the Clip Organizer - Page 378
Resizing Clip Art and Photographs - Page 379
Resizing Clip Art and Photographs - Page 380
Resizing Clip Art and Photographs - Page 381
Resizing Clip Art and Photographs - Page 382
Resizing Clip Art and Photographs - Page 383
Ending a Slide Show with a Closing Slide - Page 384
Ending a Slide Show with a Closing Slide - Page 385
Making Changes to Slide Text Content - Page 386
Making Changes to Slide Text Content - Page 387
Making Changes to Slide Text Content - Page 388
Adding a Transition - Page 389
Adding a Transition - Page 390
Changing Document Properties - Page 391
Changing Document Properties - Page 392
Viewing the Presentation in Slide Show View - Page 393
Viewing the Presentation in Slide Show View - Page 394
Viewing the Presentation in Slide Show View - Page 395
Viewing the Presentation in Slide Show View - Page 396
Printing a Presentation - Page 397
Printing a Presentation - Page 398
Printing a Presentation - Page 399
Chapter Summary - Page 400
Learn It Online - Page 401
Learn It Online - Page 402
Extend Your Knowledge - Page 403
Make It Right - Page 404
In the Lab - Page 405
In the Lab - Page 406
In the Lab - Page 407
In the Lab - Page 408
In the Lab - Page 409
In the Lab - Page 410
In the Lab - Page 411
In the Lab - Page 412
In the Lab - Page 413
In the Lab - Page 414
In the Lab - Page 415
Cases and Places - Page 416
Cases and Places - Page 417
Cases and Places - Page 418
CHAPTER TWO Enhancing a Presentation with Pictures, Shapes, and WordArt - Page 419
Introduction - Page 420
Introduction - Page 421
Starting PowerPoint - Page 422
Creating Slides and Changing Font Colors and Background Style - Page 423
Creating Slides and Changing Font Colors and Background Style - Page 424
Creating Slides and Changing Font Colors and Background Style - Page 425
Creating Slides and Changing Font Colors and Background Style - Page 426
Creating Slides and Changing Font Colors and Background Style - Page 427
Inserting and Formatting Pictures in a Presentation - Page 428
Inserting and Formatting Pictures in a Presentation - Page 429
Inserting and Formatting Pictures in a Presentation - Page 430
Inserting and Formatting Pictures in a Presentation - Page 431
Inserting and Formatting Pictures in a Presentation - Page 432
Inserting and Formatting Pictures in a Presentation - Page 433
Inserting and Formatting Pictures in a Presentation - Page 434
Inserting and Formatting Pictures in a Presentation - Page 435
Inserting and Formatting Pictures in a Presentation - Page 436
Inserting and Formatting Pictures in a Presentation - Page 437
Inserting and Formatting Pictures in a Presentation - Page 438
Inserting and Formatting Pictures in a Presentation - Page 439
Inserting and Formatting Pictures in a Presentation - Page 440
Formatting Slide Backgrounds - Page 441
Formatting Slide Backgrounds - Page 442
Formatting Slide Backgrounds - Page 443
Formatting Slide Backgrounds - Page 444
Formatting Slide Backgrounds - Page 445
Formatting Slide Backgrounds - Page 446
Formatting Title and Content Text - Page 447
Formatting Title and Content Text - Page 448
Formatting Title and Content Text - Page 449
Formatting Title and Content Text - Page 450
Formatting Title and Content Text - Page 451
Adding and Formatting a Shape - Page 452
Adding and Formatting a Shape - Page 453
Adding and Formatting a Shape - Page 454
Adding and Formatting a Shape - Page 455
Adding and Formatting a Shape - Page 456
Adding and Formatting a Shape - Page 457
Adding and Formatting a Shape - Page 458
Using WordArt - Page 459
Using WordArt - Page 460
Using WordArt - Page 461
Using WordArt - Page 462
Using WordArt - Page 463
Using WordArt - Page 464
Using WordArt - Page 465
Using WordArt - Page 466
Using WordArt - Page 467
Chapter Summary - Page 468
Learn It Online - Page 469
Learn It Online - Page 470
Learn It Online - Page 471
Extend Your Knowledge - Page 472
Extend Your Knowledge - Page 473
Extend Your Knowledge - Page 474
Make It Right - Page 475
In the Lab - Page 476
In the Lab - Page 477
In the Lab - Page 478
In the Lab - Page 479
In the Lab - Page 480
In the Lab - Page 481
Cases and Places - Page 482
CHAPTER THREE Reusing a Presentation and Adding Media - Page 483
Introduction - Page 484
Introduction - Page 485
Starting PowerPoint - Page 486
Inserting Pictures and Adding Effects - Page 487
Inserting Pictures and Adding Effects - Page 488
Inserting Pictures and Adding Effects - Page 489
Inserting Pictures and Adding Effects - Page 490
Inserting Pictures and Adding Effects - Page 491
Inserting Pictures and Adding Effects - Page 492
Inserting Pictures and Adding Effects - Page 493
Modifying Placeholders and Deleting a Slide - Page 494
Modifying Placeholders and Deleting a Slide - Page 495
Modifying Placeholders and Deleting a Slide - Page 496
Modifying Placeholders and Deleting a Slide - Page 497
Modifying Placeholders and Deleting a Slide - Page 498
Modifying Placeholders and Deleting a Slide - Page 499
Copying and Modifying a Clip - Page 500
Copying and Modifying a Clip - Page 501
Copying and Modifying a Clip - Page 502
Copying and Modifying a Clip - Page 503
Copying and Modifying a Clip - Page 504
Copying and Modifying a Clip - Page 505
Copying and Modifying a Clip - Page 506
Copying and Modifying a Clip - Page 507
Copying and Modifying a Clip - Page 508
Adding Media to Slides - Page 509
Adding Media to Slides - Page 510
Adding Media to Slides - Page 511
Adding Media to Slides - Page 512
Adding Media to Slides - Page 513
Adding Media to Slides - Page 514
Adding Media to Slides - Page 515
Adding Media to Slides - Page 516
Adding Media to Slides - Page 517
Adding Media to Slides - Page 518
Adding Media to Slides - Page 519
Adding Media to Slides - Page 520
Adding Media to Slides - Page 521
Reviewing and Revising Individual Slides - Page 522
Reviewing and Revising Individual Slides - Page 523
Reviewing and Revising Individual Slides - Page 524
Reviewing and Revising Individual Slides - Page 525
Reviewing and Revising Individual Slides - Page 526
Reviewing and Revising Individual Slides - Page 527
Reviewing and Revising Individual Slides - Page 528
Reviewing and Revising Individual Slides - Page 529
Reviewing and Revising Individual Slides - Page 530
Reviewing and Revising Individual Slides - Page 531
Reviewing and Revising Individual Slides - Page 532
Reviewing and Revising Individual Slides - Page 533
Reviewing and Revising Individual Slides - Page 534
Reviewing and Revising Individual Slides - Page 535
Chapter Summary - Page 536
Apply Your Knowledge - Page 537
Apply Your Knowledge - Page 538
Apply Your Knowledge - Page 539
Make It Right - Page 540
In the Lab - Page 541
In the Lab - Page 542
In the Lab - Page 543
In the Lab - Page 544
In the Lab - Page 545
Cases and Places - Page 546
Microsoft Excel 2010 - Page 547
Introduction - Page 548
Introduction - Page 549
Introduction - Page 550
Introduction - Page 551
Introduction - Page 552
Selecting a Cell - Page 553
Selecting a Cell - Page 554
Selecting a Cell - Page 555
Selecting a Cell - Page 556
Selecting a Cell - Page 557
Selecting a Cell - Page 558
Entering Numbers - Page 559
Entering Numbers - Page 560
Calculating a Sum - Page 561
Using the Fill Handle to Copy a Cell to Adjacent Cells - Page 562
Using the Fill Handle to Copy a Cell to Adjacent Cells - Page 563
Using the Fill Handle to Copy a Cell to Adjacent Cells - Page 564
Using the Fill Handle to Copy a Cell to Adjacent Cells - Page 565
Formatting the Worksheet - Page 566
Formatting the Worksheet - Page 567
Formatting the Worksheet - Page 568
Formatting the Worksheet - Page 569
Formatting the Worksheet - Page 570
Formatting the Worksheet - Page 571
Formatting the Worksheet - Page 572
Formatting the Worksheet - Page 573
Formatting the Worksheet - Page 574
Formatting the Worksheet - Page 575
Formatting the Worksheet - Page 576
Formatting the Worksheet - Page 577
Formatting the Worksheet - Page 578
Formatting the Worksheet - Page 579
Using the Name Box to Select a Cell - Page 580
Using the Name Box to Select a Cell - Page 581
Adding a Clustered Cylinder Chart to the Worksheet - Page 582
Adding a Clustered Cylinder Chart to the Worksheet - Page 583
Adding a Clustered Cylinder Chart to the Worksheet - Page 584
Adding a Clustered Cylinder Chart to the Worksheet - Page 585
Adding a Clustered Cylinder Chart to the Worksheet - Page 586
Adding a Clustered Cylinder Chart to the Worksheet - Page 587
Changing the Worksheet Names - Page 588
Changing Document Properties - Page 589
Changing Document Properties - Page 590
Previewing and Printing a Worksheet - Page 591
Previewing and Printing a Worksheet - Page 592
Starting Excel and Opening a Workbook - Page 593
AutoCalculate - Page 594
Correcting Errors - Page 595
Correcting Errors - Page 596
Correcting Errors - Page 597
Correcting Errors - Page 598
Chapter Summary - Page 599
Learn It Online - Page 600
Learn It Online - Page 601
Extend Your Knowledge - Page 602
Make It Right - Page 603
In the Lab - Page 604
In the Lab - Page 605
In the Lab - Page 606
In the Lab - Page 607
In the Lab - Page 608
Cases and Places - Page 609
Cases and Places - Page 610
CHAPTER TWO Formulas, Functions, and Formatting - Page 611
Introduction - Page 612
Introduction - Page 613
Introduction - Page 614
Introduction - Page 615
Introduction - Page 616
Entering the Titles and Numbers into the Worksheet - Page 617
Entering the Titles and Numbers into the Worksheet - Page 618
Entering the Titles and Numbers into the Worksheet - Page 619
Entering Formulas - Page 620
Entering Formulas - Page 621
Entering Formulas - Page 622
Entering Formulas - Page 623
Entering Formulas - Page 624
Entering Formulas - Page 625
Entering Formulas - Page 626
Entering Formulas - Page 627
Option Buttons - Page 628
Option Buttons - Page 629
Using the AVERAGE, MAX, and MIN Functions - Page 630
Using the AVERAGE, MAX, and MIN Functions - Page 631
Using the AVERAGE, MAX, and MIN Functions - Page 632
Using the AVERAGE, MAX, and MIN Functions - Page 633
Using the AVERAGE, MAX, and MIN Functions - Page 634
Using the AVERAGE, MAX, and MIN Functions - Page 635
Using the AVERAGE, MAX, and MIN Functions - Page 636
Verifying Formulas Using Range Finder - Page 637
Formatting the Worksheet - Page 638
Formatting the Worksheet - Page 639
Formatting the Worksheet - Page 640
Formatting the Worksheet - Page 641
Formatting the Worksheet - Page 642
Formatting the Worksheet - Page 643
Formatting the Worksheet - Page 644
Formatting the Worksheet - Page 645
Formatting the Worksheet - Page 646
Formatting the Worksheet - Page 647
Formatting the Worksheet - Page 648
Formatting the Worksheet - Page 649
Formatting the Worksheet - Page 650
Formatting the Worksheet - Page 651
Formatting the Worksheet - Page 652
Formatting the Worksheet - Page 653
Formatting the Worksheet - Page 654
Formatting the Worksheet - Page 655
Formatting the Worksheet - Page 656
Formatting the Worksheet - Page 657
Checking Spelling - Page 658
Checking Spelling - Page 659
Preparing to Print the Worksheet - Page 660
Preparing to Print the Worksheet - Page 661
Preparing to Print the Worksheet - Page 662
Printing the Worksheet - Page 663
Printing the Worksheet - Page 664
Displaying and Printing the Formulas Version of the Worksheet - Page 665
Displaying and Printing the Formulas Version of the Worksheet - Page 666
Chapter Summary - Page 667
Learn It Online - Page 668
Learn It Online - Page 669
Extend Your Knowledge - Page 670
Make It Right - Page 671
In the Lab - Page 672
In the Lab - Page 673
In the Lab - Page 674
In the Lab - Page 675
In the Lab - Page 676
In the Lab - Page 677
In the Lab - Page 678
In the Lab - Page 679
Cases and Places - Page 680
Cases and Places - Page 681
Cases and Places - Page 682
CHAPTER THREE What-If Analysis, Charting, and Working with Large Worksheets - Page 683
Introduction - Page 684
Introduction - Page 685
Introduction - Page 686
Introduction - Page 687
Introduction - Page 688
Introduction - Page 689
Rotating Text and Using the Fill Handle to Create a Series - Page 690
Rotating Text and Using the Fill Handle to Create a Series - Page 691
Rotating Text and Using the Fill Handle to Create a Series - Page 692
Rotating Text and Using the Fill Handle to Create a Series - Page 693
Rotating Text and Using the Fill Handle to Create a Series - Page 694
Rotating Text and Using the Fill Handle to Create a Series - Page 695
Rotating Text and Using the Fill Handle to Create a Series - Page 696
Copying a Range of Cells to a Nonadjacent Destination Area - Page 697
Copying a Range of Cells to a Nonadjacent Destination Area - Page 698
Copying a Range of Cells to a Nonadjacent Destination Area - Page 699
Inserting and Deleting Cells in a Worksheet - Page 700
Inserting and Deleting Cells in a Worksheet - Page 701
Inserting and Deleting Cells in a Worksheet - Page 702
Inserting and Deleting Cells in a Worksheet - Page 703
Inserting and Deleting Cells in a Worksheet - Page 704
Inserting and Deleting Cells in a Worksheet - Page 705
Inserting and Deleting Cells in a Worksheet - Page 706
Inserting and Deleting Cells in a Worksheet - Page 707
Absolute versus Relative Addressing - Page 708
Absolute versus Relative Addressing - Page 709
Making Decisions — The IF Function - Page 710
Making Decisions — The IF Function - Page 711
Making Decisions — The IF Function - Page 712
Making Decisions — The IF Function - Page 713
Making Decisions — The IF Function - Page 714
Making Decisions — The IF Function - Page 715
Adding and Formatting Sparkline Charts - Page 716
Adding and Formatting Sparkline Charts - Page 717
Adding and Formatting Sparkline Charts - Page 718
Formatting the Worksheet - Page 719
Formatting the Worksheet - Page 720
Formatting the Worksheet - Page 721
Formatting the Worksheet - Page 722
Formatting the Worksheet - Page 723
Formatting the Worksheet - Page 724
Formatting the Worksheet - Page 725
Adding a 3-D Pie Chart to the Workbook - Page 726
Adding a 3-D Pie Chart to the Workbook - Page 727
Adding a 3-D Pie Chart to the Workbook - Page 728
Adding a 3-D Pie Chart to the Workbook - Page 729
Adding a 3-D Pie Chart to the Workbook - Page 730
Adding a 3-D Pie Chart to the Workbook - Page 731
Adding a 3-D Pie Chart to the Workbook - Page 732
Adding a 3-D Pie Chart to the Workbook - Page 733
Adding a 3-D Pie Chart to the Workbook - Page 734
Adding a 3-D Pie Chart to the Workbook - Page 735
Adding a 3-D Pie Chart to the Workbook - Page 736
Adding a 3-D Pie Chart to the Workbook - Page 737
Adding a 3-D Pie Chart to the Workbook - Page 738
Renaming and Reordering the Sheets and Coloring their Tabs - Page 739
Renaming and Reordering the Sheets and Coloring their Tabs - Page 740
Renaming and Reordering the Sheets and Coloring their Tabs - Page 741
Changing the View of the Worksheet - Page 742
Changing the View of the Worksheet - Page 743
Changing the View of the Worksheet - Page 744
What-If Analysis - Page 745
What-If Analysis - Page 746
What-If Analysis - Page 747
What-If Analysis - Page 748
Chapter Summary - Page 749
Learn It Online - Page 750
Learn It Online - Page 751
Extend Your Knowledge - Page 752
Extend Your Knowledge - Page 753
Make It Right - Page 754
In the Lab - Page 755
In the Lab - Page 756
In the Lab - Page 757
In the Lab - Page 758
In the Lab - Page 759
In the Lab - Page 760
In the Lab - Page 761
In the Lab - Page 762
In the Lab - Page 763
In the Lab - Page 764
In the Lab - Page 765
In the Lab - Page 766
Cases and Places - Page 767
Cases and Places - Page 768
Cases and Places - Page 769
Cases and Places - Page 770
Microsoft Access 2010 - Page 771
Introduction - Page 772
Introduction - Page 773
Introduction - Page 774
Introduction - Page 775
Designing a Database - Page 776
Designing a Database - Page 777
Designing a Database - Page 778
Designing a Database - Page 779
Designing a Database - Page 780
Designing a Database - Page 781
Designing a Database - Page 782
Creating a Database - Page 783
Creating a Database - Page 784
The Access Window - Page 785
The Access Window - Page 786
The Access Window - Page 787
The Access Window - Page 788
The Access Window - Page 789
The Access Window - Page 790
The Access Window - Page 791
The Access Window - Page 792
The Access Window - Page 793
The Access Window - Page 794
The Access Window - Page 795
The Access Window - Page 796
The Access Window - Page 797
The Access Window - Page 798
The Access Window - Page 799
Previewing and Printing the Contents of a Table - Page 800
Previewing and Printing the Contents of a Table - Page 801
Creating Additional Tables - Page 802
Creating Additional Tables - Page 803
Creating Additional Tables - Page 804
Creating Additional Tables - Page 805
Creating Additional Tables - Page 806
Creating Additional Tables - Page 807
Importing Data from Other Applications to Access - Page 808
Importing Data from Other Applications to Access - Page 809
Importing Data from Other Applications to Access - Page 810
Importing Data from Other Applications to Access - Page 811
Additional Database Objects - Page 812
Additional Database Objects - Page 813
Additional Database Objects - Page 814
Additional Database Objects - Page 815
Additional Database Objects - Page 816
Additional Database Objects - Page 817
Additional Database Objects - Page 818
Additional Database Objects - Page 819
Additional Database Objects - Page 820
Additional Database Objects - Page 821
Additional Database Objects - Page 822
Additional Database Objects - Page 823
Additional Database Objects - Page 824
Additional Database Objects - Page 825
Additional Database Objects - Page 826
Additional Database Objects - Page 827
Database Properties - Page 828
Database Properties - Page 829
Special Database Operations - Page 830
Special Database Operations - Page 831
Special Database Operations - Page 832
Chapter Summary - Page 833
Apply Your Knowledge - Page 834
Extend Your Knowledge - Page 835
Make It Right - Page 836
Make It Right - Page 837
Make It Right - Page 838
Make It Right - Page 839
Make It Right - Page 840
Make It Right - Page 841
Cases and Places - Page 842
CHAPTER TWO Querying a Database - Page 843
Introduction - Page 844
Introduction - Page 845
Introduction - Page 846
Creating Queries - Page 847
Creating Queries - Page 848
Creating Queries - Page 849
Creating Queries - Page 850
Creating Queries - Page 851
Creating Queries - Page 852
Creating Queries - Page 853
Creating Queries - Page 854
Creating Queries - Page 855
Creating Queries - Page 856
Creating Queries - Page 857
Creating Queries - Page 858
Creating Queries - Page 859
Creating Queries - Page 860
Creating Queries - Page 861
Creating Queries - Page 862
Creating Queries - Page 863
Sorting - Page 864
Sorting - Page 865
Sorting - Page 866
Sorting - Page 867
Sorting - Page 868
Sorting - Page 869
Joining Tables - Page 870
Joining Tables - Page 871
Joining Tables - Page 872
Joining Tables - Page 873
Joining Tables - Page 874
Joining Tables - Page 875
Joining Tables - Page 876
Joining Tables - Page 877
Creating a Form for a Query - Page 878
Creating a Form for a Query - Page 879
Exporting Data from Access to Other Applications - Page 880
Exporting Data from Access to Other Applications - Page 881
Exporting Data from Access to Other Applications - Page 882
Exporting Data from Access to Other Applications - Page 883
Adding Criteria to a Join Query - Page 884
Calculations - Page 885
Calculations - Page 886
Calculations - Page 887
Calculations - Page 888
Calculations - Page 889
Calculations - Page 890
Calculations - Page 891
Calculations - Page 892
Crosstab Queries - Page 893
Crosstab Queries - Page 894
Crosstab Queries - Page 895
Crosstab Queries - Page 896
Crosstab Queries - Page 897
Chapter Summary - Page 898
Learn It Online - Page 899
Extend Your Knowledge - Page 900
Make It Right - Page 901
In the Lab - Page 902
In the Lab - Page 903
In the Lab - Page 904
Cases and Places - Page 905
Cases and Places - Page 906
CHAPTER THREE Maintaining a Database - Page 907
Introduction - Page 908
Introduction - Page 909
Introduction - Page 910
Updating Records - Page 911
Updating Records - Page 912
Updating Records - Page 913
Updating Records - Page 914
Updating Records - Page 915
Updating Records - Page 916
Filtering Records - Page 917
Filtering Records - Page 918
Filtering Records - Page 919
Filtering Records - Page 920
Filtering Records - Page 921
Filtering Records - Page 922
Filtering Records - Page 923
Changing the Database Structure - Page 924
Changing the Database Structure - Page 925
Changing the Database Structure - Page 926
Changing the Database Structure - Page 927
Changing the Database Structure - Page 928
Changing the Database Structure - Page 929
Changing the Database Structure - Page 930
Mass Changes - Page 931
Mass Changes - Page 932
Mass Changes - Page 933
Mass Changes - Page 934
Validation Rules - Page 935
Validation Rules - Page 936
Validation Rules - Page 937
Validation Rules - Page 938
Validation Rules - Page 939
Validation Rules - Page 940
Validation Rules - Page 941
Validation Rules - Page 942
Validation Rules - Page 943
Validation Rules - Page 944
Validation Rules - Page 945
Validation Rules - Page 946
Validation Rules - Page 947
Validation Rules - Page 948
Changing the Appearance of a Datasheet - Page 949
Changing the Appearance of a Datasheet - Page 950
Changing the Appearance of a Datasheet - Page 951
Changing the Appearance of a Datasheet - Page 952
Multivalued Fields in Queries - Page 953
Multivalued Fields in Queries - Page 954
Referential Integrity - Page 955
Referential Integrity - Page 956
Referential Integrity - Page 957
Referential Integrity - Page 958
Referential Integrity - Page 959
Referential Integrity - Page 960
Referential Integrity - Page 961
Referential Integrity - Page 962
Ordering Records - Page 963
Ordering Records - Page 964
Ordering Records - Page 965
Chapter Summary - Page 966
Learn It Online - Page 967
Learn It Online - Page 968
Extend Your Knowledge - Page 969
Make It Right - Page 970
In the Lab - Page 971
In the Lab - Page 972
In the Lab - Page 973
In the Lab - Page 974
Cases and Places - Page 975
Cases and Places - Page 976
Cases and Places - Page 977
Cases and Places - Page 978
Microsoft Outlook 2010 - Page 979
Introduction - Page 980
Project — Composing and Sending E-Mail Messages - Page 981
Project — Composing and Sending E-Mail Messages - Page 982
Project — Composing and Sending E-Mail Messages - Page 983
Project — Composing and Sending E-Mail Messages - Page 984
Project — Composing and Sending E-Mail Messages - Page 985
Composing and Sending E-Mail Messages - Page 986
Composing and Sending E-Mail Messages - Page 987
Composing and Sending E-Mail Messages - Page 988
Composing and Sending E-Mail Messages - Page 989
Working with Incoming Messages - Page 990
Working with Incoming Messages - Page 991
Working with Incoming Messages - Page 992
Working with Incoming Messages - Page 993
Working with Incoming Messages - Page 994
Working with Incoming Messages - Page 995
Working with Incoming Messages - Page 996
Working with Incoming Messages - Page 997
Working with Incoming Messages - Page 998
Working with Incoming Messages - Page 999
Working with Incoming Messages - Page 1000
Working with Incoming Messages - Page 1001
Working with Incoming Messages - Page 1002
Working with Incoming Messages - Page 1003
Working with Incoming Messages - Page 1004
Working with Incoming Messages - Page 1005
Working with Incoming Messages - Page 1006
Working with Incoming Messages - Page 1007
Working with Incoming Messages - Page 1008
Working with Incoming Messages - Page 1009
Working with Incoming Messages - Page 1010
Working with Incoming Messages - Page 1011
Working with Incoming Messages - Page 1012
Using Outlook Folders to Organize the Inbox - Page 1013
Using Outlook Folders to Organize the Inbox - Page 1014
Using Outlook Folders to Organize the Inbox - Page 1015
Using Outlook Folders to Organize the Inbox - Page 1016
Chapter Summary - Page 1017
Apply Your Knowledge - Page 1018
Extend Your Knowledge - Page 1019
Make It Right - Page 1020
In the Lab - Page 1021
In the Lab - Page 1022
In the Lab - Page 1023
In the Lab - Page 1024
Cases and Places - Page 1025
Cases and Places - Page 1026
CHAPTER TWO Managing Calendars - Page 1027
Introduction - Page 1028
Introduction - Page 1029
Introduction - Page 1030
Introduction - Page 1031
Introduction - Page 1032
Introduction - Page 1033
Introduction - Page 1034
Viewing the Calendar - Page 1035
Viewing the Calendar - Page 1036
Viewing the Calendar - Page 1037
Viewing the Calendar - Page 1038
Creating and Editing Appointments - Page 1039
Creating and Editing Appointments - Page 1040
Creating and Editing Appointments - Page 1041
Creating and Editing Appointments - Page 1042
Creating and Editing Appointments - Page 1043
Creating and Editing Appointments - Page 1044
Creating and Editing Appointments - Page 1045
Creating and Editing Appointments - Page 1046
Creating and Editing Appointments - Page 1047
Creating and Editing Appointments - Page 1048
Creating and Editing Appointments - Page 1049
Creating and Editing Appointments - Page 1050
Creating and Editing Appointments - Page 1051
Creating and Editing Appointments - Page 1052
Creating and Editing Appointments - Page 1053
Creating and Editing Appointments - Page 1054
Creating and Editing Appointments - Page 1055
Creating and Editing Appointments - Page 1056
Creating and Editing Appointments - Page 1057
Creating and Editing Appointments - Page 1058
Creating and Editing Appointments - Page 1059
Creating and Editing Appointments - Page 1060
Creating and Editing Appointments - Page 1061
Creating and Editing Events - Page 1062
Creating and Editing Events - Page 1063
Creating and Editing Events - Page 1064
Creating and Editing Events - Page 1065
Creating and Editing Events - Page 1066
Creating and Editing Events - Page 1067
Creating and Editing Events - Page 1068
Creating and Editing Events - Page 1069
Creating and Editing Meetings - Page 1070
Creating and Editing Meetings - Page 1071
Creating and Editing Meetings - Page 1072
Creating and Editing Meetings - Page 1073
Creating and Editing Meetings - Page 1074
Creating and Editing Meetings - Page 1075
Creating and Editing Meetings - Page 1076
Printing Calendars in Different Views - Page 1077
Printing Calendars in Different Views - Page 1078
Printing Calendars in Different Views - Page 1079
Printing Calendars in Different Views - Page 1080
Printing Calendars in Different Views - Page 1081
Exporting and Importing Folders - Page 1082
Exporting and Importing Folders - Page 1083
Exporting and Importing Folders - Page 1084
Exporting and Importing Folders - Page 1085
Exporting and Importing Folders - Page 1086
Exporting and Importing Folders - Page 1087
Chapter Summary - Page 1088
Learn It Online - Page 1089
Extend Your Knowledge - Page 1090
Extend Your Knowledge - Page 1091
Make It Right - Page 1092
In the Lab - Page 1093
In the Lab - Page 1094
In the Lab - Page 1095
Cases and Places - Page 1096
Cases and Places - Page 1097
Cases and Places - Page 1098
Cases and Places - Page 1099
Cases and Places - Page 1100
Cases and Places - Page 1101
Cases and Places - Page 1102
Appendices - Page 1103
Summary - Page 1104
APPENDIX B Publishing Office 2010 Web Pages Online - Page 1105
APPENDIX B Publishing Office 2010 Web Pages Online - Page 1106
APPENDIX C Saving to the Web Using Windows Live DkyDrive - Page 1107
APPENDIX C Saving to the Web Using Windows Live DkyDrive - Page 1108
APPENDIX C Saving to the Web Using Windows Live DkyDrive - Page 1109
APPENDIX C Saving to the Web Using Windows Live DkyDrive - Page 1110
APPENDIX C Saving to the Web Using Windows Live DkyDrive - Page 1111
APPENDIX C Saving to the Web Using Windows Live DkyDrive - Page 1112
APPENDIX C Saving to the Web Using Windows Live DkyDrive - Page 1113
APPENDIX C Saving to the Web Using Windows Live DkyDrive - Page 1114
Capstone Projects - Page 1115
Word Capstone Project - Page 1116
PowerPoint Capstone Project - Page 1117
PowerPoint Capstone Project - Page 1118
PowerPoint Capstone Project - Page 1119
PowerPoint Capstone Project - Page 1120
Excel Capstone Project - Page 1121
Excel Capstone Project - Page 1122
Excel Capstone Project - Page 1123
Access Capstone Project - Page 1124
Access Capstone Project - Page 1125
Access Capstone Project - Page 1126
Access Capstone Project - Page 1127
Access Capstone Project - Page 1128
Access Capstone Project - Page 1129