30.00$ - Pay Now
Digital File Direct & Fast Download ( Bank Exam ZIP & PDF) only for 30.00$
All chapters are included in the test Bank Exam
Free samples included once needed (ZIP & PDF)
Multiple payment options (Paypal , Credit Card) - NO account Required
Dedicated support / instant chat – Email - Whatsapp
Digital file of Exploring: Microsoft Office 2013, Volume 1 (Subscription) for sale
***THIS IS NOT THE ACTUAL BOOK. YOU ARE BUYING the Test Bank in e-version of the following book***
Category : Higher Education
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
0 commentaires:
Enregistrer un commentaire