Appendix C. Table of Exercises

Table C-1 is a handy reference table that lists every exercise in the book, complete with the page number where you can find it.

Table C-1. Table of Exercises

Exercise Name

Page Number

Chapter 1: Creating Spreadsheets

Exercise 1-1: Opening the Backstage View and Selecting Its Menu Commands

11

Exercise 1-2: Selecting Commands from the Ribbon

13

Exercise 1-3: Adding a Custom Tab to the Excel Ribbon

14

Exercise 1-4: Adding Commands to a Custom Tab

16

Exercise 1-5: Quickly Customizing the Quick Access Toolbar

17

Exercise 1-6: Adding Commands from the Excel Options Dialog Box to the Quick Access Toolbar

17

Chapter 2: Using Formulas and Functions

Exercise 2-1: Adding Excel 2010 Shortcuts to the Windows Desktop and Quick Launch Toolbar

22

Exercise 2-2: Opening a New Workbook from the Blank Workbook Template

24

Exercise 2-3: Opening a New Workbook File from an Installed Template File

25

Exercise 2-4: Moving the Cell Cursor in a Displayed Area of the Worksheet

26

Exercise 2-5: Moving the Cell Cursor to Unseen Parts of a Worksheet

27

Exercise 2-6: Moving the Cell Cursor Using the Ctrl and Arrow Keys

27

Exercise 2-7: Practice Moving the Cell Cursor to Different Sheets of the Same Workbook

29

Exercise 2-8: Practice Assigning Fill Colors to Selected Cell Ranges

30

Exercise 2-9: Practice Entering Data in a Simple Table

32

Exercise 2-10: Creating a Series of Entries with the Fill Handle

34

Exercise 2-11: Copying Formulas with the Fill Handle

35

Exercise 2-12: Saving a Workbook File

36

Chapter 3: Working ...

Get Excel® 2010 Workbook for Dummies® now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.