Excel 2010 Bible

Chapter 1: Introducing Excel 19 Working with Dialog Boxes ...................................................................... ...

Part I: Getting Started with Excel 20 l (^) Stay-on-top dialog box: A modeless dialog box works in a manner similar to a toolbar ...

Chapter 1: Introducing Excel 21 dialog box, which is modeless tabbed. To select a tab using the keyboard, press the up- or down- ...

Part I: Getting Started with Excel 22 Using the Task Pane ...................................................................... ...

Chapter 1: Introducing Excel 23 The sales projection will consist of two columns of information. Column A will contain the month ...

Part I: Getting Started with Excel 24 FIGURE 1.16 Your worksheet, after entering the column headings and month names. At this po ...

Chapter 1: Introducing Excel 25 Tip Don’t drag the fill handle this time, though, because you’re selecting cells, not filling a ...

Part I: Getting Started with Excel 26 Activate any cell in the table Choose Table Tools ➪ Design ➪ Table Style Options ➪ Total ...

Chapter 1: Introducing Excel 27 Printing your worksheet ........................................................................ ...

Part I: Getting Started with Excel 28 When you’re ready to print, choose File ➪ Print. At this point, you can change some prin ...

29 CHAPTER Entering and Editing Worksheet Data IN THIS CHAPTER Understanding the types of data you can use Entering text and val ...

Part I: Getting Started with Excel 30 About numeric values ..................................................................... ...

Chapter 2: Entering and Editing Worksheet Data 31 FIGURE 2.1 You can use values, text, and formulas to create useful Excel works ...

Part I: Getting Started with Excel 32 Entering Text and Values into Your Worksheets ............................................ ...

Chapter 2: Entering and Editing Worksheet Data 33 FIGURE 2.2 The Formula bar, expanded in height to show more information in the ...

Part I: Getting Started with Excel 34 Most of the time, you don’t have to be concerned with Excel’s serial number date system. Y ...

Chapter 2: Entering and Editing Worksheet Data 35 Erasing the contents of a cell ............................................... ...

Part I: Getting Started with Excel 36 l (^) Double-click the cell to edit the cell contents directly in the cell. l Select the c ...

Chapter 2: Entering and Editing Worksheet Data 37 l (^) Select multiple characters. Press Shift while you use the navigation key ...

Part I: Getting Started with Excel 38 Selecting a range of input cells before entering data .................................... ...