CART

(0) items

Exploring Microsoft Office 2013, Volume 1,9780133142679
This item qualifies for
FREE SHIPPING!

FREE SHIPPING OVER $59!

Your order must be $59 or more, you must select US Postal Service Shipping as your shipping preference, and the "Group my items into as few shipments as possible" option when you place your order.

Bulk sales, PO's, Marketplace Items, eBooks, Apparel, and DVDs not included.

Exploring Microsoft Office 2013, Volume 1

by ; ; ; ; ;
Edition:
1st
ISBN13:

9780133142679

ISBN10:
0133142671
Format:
Package
Pub. Date:
4/10/2013
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: $170.40

Rent Textbook

(Recommended)
 
Term
Due
Price
$68.16

Buy New Textbook

In Stock Usually Ships in 24 Hours.
N9780133142679
$163.58

eTextbook

Downloadable Offline Access
  • Apple Devices
  • Android Devices
  • Windows Devices
  • Mac Devices

 
Duration
Price
$76.06

Used Textbook

We're Sorry
Sold Out

More New and Used
from Private Sellers
Starting at $106.97
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 4/10/2013.
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 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.

Summary

This book covers introductory Word, Excel, Access, and PowerPoint, with an additional Windows 8 chapter.


Move students beyond the point-and-click.

 

The goal of the Exploring series is to move students beyond the point and click, to understanding the why and how behind each skill. And, because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, any time.

 

Students go to college now with a different set of skills than they did years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know.


NOTE: Before purchasing, check with your instructor to ensure you select the correct ISBN. Several versions of Pearson's MyLab & Mastering products exist for each title, and registrations are not transferable. To register for and use Pearson's MyLab & Mastering products, you may also need a Course ID, which your instructor will provide.

 

Used books, rentals, and purchases made outside of Pearson

If purchasing or renting from companies other than Pearson, the access codes for Pearson's MyLab & Mastering products may not be included, may be incorrect, or may be previously redeemed. Check with the seller before completing your purchase.

 

Table of Contents

Windows 8

Chapter One Getting Started with Windows 8

Objectives         

Case Study Cedar Grove Elementary School

 

Windows 8 Fundamentals

    Understanding the Start Screen

    Configuring the Start Screen

    Running Windows 8 Apps

    Closing Apps

    Understanding the Desktop

    Managing Windows 8 Apps and Windows

 

Hands-On Exercise 1:

Windows 8 Fundamentals

 

Windows Programs and Security Features           

    Identifying Windows Accessories

    Working with Security Settings and Software

 

Hands-On Exercise 2:

Windows Programs and Security Features

    Windows Search and Help

    Performing a Search

    Using Targeted Searches

    Getting Help

 

Hands-On Exercise 3:

Windows Search and Help

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Microsoft Office 2013

Chapter One Office Fundamentals and File Management: Taking the First Step

 

Objectives         

Case Study Spotted Begonia Art Gallery

Windows 8 Startup

    Logging In with Your Microsoft Account

    Identifying the Start Screen Components

    Interacting with the Start Screen

    Accessing the Desktop

 

Hands-On Exercise 1:

Windows 8 Startup

 

Files and Folders             

    Using File Explorer

    Working with Folders and Files

    Selecting, Copying, and Moving Multiple Files and Folders

 

Hands-On Exercise 2:

Files and Folders

 

Microsoft Office Software

    Identifying Common Interface Components

    Getting Office Help

 

Hands-On Exercise 3:

Microsoft Office Software

 

The Backstage View Tasks           

    Opening a File

    Printing a File

    Closing a File and Application

 

Hands-On Exercise 4:

The Backstage View Tasks

 

Home Tab Tasks              

    Selecting and Editing Text

    Using the Clipboard Group Commands

    Using the Editing Group Commands

 

Hands-On Exercise 5:

Home Tab Tasks

 

Insert Tab Tasks               

    Inserting Objects

 

Review Tab Tasks            

    Reviewing a File

 

Page Layout Tab Tasks  

    Using the Page Setup Dialog Box

 

Hands-On Exercise 6:

Insert Tab Tasks, Page Layout Tab Tasks, and Review Tab Tasks

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Chapter One Introduction to Word: Organizing a Document

Objectives         

Case Study Swan Creek National Wildlife Refuge

 

Introduction to Word Processing             

    Beginning and Editing a Document

    Customizing Word

 

Hands-On Exercise 1:

    Introduction to Word Processing

 

Document Organization

    Using Features That Improve Readability

    Viewing a Document in Different Ways

 

Hands-On Exercise 2:

Document Organization

 

Document Settings and Properties         

    Preparing a Document for Distribution

    Modifying Document Properties

 

Hands-On Exercise 3:

Document Settings and Properties

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Microsoft Office Word 2013

Chapter Two Document Presentation: Editing and Formatting

Objectives         

Case Study Phillips Studio L Photography

 

Text and Paragraph Formatting

    Applying Font Attributes

    Formatting a Paragraph

 

Hands-On Exercise 1:

Text and Paragraph Formatting

 

Document Appearance

    Formatting a Document

    Applying Styles

 

Hands-On Exercise 2:

Document Formatting

Objects               

Inserting and Formatting Objects

 

Hands-On Exercise 3:

Objects

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Chapter Three Document Productivity: Working with Tables and Mail Merge

Objectives         

Case Study Traylor University Economic Impact Study

 

Tables  

    Inserting a Table

    Formatting a Table

 

Hands-On Exercise 1:

Tables

 

Advanced Table Features            

    Managing Table Data

    Enhancing Table Data

 

Hands-On Exercise 2:

Advanced Table Features

 

Mail Merge

    Creating a Mail Merge Document

    Completing a Mail Merge

 

Hands-On Exercise 3:

Mail Merge

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Chapter Four Collaboration and Research: Communicating and Producing Professional  Papers

Objectives         

Case Study Literature Analysis  

 

Research Paper Basics  

    Using a Writing Style and Acknowledging Sources     

    Creating and Modifying Footnotes and Endnotes

    Exploring Special Features

 

Hands-On Exercise 1:

Research Paper Basics

 

Document Tracking

    Reviewing a Document

    Tracking Changes

 

 

Hands-On Exercise 2:

Document Tracking

 

Online Document Collaboration

    Using SkyDrive

    Sharing and Collaborating on Documents

 

Hands-On Exercise 3:

Online Document Collaboration

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Microsoft Office Excel 2013

Chapter One Introduction to Excel: What Is a Spreadsheet?

Objectives         

Case Study Ok Office Systems   

 

Introduction to Spreadsheets   

    Exploring the Excel Window

    Entering and Editing Cell Data

 

Hands-On Exercise 1:

Introduction to Spreadsheets

 

Mathematics and Formulas        

    Creating Formulas

    Using Auto Fill

    Displaying Cell Formulas

 

Hands-On Exercise 2:

Mathematics and Formulas

 

Workbook and Worksheet Management

    Managing Worksheets

    Managing Columns and Rows

 

Hands-On Exercise 3:

Workbook and Worksheet Management

 

Clipboard Tasks

    Selecting, Moving, Copying, and Pasting Data

 

Hands-On Exercise 4:

Clipboard Tasks

 

Formatting         

    Applying Alignment and Font Options

    Applying Number Formats

 

Hands-On Exercise 5:

Formatting

 

Page Setup and Printing               

    Selecting Page Setup Options

    Previewing and Printing a Worksheet

 

Hands-On Exercise 6:

Page Setup and Printing

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Chapter Two  Formulas and Functions: Performing Quantitative Analysis

Objectives         

Case Study Townsend Mortgage Company

 

Formula Basics 

    Using Relative, Absolute, and Mixed Cell References in Formulas

    Correcting Circular References

 

Hands-On Exercise 1:

Formula Basics

 

Function Basics

    Inserting a Function

    Inserting Basic Math and Statistics 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 Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Chapter Three Charts: Depicting Data Visually

Objectives         

Case Study Computer Job Outlook          

 

Chart Creation Basics     

    Selecting the Data Source

    Choosing a Chart Type

    Moving, Sizing, and Printing a Chart

 

Hands-On Exercise 1:

Chart Creation Basics

 

Chart Elements

    Adding Chart Elements

    Formatting Chart Elements

 

Hands-On Exercise 2:

Chart Elements

 

Chart Design and Sparklines       

    Applying a Chart Style and Colors

    Modifying the Data Source

    Creating and Customizing Sparklines

 

Hands-On Exercise 3:

Chart Design and Sparklines

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Chapter Four  Datasets and Tables: Managing Large Volumes of Data

Objectives         

Case Study Reid Furniture Store

 

Large Datasets 

    Freezing Rows and Columns

    Printing Large Datasets

 

Hands-On Exercise 1:

Large Datasets

 

Excel Tables       

    Designing and Creating Tables

    Applying a Table Style

 

Hands-On Exercise 2:

Excel Tables

 

Table Manipulation

    Sorting Data

    Filtering Data

 

Hands-On Exercise 3:

Table Manipulation

 

Table Aggregation

    Using Structured References and a Total Row

 

Hands-On Exercise 4:

Table Aggregation

 

Conditional Formatting 

    Applying Conditional Formatting

    Creating a New Rule

 

Hands-On Exercise 5:

Conditional Formatting

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Microsoft Office Access 2013

Chapter One Introduction to Access: Finding Your Way Through an Access Database

Objectives         

Case Study Managing a Business in the Global Economy

 

Databases Are Everywhere!

    Understanding Database Fundamentals

    Using an Existing Database

 

Hands-On Exercise 1:

Databases Are Everywhere!

 

Sorts and Filters               

    Sorting Table Data on One or Multiple Fields

    Creating, Modifying, and Removing Filters

 

Hands-On Exercise 2:

Sorts and Filters

 

Access Versus Excel, and Relational Databases  

    Knowing When to Use Access or Excel to Manage Data

    Understanding Relational Power

 

Hands-On Exercise 3:

Access Versus Excel, and Relationship Databases

 

Access Database Creation

    Creating a Database

 

Hands-On Exercise 4:

Access Database Creation

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

 

Chapter Two Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Objectives         

Case Study Bank Audit

 

Table Design, Creation, and Modification

    Designing a Table

    Creating and Modifying Tables

 

Hands-On Exercise 1:

Table Design, Creation, and Modification

 

Multiple-Table Databases           

    Sharing Data

    Establishing Table Relationships

 

Hands-On Exercise 2:

Multiple-Table Databases

 

Single-Table Queries     

    Creating a Single-Table Query

    Specifying Query Criteria for Different Data Types

    Understanding Query Sort Order

    Running, Copying, and Modifying a Query

    Using the Query Wizard

 

Hands-On Exercise 3:

Single-Table Queries

 

Multitable Queries         

    Creating a Multitable Query

    Modifying a Multitable Query

 

Hands-On Exercise 4:

Multitable Queries

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Chapter Three Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Objectives         

Case Study Housing Slump Means Opportunity For College Students     

 

Calculations and Expressions     

    Creating a Calculated Field in a Query

    Formatting and Saving Calculated Results

 

Hands-On Exercise 1:

Calculations and Expressions

 

The Expression Builder and Functions    

    Creating Expressions with the Expression Builder

    Using Built-In Functions in Access

 

Hands-On Exercise 2:

The Expression Builder and Functions

 

Aggregate Functions     

    Adding Aggregate Functions to Datasheets

    Creating Queries with Aggregate Functions

 

Hands-On Exercise 3:

Aggregate Functions

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Chapter Four Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Objectives         

Case Study Coffee Shop Starts New Business    

 

Form Basics       

    Creating Forms Using Form Tools

    Using Form Views

    Working with a Form Layout Control

    Sorting Records in a Form

 

Hands-On Exercise 1:

Create and Modify forms

 

Report Basics    

    Creating Reports Using Report Tools

    Using Report Views

    Modifying a Report

    Sorting Records in a Report

 

Hands-On Exercise 2:

Report Basics

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Microsoft Office PowerPoint 2013

Chapter One Introduction to PowerPoint: Creating a Basic Presentation

Objectives         

Case Study Be a Trainer

 

Introduction to PowerPoint

    Using PowerPoint Views

    Typing a Speaker Note

    Saving As a Slide Show

 

Hands-On Exercise 1:

Introduction to PowerPoint

 

Presentation Creation

    Planning a Presentation

    Assessing Presentation Content

    Reviewing the Presentation

 

Hands-On Exercise 2:

Presentation Creation

 

Presentation Enhancement

    Inserting Media Objects

    Adding a Table

    Using Animations and Transitions

    Inserting a Header or Footer

 

Hands-On Exercise 3:

Presentation Enhancement

 

Navigation and Printing

    Running and Navigating a Slide Show

    Printing in PowerPoint

 

Hands-On Exercise 4:

Navigation and Printing

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Chapter Two Presentation Development: Planning and Preparing a Presentation

Objectives         

Case Study The Wellness Education Center

 

Templates          

    Creating a Presentation Using a Template

    Modifying a Presentation Based on a Template

 

Hands-On Exercise 1:

Templates

 

Outlines              

    Creating a Presentation in Outline View

    Modifying an Outline Structure

    Printing an Outline

 

Hands-On Exercise 2:

Outlines

 

Data Imports     

    Importing an Outline

    Reusing Slides from an Existing Presentation

 

Hands-On Exercise 3:

Data Imports

 

Design

    Using Sections

    Examining Slide Show Design Principles

    Modifying a Theme

    Modifying the Slide Master

 

Hands-On Exercise 4:

Design

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Chapter Three Presentation Design: Illustrations and Infographics

Objectives         

Case Study Illustrations and Infographics Mini-Camp

 

Shapes

    Creating Shapes

    Applying Quick Styles and Customizing Shapes

 

Hands-On Exercise 1:

Shapes

 

Smartart and Wordart

    Creating SmartArt

    Modifying SmartArt

    Creating WordArt

    Modifying WordArt

 

Hands-On Exercise 2:

SmartArt and WordArt

 

Object Manipulation

    Modifying Objects

    Arranging Objects

 

Hands-On Exercise 3:

Object Manipulation

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Chapter Four PowerPoint Rich Media Tools: Enhancing with Multimedia

Objectives         

Case Study Engagement Album

 

Pictures               

    Inserting a Picture

    Transforming a Picture

    Using the Internet as a Resource

 

Hands-On Exercise 1:

Pictures

 

Video   

    Adding Video

    Using Video Tools

 

Hands-On Exercise 2:

Video

 

Audio   

    Adding Audio

    Changing Audio Settings

 

Hands-On Exercise 3:

Audio

 

Photo Albums  

    Creating a Photo Album

    Setting Photo Album Options

 

Hands-On Exercise 4:

Photo Albums

 

Chapter Objectives Review        

Key Terms Matching      

Multiple Choice

Practice Exercises           

Mid-Level Exercises       

Beyond the Classroom 

Capstone Exercise

 

Application Capstone Exercises

Word

Excel

Access

PowerPoint

Glossary

Index

 



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