Page 346 - Excel Workbook for Dummies

41_798452 appb.qxp 3/13/06 7:33 PM Page 329

Appendix B

Table of Exercises

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

Table B-1 Table of Exercises

Exercise Name Page Number
Chapter 1: Entering the Spreadsheet Data
Exercise 1-1: Launching Excel 10
Exercise 1-2: Opening a New Workbook 11
Exercise 1-3: Opening a New Workbook from a Template 11

Exercise 1-4: Moving the Cell Cursor within the Displayed Area 12
Exercise 1-5: Moving the Cell Cursor to Distant Parts of the Worksheet 13
Exercise 1-6: Moving the Cell Cursor from Entry to Entry 13

Exercise 1-7: Moving to Different Worksheets 14
Exercise 1-8: Selecting Various Cell Ranges 15
Exercise 1-9: Making Simple Data Entries 17
Exercise 1-10: Entering the Same Entry and Using AutoFill 19
Exercise 1-11: Copying a Formula with AutoFill 20

Exercise 1-12: Saving a Spreadsheet 21
Chapter 2: Formatting the Spreadsheet
Exercise 2-1: Modifying Column Widths in a Spreadsheet 24

Exercise 2-2: Modifying Row Heights in a Spreadsheet 25
Exercise 2-3: Formatting Cells from the Format Toolbar 27
Exercise 2-4: Formatting Cells with Number Tab on the Format Cells Dialog Box 29
Exercise 2-5: Formatting Cells with the Alignment Tab on the Format Cells Dialog Box 30
Exercise 2-6: Formatting Cells with the Format Painter 32

Exercise 2-7: Formatting a Table with AutoFormat 33
Exercise 2-8: Formatting Cells with Conditional Formatting 33
Exercise 2-9: Hiding Columns and Rows in a Worksheet 35

(continued)