O'Reilly logo

Excel® 2010 Workbook for Dummies® by Greg Harvey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required