9780133142679

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: This is just the spiral bound book with access card that includes the online. content that used to be on the CD/DVD.

ALERT: If the student wants access to MyITLab, they would need to order the package ISBN that includes the book and the MyITLab access card.

There are many packages that include MyITLab so the student should request the ISBN from their Instructor before purchasing. 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.

One of the packages

013381016X / 9780133810165 Exploring Microsoft Office 2013, Volume 1 & MyITLab -- Access Card -- for Exploring Microsoft Office 2013 Package

Package consists of

0133142671 / 9780133142679 Exploring Microsoft Office 2013, Volume 1

0133775143 / 9780133775143 MyITLab without Pearson eText -- Access Card -- for Exploring Microsoft Office 2013 (Replacement Card)

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

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 access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Exploring Microsoft Office 2013, Volume 1

Exploring Microsoft Office 2013, Volume 1

0133142671

Summary

Table of Contents

Supplemental Materials