Exploring Microsoft Office Excel 2010 Comprehensive. (2013)
- Record Type:
- Book
- Title:
- Exploring Microsoft Office Excel 2010 Comprehensive. (2013)
- Main Title:
- Exploring Microsoft Office Excel 2010 Comprehensive
- Further Information:
- Note: Robert T. Grauer, Mary Anne Poatsy, Keith Mulbery, Lynn Hogan.
- Authors:
- Grauer, Robert T
Poatsy, Mary Anne
Mulbery, Keith
Hogan, Lynn - Contents:
- OFFICE FUNDAMENTALS AND FILE MANAGEMENT CHAPTER ONE ¿ Office Fundamentals and File Management CASE STUDY: RAILS AND TRAILS OBJECTIVES FILES AND FOLDERS Using Windows Explorer Working with Folders and Files Selecting, Copying, and Moving Multiple Files and Folders HANDS-ON EXERCISE 1: Files and Folders MICROSOFT OFFICE SOFTWARE Identifying Common Interface Components Getting Office Help HANDS-ON EXERCISE 2: Microsoft Office Software BACKSTAGE VIEW TASKS Opening a File Printing a File Closing a File and Application HANDS-ON EXERCISE 3: Backstage View Tasks HOME TAB TASKS Selecting and Editing Text Using the Clipboard Group Tasks Using the Editing Group Tasks HANDS-ON EXERCISE 4: Home Tab Tasks INSERT TAB TASKS Inserting Objects REVIEW TAB TASKS Reviewing a File PAGE LAYOUT TAB TASKS Changing Page Settings HANDS-ON EXERCISE 5: Tasks on the Insert Tab, Page Layout Tab, and Review Tab CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM MICROSOFT OFFICE EXCEL 2010 CHAPTER ONE ¿ Introduction to Excel CASE STUDY: OK OFFICE SYSTEMS OBJECTIVES INTRODUCTION TO SPREADSHEETS Planning for Effective Workbook and Worksheet Design Exploring the Excel Window Entering and Editing Cell Data HANDS-ON EXERCISE 1: Introduction to Spreadsheets MATHEMATICS AND FORMULAS Using Symbols and the Order of Precedence Using Auto Fill Displaying Cell Formulas HANDS-ON EXERCISE 2: Mathematics and Formulas WORKBOOK AND WORKSHEETOFFICE FUNDAMENTALS AND FILE MANAGEMENT CHAPTER ONE ¿ Office Fundamentals and File Management CASE STUDY: RAILS AND TRAILS OBJECTIVES FILES AND FOLDERS Using Windows Explorer Working with Folders and Files Selecting, Copying, and Moving Multiple Files and Folders HANDS-ON EXERCISE 1: Files and Folders MICROSOFT OFFICE SOFTWARE Identifying Common Interface Components Getting Office Help HANDS-ON EXERCISE 2: Microsoft Office Software BACKSTAGE VIEW TASKS Opening a File Printing a File Closing a File and Application HANDS-ON EXERCISE 3: Backstage View Tasks HOME TAB TASKS Selecting and Editing Text Using the Clipboard Group Tasks Using the Editing Group Tasks HANDS-ON EXERCISE 4: Home Tab Tasks INSERT TAB TASKS Inserting Objects REVIEW TAB TASKS Reviewing a File PAGE LAYOUT TAB TASKS Changing Page Settings HANDS-ON EXERCISE 5: Tasks on the Insert Tab, Page Layout Tab, and Review Tab CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM MICROSOFT OFFICE EXCEL 2010 CHAPTER ONE ¿ Introduction to Excel CASE STUDY: OK OFFICE SYSTEMS OBJECTIVES INTRODUCTION TO SPREADSHEETS Planning for Effective Workbook and Worksheet Design Exploring the Excel Window Entering and Editing Cell Data HANDS-ON EXERCISE 1: Introduction to Spreadsheets MATHEMATICS AND FORMULAS Using Symbols and the Order of Precedence Using Auto Fill Displaying Cell Formulas HANDS-ON EXERCISE 2: Mathematics and Formulas WORKBOOK AND WORKSHEET MANAGEMENT Managing Worksheets Managing Columns and Rows Selecting, Moving, Copying, and Pasting HANDS-ON EXERCISE 3: Workbook and Worksheet Management FORMATTING Applying Alignment and Font Options Applying Number Formats HANDS-ON EXERCISE 4: Formatting PAGE SETUP AND PRINTING Selecting Page Setup Options Printing a Worksheet HANDS-ON EXERCISE 5: Page Setup and Printing CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM CHAPTER TWO ¿ Formulas and Functions CASE STUDY: DENVER MORTGAGE COMPANY OBJECTIVES FORMULA BASICS Using Semi-Selection to Create a Formula Using Relative, Absolute, and Mixed Cell References in Formulas Avoiding Circular References HANDS-ON EXERCISE 1: Formula Basics FUNCTION BASICS Inserting a Function Totaling Values with the SUM Function Inserting Basic Statistical Functions Using Date Functions HANDS-ON EXERCISE 2: Function Basics LOGICAL, LOOKUP, AND FINANCIAL FUNCTIONS Determining Results with the IF Function Using Lookup Functions Calculating Payments with the PMT Function HANDS-ON EXERCISE 3: Logical, Lookup, and Financial Functions RANGE NAMES Creating and Maintaining Range Names Using Range Names in Formulas HANDS-ON EXERCISE 4: Range Names CHAPTER OBJECTIVES REVIEW KEY TERMS MULTIPLE CHOICE PRACTICE EXERCISES MID-LEVEL EXERCISES CAPSTONE EXERCISE BEYOND THE CLASSROOM CHAPTER THREE ¿ Ch. … (more)
- Publisher Details:
- Harlow : Pearson
- Publication Date:
- 2013
- Copyright Date:
- 2014
- Extent:
- 1 online resource
- Subjects:
- Excel
- Languages:
- English
- ISBNs:
- 9781292053295
1292053291 - Related ISBNs:
- 9781292027043
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.724538
- Ingest File:
- 14_047.xml