CART

(0) items

Exploring Microsoft Office Excel 2010 Comprehensive,9780135098592

Exploring Microsoft Office Excel 2010 Comprehensive

by ; ; ;
Edition:
1st
ISBN13:

9780135098592

ISBN10:
0135098599
Format:
Spiral Bound
Pub. Date:
11/12/2010
Publisher(s):
Prentice Hall
Includes 2-weeks free access to
step-by-step solutions for this book.
Step-by-Step solutions are actual worked out problems to the questions at the end of each chapter that help you understand your homework and study for your exams. Chegg and eCampus are providing you two weeks absolutely free. 81% of students said using Step-by-Step solutions prepared them for their exams.
List Price: $132.20

Rent Textbook

(Recommended)
 
Term
Due
Price
$19.71

Buy Used Textbook

In Stock Usually Ships in 24 Hours.
U9780135098592
$37.98

Buy New Textbook

Currently Available, Usually Ships in 24-48 Hours
N9780135098592
$128.90

eTextbook


 
Duration
Price
$63.59
More New and Used
from Private Sellers
Starting at $2.69
See Prices

Questions About This Book?

Why should I rent this book?
Renting is easy, fast, and cheap! Renting from eCampus.com can save you hundreds of dollars compared to the cost of new or used books each semester. At the end of the semester, simply ship the book back to us with a free UPS shipping label! No need to worry about selling it back.
How do rental returns work?
Returning books is as easy as possible. As your rental due date approaches, we will email you several courtesy reminders. When you are ready to return, you can print a free UPS shipping label from our website at any time. Then, just return the book to your UPS driver or any staffed UPS location. You can even use the same box we shipped it in!
What version or edition is this?
This is the 1st edition with a publication date of 11/12/2010.
What is included with this book?
  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.
  • The Used copy of this book is not guaranteed to inclue any supplemental materials. Typically, only the book itself is included.
  • The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.

Related Products


  • Exploring Microsoft Office Access 2010 Introductory
    Exploring Microsoft Office Access 2010 Introductory
  • Myitlab: Next Genratn Online Assessmt&Train
    Myitlab: Next Genratn Online Assessmt&Train
  • Technology In Action, Complete Version
    Technology In Action, Complete Version
  • Technology In Action, Complete Version, Exploring Microsoft Office Excel 2010 Comprehensive, Exploring Microsoft Office Access 2010 Introductory, and myitlab with Pearson eText -- Access Card -- for Office 2010 Package
    Technology In Action, Complete Version, Exploring Microsoft Office Excel 2010 Comprehensive, Exploring Microsoft Office Access 2010 Introductory, and myitlab with Pearson eText -- Access Card -- for Office 2010 Package




Summary

For introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 applications. The goal of theExploringseries has been to move students beyond the point and click, helping them understand the why and how behind each skill. TheExploringseries for Office 2010 also enables students to extend the learning beyond the classroom. Students go to college now with a different set of skills than they did five years ago. With this in mind, theExploringseries seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everybody needs to know. A lot of learning takes place outside of the classroom, and theExploringseries provides learning tools that students can access anytime, anywhere.

Author Biography

Dr. Robert T. Grauer, Creator of the Exploring Series

Bob Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Miami, where he is a multiple winner of the Outstanding Teaching Award in the School of Business, most recently in 2009. He has written numerous COBOL texts and is the vision behind the Exploring Office series, with more than three million books in print. His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels. Bob Grauer has consulted for several major corporations including IBM and American Express. He received his Ph.D. in operations research in 1972 from the Polytechnic Institute of Brooklyn.

 

 

Dr. Keith Mulbery, Consulting Series Editor and Excel Author

Dr. Keith Mulbery is the Department Chair and an Associate Professor in the Information Systems and

Technology Department at Utah Valley University (UVU), where he teaches computer applications, C#

programming, systems analysis and design, and MIS classes. Keith also served as Interim Associate Dean,

School of Computing, in the College of Technology and Computing at UVU.

 

Keith received the Utah Valley State College Board of Trustees Award of Excellence in 2001, School of

Technology and Computing Scholar Award in 2007, and School of Technology and Computing Teaching

Award in 2008. He has authored more than 15 textbooks, served as Series Editor for the Exploring Office

2007 series, and served as developmental editor on two textbooks.

 

Keith received his B.S. and M.Ed. in Business Education from Southwestern Oklahoma State University

and earned his Ph.D. in Education with an emphasis in Business Information Systems at Utah State

University. His dissertation topic was computer-assisted instruction using Prentice Hall’s Train and Assess IT program to supplement traditional instruction in basic computer proficiency courses.

 

 

Mary Anne Poatsy, Series Editor

Mary Anne is a senior faculty member at Montgomery County Community College, teaching various

computer application and concepts courses in face-to-face and online environments. She holds a B.A.

in psychology and education from Mount Holyoke College and an M.B.A. in finance from Northwestern

University’s Kellogg Graduate School of Management.

 

Mary Anne has more than 12 years of educational experience. She is currently adjunct faculty at

Gwynedd-Mercy College and Montgomery County Community College. She has also taught at Bucks

County Community College and Muhlenberg College, as well as conducted professional training. Before

teaching, she was vice president at Shearson Lehman in the Municipal Bond Investment Banking

Department.

 

 

Dr. Lynn Hogan, Office Fundamentals and File Management and

Windows 7 Author

Lynn Hogan has taught in the Computer Information Systems area at Calhoun Community College for

29 years. She is the author of Practical Computing and has contributed chapters for several computer

applications textbooks. Primarily teaching in the areas of computer literacy and computer applications,

she was named Calhoun’s outstanding instructor in 2006. She received an M.B.A. from the University of

North Alabama and a Ph.D. from the University of Alabama. Lynn resides in Alabama with her husband

and two daughters.

 

Table of 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 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 Charts

CASE STUDY: HORT UNIVERSITY MAJORS

OBJECTIVES

CHART BASICS

Deciding Which Chart Type to Create

Creating a Chart

HANDS-ON EXERCISE 1: Chart Basics

CHART DESIGN

Changing the Chart Type

Changing the Data Source and Structure

Applying a Chart Layout and a Chart Style

Moving a Chart

Printing Charts

Inserting and Customizing a Sparkline

HANDS-ON EXERCISE 2: Chart Design

CHART LAYOUT

Selecting and Formatting Chart Elements

Customizing Chart Labels

Formatting the Axes and Gridlines

Adding a Trendline

HANDS-ON EXERCISE 3: Chart Layout

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER FOUR Datasets and Tables

CASE STUDY: THE SPA EXPERTS

OBJECTIVES

LARGE DATASETS

Freezing Rows and Columns

Printing Large Datasets

HANDS-ON EXERCISE 1: Large Datasets

EXCEL TABLES

Understanding Table Design

Creating a Table

Applying a Table Style

HANDS-ON EXERCISE 2: Excel Tables

TABLE MANIPULATION AND AGGREGATION

Sorting Data

Filtering Data

Using Structured References and a Total Row

HANDS-ON EXERCISE 3: Table Manipulation and Aggregation

CONDITIONAL FORMATTING

Applying Conditional Formatting

Creating a New Rule

Sorting and Filtering Using Conditional Formatting

HANDS-ON EXERCISE 3: Conditional Formatting

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER FIVE Subtotals, PivotTables, and PivotCharts

CASE STUDY: IVORY HALLS PUBLISHING COMPANY

OBJECTIVES

OUTLINES AND SUBTOTALS

Grouping and Ungrouping Data

Subtotaling Data

HANDS-ON EXERCISE 1: Outlines and Subtotals

PIVOTTABLE BASICS

Creating a PivotTable

Changing the Values Field

Modifying a PivotTable

HANDS-ON EXERCISE 2: PivotTable Basics

PIVOTTABLE OPTIONS

Sorting, Filtering, and Slicing a PivotTable

Creating a Calculated Field

HANDS-ON EXERCISE 3: PivotTable Options

PIVOTTABLE DESIGN AND PIVOTCHARTS

Formatting a PivotTable

Creating a PivotChart

HANDS-ON EXERCISE 4: PivotTable Design and PivotCharts

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER SIX What-If Analysis

CASE STUDY: PERSONAL FINANCE: BUYING A CAR

OBJECTIVES

ONE- AND TWO-VARIABLE DATA TABLES

Creating a One-Variable Data Table

Creating a Two-Variable Data Table

HANDS-ON EXERCISE 1: One- and Two-Variable Data Tables

GOAL SEEK AND SCENARIO MANAGER

Identifying an Input Value with Goal Seek

Using Scenario Manager

Generating Scenario Summary Reports

HANDS-ON EXERCISE 2: Goal Seek and Scenario Manager

SOLVER

Loading the Solver Add-In

Optimizing Results with Solver

HANDS-ON EXERCISE 3: Solver

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER SEVEN Specialized Functions

CASE STUDY: STANWORTH, INC.

OBJECTIVES

MATH AND STATISTICAL FUNCTIONS

Using Conditional Math and Statistical Functions

Calculating Relative Standing with Statistical Functions

HANDS-ON EXERCISE 1: Math and Statistical Functions

LOGICAL AND LOOKUP FUNCTIONS

Creating a Nested Logical Function

Using MATCH and INDEX Lookup Functions

HANDS-ON EXERCISE 2: Logical and Lookup Functions

DATABASE FILTERING AND FUNCTIONS

Using Advanced Filtering

Manipulating Data with Database Functions

HANDS-ON EXERCISE 3: Database Filtering and Functions

FINANCIAL FUNCTIONS

Creating a Loan Amortization Table

Performing Other Financial Calculations

HANDS-ON EXERCISE 4: Financial Functions

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER EIGHT Multiple-Sheet Workbook Management

CASE STUDY: HEARTLAND DEPARTMENT STORE

OBJECTIVES

MULTIPLE WORKSHEETS

Working with Grouped Worksheets

Managing Windows and Workspaces

Inserting Hyperlinks

HANDS-ON EXERCISE 1: Multiple Worksheets

3-D FORMULAS AND LINKED WORKBOOKS

Inserting a 3-D Formula

Linking Workbooks

HANDS-ON EXERCISE 2: 3-D Formulas and Linked Workbooks

FORMULA AUDITS AND DATA VALIDATION

Auditing Formulas

Setting Up a Watch Window

Validating Data

HANDS-ON EXERCISE 3: Formula Audits and Data Validation

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER NINE Imports, Web Queries, and XML

CASE STUDY: STOCK ANALYSIS

OBJECTIVES

EXTERNAL DATA

Importing Data from External Sources

Creating a Web Query

Managing Connections

HANDS-ON EXERCISE 1: External Data

TEXT MANIPULATION

Converting Text to Columns

Manipulating Text with Functions

HANDS-ON EXERCISE 2: Text Manipulation

XML

Understanding XML Syntax

Importing XML Data into Excel

HANDS-ON EXERCISE 3: XML

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER TEN Collaboration and Workbook Distribution

CASE STUDY: CULINARY ARTS SCHOLARSHIP DINNER

OBJECTIVES

CUSTOMIZATION AND PERSONALIZATION

Customizing Excel

Changing Properties

HANDS-ON EXERCISE 1: Customization and Personalization

COLLABORATION

Sharing and Merging Workbooks

Inserting Comments

Tracking Changes

HANDS-ON EXERCISE 2: Collaboration

WORKBOOK INFORMATION

Checking for Issues

Protecting a Workbook

HANDS-ON EXERCISE 3: Workbook Information

WORKBOOK DISTRIBUTION

Saving a Workbook in Different Formats

Sending a Workbook to Others

HANDS-ON EXERCISE 3: Workbook Distribution

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

CHAPTER ELEVEN Templates, Styles, and Macros

CASE STUDY: PERSONAL FINANCIAL CONSULTANT

OBJECTIVES

TEMPLATES, THEMES, AND STYLES

Selecting a Template

Applying Themes and Backgrounds

Applying Cell Styles

HANDS-ON EXERCISE 1: Templates, Themes, and Styles

CUSTOM TEMPLATES AND WORKBOOK PROTECTION

Creating and Using a Template

Protecting a Cell, a Worksheet, and a Workbook

HANDS-ON EXERCISE 2: Custom Templates and Workbook Protection

MACROS

Creating a Macro

Creating Macro Buttons

Setting Macro Security

HANDS-ON EXERCISE 3: Macros

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

 

GLOSSARY

INDEX

 



Please wait while the item is added to your cart...