Exploring Microsoft Office Excel 2010 Comprehensive

<p>OFFICE FUNDAMENTALS AND FILE MANAGEMENT</p> <p>CHAPTER ONE ¿ Office Fundamentals and File Management </p> <p>CASE STUDY: RAILS AND TRAILS </p> <p>OBJECTIVES </p> <p>FILES AND FOLDERS </p> <p>Using Windows Explorer </p> <p>Working with Folders and Files </p> <p>Selecting, Copying, and Moving Multiple Files and Folders </p> <p>HANDS-ON EXERCISE 1: Files and Folders </p> <p>MICROSOFT OFFICE SOFTWARE</p> <p>Identifying Common Interface Components</p> <p>Getting Office Help </p> <p>HANDS-ON EXERCISE 2: Microsoft Office Software </p> <p>BACKSTAGE VIEW TASKS </p> <p>Opening a File </p> <p>Printing a File </p> <p>Closing a File and Application </p> <p>HANDS-ON EXERCISE 3: Backstage View Tasks </p> <p>HOME TAB TASKS </p> <p>Selecting and Editing Text </p> <p>Using the Clipboard Group Tasks </p> <p>Using the Editing Group Tasks </p> <p>HANDS-ON EXERCISE 4: Home Tab Tasks </p> <p>INSERT TAB TASKS </p> <p>Inserting Objects </p> <p>REVIEW TAB TASKS </p> <p>Reviewing a File </p> <p>PAGE LAYOUT TAB TASKS </p> <p>Changing Page Settings </p> <p>HANDS-ON EXERCISE 5: Tasks on the Insert Tab, Page Layout Tab, and Review Tab </p> <p>CHAPTER OBJECTIVES REVIEW </p> <p>KEY TERMS </p> <p>MULTIPLE CHOICE </p> <p>PRACTICE EXERCISES </p> <p>MID-LEVEL EXERCISES </p> <p>CAPSTONE EXERCISE </p> <p>BEYOND THE CLASSROOM </p> <p>&nbsp;</p> <p>MICROSOFT OFFICE EXCEL 2010</p> <p>CHAPTER ONE ¿ Introduction to Excel </p> <p>CASE STUDY: OK OFFICE SYSTEMS </p> <p>OBJECTIVES </p> <p>INTRODUCTION TO SPREADSHEETS</p> <p>Planning for Effective Workbook and Worksheet Design </p> <p>Exploring the Excel Window </p> <p>Entering and Editing Cell Data </p> <p>HANDS-ON EXERCISE 1: Introduction to Spreadsheets </p> <p>MATHEMATICS AND FORMULAS</p> <p>Using Symbols and the Order of Precedence </p> <p>Using Auto Fill </p> <p>Displaying Cell Formulas </p> <p>HANDS-ON EXERCISE 2: Mathematics and Formulas </p> <p>WORKBOOK AND WORKSHEET MANAGEMENT </p> <p>Managing Worksheets </p> <p>Managing Columns and Rows </p> <p>Selecting, Moving, Copying, and Pasting </p> <p>HANDS-ON EXERCISE 3: Workbook and Worksheet Management </p> <p>FORMATTING </p> <p>Applying Alignment and Font Options </p> <p>Applying Number Formats </p> <p>HANDS-ON EXERCISE 4: Formatting </p> <p>PAGE SETUP AND PRINTING </p> <p>Selecting Page Setup Options </p> <p>Printing a Worksheet </p> <p>HANDS-ON EXERCISE 5: Page Setup and Printing </p> <p>CHAPTER OBJECTIVES REVIEW </p> <p>KEY TERMS </p> <p>MULTIPLE CHOICE </p> <p>PRACTICE EXERCISES </p> <p>MID-LEVEL EXERCISES </p> <p>CAPSTONE EXERCISE </p> <p>BEYOND THE CLASSROOM </p> <p>&nbsp;</p> <p>CHAPTER TWO ¿ Formulas and Functions</p> <p>CASE STUDY: DENVER MORTGAGE COMPANY </p> <p>OBJECTIVES </p> <p>FORMULA BASICS </p> <p>Using Semi-Selection to Create a Formula </p> <p>Using Relative, Absolute, and Mixed Cell References in Formulas </p> <p>Avoiding Circular References </p> <p>HANDS-ON EXERCISE 1: Formula Basics </p> <p>FUNCTION BASICS </p> <p>Inserting a Function </p> <p>Totaling Values with the SUM Function </p> <p>Inserting Basic Statistical Functions </p> <p>Using Date Functions </p> <p>HANDS-ON EXERCISE 2: Function Basics </p> <p>LOGICAL, LOOKUP, AND FINANCIAL FUNCTIONS </p> <p>Determining Results with the IF Function </p> <p>Using Lookup Functions </p> <p>Calculating Payments with the PMT Function </p> <p>HANDS-ON EXERCISE 3: Logical, Lookup, and Financial Functions </p> <p>RANGE NAMES </p> <p>Creating and Maintaining Range Names </p> <p>Using Range Names in Formulas </p> <p>HANDS-ON EXERCISE 4: Range Names </p> <p>CHAPTER OBJECTIVES REVIEW </p> <p>KEY TERMS </p> <p>MULTIPLE CHOICE </p> <p>PRACTICE EXERCISES </p> <p>MID-LEVEL EXERCISES </p> <p>CAPSTONE EXERCISE </p> <p>BEYOND THE CLASSROOM </p> <p>&nbsp;</p> <p>CHAPTER THREE ¿ Ch</p>