Sale!

Test Bank for Exploring Microsoft Office 2013, Volume 1, Mary Anne Poatsy, Keith Mulbery, Cynthia Krebs, Lynn Hogan, Amy M. Rutledge, Robert T. Grauer, ISBN-10: 0133142671, ISBN-13: 9780133142679, Downloadable Digital Test Bank Files

$100.00 $50.00

Test Bank for Exploring Microsoft Office 2013, Volume 1, Mary Anne Poatsy, Keith Mulbery, Cynthia Krebs, Lynn Hogan, Amy M. Rutledge, Robert T. Grauer, ISBN-10: 0133142671, ISBN-13: 9780133142679



DOWNLOAD SAMPLE
Download Sample

Description

Share

What is a Test Bank?

You are buying Test Bank. Test Bank is not original text book or solution manual or eBook. A Test Bank is collection of test questions tailored to the contents of an individual text book. Test bank may contain the types of questions: multiple choice, true/false, fill in the blank, matching, essay/short answer, and free-response questions. Please download sample for your confidential.

Is my purchase anonymous?

Yes, all purchases are confidential. Nobody in the world knows about this. We do not save or share any of our customer’s information with anyone. There is no way your instructor or professor knows about this purchase at all.

 Can I download instantly?

Yes, you will see the download link in your email immediately after you complete payment. Please never forget to check spam or junk emails. If you delete junk emails and did not receive your order, please contact with us and we will send your order as soon as possible (most of the time immediately).

admin@testbankweb.com

testbankwebhelp@gmail.com

 

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 TTables and Mail Merge
Objectives
Case Study Traylor University Economic Impact Study
TTables
Inserting a TTable
Formatting a TTable
Hands-On Exercise 1:
TTables
Advanced TTable Features
Managing TTable Data
Enhancing TTable Data
Hands-On Exercise 2:
Advanced TTable 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 TTables: 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 TTables
Designing and Creating TTables
Applying a TTable Style
Hands-On Exercise 2:
Excel TTables
TTable Manipulation
Sorting Data
Filtering Data
Hands-On Exercise 3:
TTable Manipulation
TTable Aggregation
Using Structured References and a Total Row
Hands-On Exercise 4:
TTable 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 TTable 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 TTables and Queries in Relational Databases: Designing Databases and Extracting Data
Objectives
Case Study Bank Audit
TTable Design, Creation, and Modification
Designing a TTable
Creating and Modifying TTables
Hands-On Exercise 1:
TTable Design, Creation, and Modification
Multiple-TTable Databases
Sharing Data
Establishing TTable Relationships
Hands-On Exercise 2:
Multiple-TTable Databases
Single-TTable Queries
Creating a Single-TTable 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-TTable Queries
MultitTable Queries
Creating a MultitTable Query
Modifying a MultitTable Query
Hands-On Exercise 4:
MultitTable 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 TTables 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 TTable
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