Wiley 978-0-470-52755-9 Datasheet

Getting to Know Excel 2010With Microsoft’s popular Excel spreadsheet program, you can enter, manipulate, and analyze data in ways that would be imposs

10 Part 1: Getting to Know Excel 2010 ✓ Menu, rich: Rich menus have illustrative graphics, the command name, and in some cases a short description of

Introducing the Ribbon 11 ✓ Tab, standard: The Ribbon comes with a set of standard tabs, each organized according to the functions of the commands th

12 Part 1: Getting to Know Excel 2010It is important to note that at each stage of downward resizing, no command groups or commands disappear entirel

Introducing the Ribbon — Introducing the Quick Access Toolbar (QAT) 13 ✓ Click the Ribbon’s Minimize button in the Excel title bar (to the left of th

14 Part 1: Getting to Know Excel 2010 You can add an entire Ribbon command group to the QAT. Just right-click an area in the command group name (fo

Introducing the Quick Access Toolbar (QAT) — Previewing Your Formatting Live 15Figure 1-7 The Backstage navigation pane includes an Options button, w

16 Part 1: Getting to Know Excel 2010is not what you wanted, and then committing to another option, only to realize that you don’t like the new resul

Previewing Your Formatting Live — Soliciting Help 17 The following are characteristics of theme colors: • The top row in a color picker displays

18 Part 1: Getting to Know Excel 2010 SuperTips take the concept a step further by adding a short description explaining the purpose of the comman

Soliciting Help 19Figure 1-9 Although most of the options in the help viewer are self-explanatory, the following options require further discussion:

2 Part 1: Getting to Know Excel 2010Excel 2010 BasicsExcel documents are known as workbooks. A single workbook can store as many sheets as will fit i

20 Part 1: Getting to Know Excel 2010 If you’re offline when you initiate a search, Excel uses help content internal to your system. Whether onlin

Excel 2010 Basics — Familiarizing Yourself with the Excel 2010 Window 3Active cell and rangesIn Excel, one of the cells in a worksheet is always the

4 Part 1: Getting to Know Excel 2010Figure 1-1 Select all buttonControl buttonName boxControl buttonQuick Access toolbarExcel title barWorkbook title

Familiarizing Yourself with the Excel 2010 Window — Navigating with the Mouse and Keyboard 5Navigating with the Mouse and KeyboardThe mouse is the

6 Part 1: Getting to Know Excel 2010Figure 1-2 Using the keyboardMost users will be comfortable using the mouse to do all their work in Excel. For us

Navigating with the Mouse and Keyboard 7Shortcut ActionCtrl+H ReplaceCtrl+I Apply or remove italic formattingCtrl+O or Ctrl+F12 Open a documentCtrl+P

8 Part 1: Getting to Know Excel 2010Keys ActionCtrl+Backspace Scrolls the screen to display the active cellUp arrow* Scrolls the screen one row up (a

Navigating with the Mouse and Keyboard — Introducing the Ribbon 9arrow (known as a split button), the icon or text part of the button represents the