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 ... | |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access