Corresponding textbook
Title: "The
I-Series: Microsoft Excel 2002, Introductory"
Authors: Stephen Haag and James
T. Perry
Publisher: McGraw-Hill Irwin
ISBN No.: 0-07-247032-1
| Topics covered in exam | Corresponding Chapters in Textbook |
|---|---|
| Creating and Modifying Worksheets: Entering Data Saving Workbooks Printing Worksheets |
Chapter 1 |
| Working with Cells and Cell Data: Writing Formulas Absolute and Relative Cell Referencing Using Functions, Copying and Moving Cell Contents Formatting Cells Print Setup and Printing |
Chapter 2 |
| Formatting Worksheets: Aligning Data and Applying Character Formats Advanced Formatting |
Chapter 3 |
| Creating and Modifying Charts: Creating Excel Charts Modifying and Improving Chart |
Chapter 4 |
| Using Excel's List Features: Creating and using lists Creating Filters and Subtotals Creating and Using Pivot Tables |
Chapter 5 |
| Using Excel's Common Functions: Using Data Validation Names and IF and Index Functions Using Financial Functions Maintaining and Protecting Using Date Functions |
Chapter 6 |
