Excel 2010 Bible

xliii Introduction On the CD This icon indicates that a related example or file is available on the companion CD-ROM. n New Feat ...

xliv Introduction l You’re stuck while trying to do something. l You need to do something that you’ve never done. l You have som ...

T he chapters in this part are intended to provide essential background information for working with Excel. Here, you’ll see how ...

04_474877-pp01.indd 204_474877-pp01.indd 2 3/29/10 11:33 PM3/29/10 11:33 PM ...

3 CHAPTER Introducing Excel IN THIS CHAPTER Understanding what Excel is used for What’s new for Excel 2010 Learning the parts of ...

Part I: Getting Started with Excel 4 l (^) Creating graphics and diagrams: Use Shapes and the new SmartArt to create professiona ...

Chapter 1: Introducing Excel 5 l (^) Ribbon customization: You can customize the Ribbon by adding new tabs and groups. l Equatio ...

Part I: Getting Started with Excel 6 FIGURE 1.1 The Excel screen has many useful elements that you will use often. File button N ...

Chapter 1: Introducing Excel 7 TABLE 1.1 Parts of the Excel Screen That You Need to Know Name Description Active cell indicator ...

Part I: Getting Started with Excel 8 TABLE 1.1 (continued) Name Description Status bar This bar displays various messages as wel ...

Chapter 1: Introducing Excel 9 FIGURE 1.2 The active cell is the cell with the dark border — in this case, cell C8. Navigating w ...

Part I: Getting Started with Excel 10 TABLE 1.2 Excel Worksheet Movement Keys Key Action Up arrow (↑) Moves the active cell up o ...

Chapter 1: Introducing Excel 11 Introducing the Ribbon ......................................................................... ...

Part I: Getting Started with Excel 12 The appearance of the commands on the Ribbon varies, depending on the width of Excel windo ...

Chapter 1: Introducing Excel 13 Contextual tabs ................................................................................ ...

Part I: Getting Started with Excel 14 l (^) Simple buttons: Click the button, and it does its thing. An example of a simple butt ...

Chapter 1: Introducing Excel 15 Some of the Ribbon groups contain a small icon on the right side, known as a dialog box launcher ...

Part I: Getting Started with Excel 16 FIGURE 1.9 Pressing Alt displays the keytips. Using Shortcut Menus ....................... ...

Chapter 1: Introducing Excel 17 The box above the shortcut menu — the Mini toolbar — contains commonly used tools from the Home ...

Part I: Getting Started with Excel 18 Excel has commands that aren’t available on the Ribbon. In most cases, the only way to acc ...