Table of Contents
Office
Chapter 1 Introduction to Microsoft Office 2013 Features
Project 1A Note Form
Objective 1 Use File Explorer to Download, Extract, and Locate Files and Folders
Activity 1.01 Using File Explorer to Download, Extract, and Locate Files and Folders
Objective 2 Use Start Search to Locate and Start a Microsoft Office 2013 Desktop App
Activity 1.02 Using Start Search to Locate and Start a Microsoft Office 2013 Desktop App
Objective 3 Enter, Edit, and Check the Spelling of Text in an Office 2013 Program
Activity 1.03 Entering and Editing Text in an Office 2013 Program
Activity 1.04 Checking Spelling
Objective 4 Perform Commands from a Dialog Box
Activity 1.05 Performing Commands from a Dialog Box
Activity 1.06 Using Undo
Objective 5 Create a Folder and Name and Save a File
Activity 1.07 Creating a Folder and Naming and Saving a File
Objective 6 Insert a Footer, Add Document Properties, Print a File, and Close a Desktop App
Activity 1.08 Inserting a Footer, Inserting Document Info, and Adding Document Properties
Activity 1.09 Printing a File and Closing a Desktop App
Project 1B Memo
Objective 7 Open an Existing File and Save It with a New Name
Activity 1.10 Opening an Existing File and Saving It with a New Name
More Knowledge Read-only
Objective 8 Sign In to Office and Explore Options for a Microsoft Office Desktop App
Activity 1.11 Signing In to Office and Viewing Application Options
Objective 9 Perform Commands from the Ribbon and Quick Access Toolbar
Activity 1.12 Performing Commands from and Customizing the Ribbon and the Quick Access Toolbar
More Knowledge Customizing the Ribbon
Activity 1.13 Minimizing and Using the Keyboard to Control the Ribbon
Objective 10 Apply Formatting in Office Programs
Activity 1.14 Changing Page Orientation and Zoom Level
More Knowledge Zooming to Page Width
Activity 1.15 Formatting Text by Using Fonts, Alignment, Font Colors, and Font Styles
Activity 1.16 Using Format Painter
Activity 1.17 Using Keyboard Shortcuts and Using the Clipboard to Copy, Cut, and Paste
Objective 11 Compress Files and Use the Microsoft Office 2013 Help System
Activity 1.18 Compressing Files
Activity 1.19 Using the Microsoft Office 2013 Help System in Excel
Objective 12 Install Apps for Office and Create a Microsoft Account
Activity 1.20 Installing Apps for Office
Activity 1.21 Creating a Microsoft Account
Summary, GO! Learn It Online
Guide to Chapter Assessments
Glossary
Excel Introduction to Microsoft Excel 2013
Chapter 1 Creating a Worksheet and Charting Data
Project 1A Sales Report with Embedded Column Chart and Sparklines
Objective 1 Create, Save, and Navigate an Excel Workbook
Activity 1.01 Starting Excel, Navigating Excel, and Naming and Saving a Workbook
More Knowledge Creating a New Workbook by Using a Template
Objective 2 Enter Data in a Worksheet
Activity 1.02 Entering Text, Using AutoComplete, and Using the Name Box to Select a Cell
Activity 1.03 Using Auto Fill and Keyboard Shortcuts
Activity 1.04 Aligning Text and Adjusting the Size of Columns
Activity 1.05 Entering Numbers
Objective 3 Construct and Copy Formulas and Use the SUM Function
Activity 1.06 Constructing a Formula and Using the Sum Function
Activity 1.07 Copying a Formula by Using the Fill Handle
Objective 4 Format Cells with Merge & Center, Cell Styles, and Themes
Activity 1.08 Using Merge & Center and Applying Cell Styles
Activity 1.09 Formatting Financial Numbers
Activity 1.10 Changing the Workbook Theme
More Knowledge Formatting a Cell’s Font, Style, Size, or Color with Individual Commands
Objective 5 Chart Data to Create a Column Chart and Insert Sparklines
Activity 1.11 Charting Data and Using Recommended Charts to Select and Insert a Column Chart
Activity 1.12 Using the Chart Tools to Apply Chart Styles
Activity 1.13 Creating and Formatting Sparklines
Objective 6 Print a Worksheet, Display Formulas, and Close Excel
Activity 1.14 Creating a Footer and Centering a Worksheet
Activity 1.15 Adding Document Properties and Printing a Workbook
Activity 1.16 Printing a Section of the Worksheet
Activity 1.17 Changing Page Orientation and Displaying, Printing, and Hiding Formulas
More Knowledge Inserting a Watermark
GO! with Office Web Apps
Objective Create a Sales Report with an Embedded Column Chart Using the Excel Web App
Activity Creating a Sales Report with Embedded Column Chart Using the Excel Web App
Project 1B Inventory Valuation
Objective 7 Check Spelling in a Worksheet
Activity 1.18 Checking Spelling in a Worksheet
Objective 8 Enter Data by Range
Activity 1.19 Entering Data by Range
Objective 9 Construct Formulas for Mathematical Operations
Activity 1.20 Using Arithmetic Operator
Activity 1.21 Using the Quick Analysis Tool
Activity 1.22 Copying Formulas Containing Absolute Cell References
More Knowledge Calculate a Percentage if You Know the Total and the Amount
Objective 10 Edit Values in a Worksheet
Activity 1.23 Editing Values in a Worksheet
Activity 1.24 Formatting Cells with the Percent Style
Objective 11 Format a Worksheet
Activity 1.25 Inserting and Deleting Rows and Columns
More Knowledge Hiding Rows and Columns
Activity 1.26 Adjusting Column Widths and Wrapping Text
Activity 1.27 Changing Theme Colors
GO! with Office Web Apps
Objective Calculate the Value of an Inventory in the Excel Web App
Activity Creating an Inventory Valuation Report in the Excel Web App
GO! with Microsoft Office 365
Activity Using the Exchange Online Outlook Meeting Tool to Collaborate
Summary, GO! Learn It Online, GO! For Job Success
Guide to Chapter Assessments
Glossary
Skills Review
Mastering Excel
Rubric
GO! Think
Chapter 2 Using Functions, Creating Tables, and Managing Large Workbooks
Project 2A Inventory Status Report
Objective 1 Use Flash Fill and the Sum, Average, Median, Min, and Max Functions
Activity 2.01 Using Flash Fill
Activity 2.02 Moving a Column
Activity 2.03 Using the SUM and AVERAGE Functions
Activity 2.04 Using the MEDIAN Function
Activity 2.05 Using the MIN and MAX Functions
Objective 2 Move Data, Resolve Error Messages, and Rotate Text
Activity 2.06 Moving Data and Resolving a # # # # # Error Message
Activity 2.07 Rotating Text
Objective 3 Use COUNTIF and IF Functions and Apply Conditional Formatting
Activity 2.08 Using the COUNT and Countif Functions
Activity 2.09 Using the IF Function
Activity 2.10 Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars
Activity 2.11 Using Find and Replace
Objective 4 Use Date & Time Functions and Freeze Panes
Activity 2.12 Using the Now Function to Display a System Date
More Knowledge NOW Function Recalculates Each Time a Workbook Opens
Activity 2.13 Freezing and Unfreezing Panes
More Knowledge Freeze Columns or Freeze Both Rows and Columns
Objective 5 Create, Sort, and Filter an Excel Table
Activity 2.14 Creating an Excel Table and Applying a Table Style
Activity 2.15 Sorting an Excel Table
Activity 2.16 Filtering an Excel Table and Displaying a Total Row
More Knowledge Band Rows and Columns in a Table
Activity 2.17 Clearing Filters and Converting a Table to a Range of Data
Objective 6 View, Format, and Print a Large Worksheet
Activity 2.18 Modifying and Shrinking the Worksheet View
Activity 2.19 Splitting a Worksheet Window into Panes
Activity 2.20 Printing Titles and Scaling to Fit
More Knowledge Scaling for Data That Is Slightly Larger Than the Printed Page
GO! with Office Web Apps
Objective Sort, Filter, and Use Functions in a Table in Excel Web App
Activity Sort, Filter, and Use Functions in a Table
Project 2B Weekly Sales Summary
Objective 7 Navigate a Workbook and Rename Worksheets
Activity 2.21 Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color of Worksheets
More Knowledge Copying a Worksheet
Objective 8 Enter Dates, Clear Contents, and Clear Formats
Activity 2.22 Entering and Formatting Dates
Activity 2.23 Clearing Cell Contents and Formats
More Knowledge Clearing an Entire Worksheet
Objective 9 Copy and Paste by Using the Paste Options Gallery
Activity 2.24 Copying and Pasting by Using the Paste Options Gallery
Objective 10 Edit and Format Multiple Worksheets at the Same Time
Activity 2.25 Grouping Worksheets for Editing
More Knowledge Hide Worksheet
Activity 2.26 Formatting and Constructing Formulas on Grouped Worksheets
Activity 2.27 Determining Multiple Totals at the Same Time
Activity 2.28 Formatting Grouped Worksheets
Objective 11 Create a Summary Sheet with Column Sparklines
Activity 2.29 Ungrouping Worksheets
Activity 2.30 Inserting a Worksheet
Activity 2.31 Constructing Formulas That Refer to Cells in Another Worksheet
Activity 2.32 Changing Values in a Detail Worksheet to Update a Summary Worksheet
Activity 2.33 Inserting Column Sparklines
Objective 12 Format and Print Multiple Worksheets in a Workbook
Activity 2.34 Moving a Worksheet, Repeating Footers, and Formatting Multiple Worksheets in a Workbook
Activity 2.35 Printing All or Individual Worksheets in a Workbook
GO! with Office Web Apps
Objective Summarize the Data on Multiple Worksheets in Excel Web App
Activity Creating an Inventory Valuation Report in the Excel Web App
GO! with Microsoft Office 365
Summary, GO! Learn It Online, GO! For Job Success
Guide to Chapter Assessments
Glossary
Skills Review
Mastering Excel
Rubric
GO! Think
Chapter 3 Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools
Project 3A Enterprise Fund Pie Chart
Objective 1 Chart Data with a Pie Chart
Activity 3.01 Calculating Values for a Pie Chart
Activity 3.02 Creating a Pie Chart in a Chart Sheet
Objective 2 Format a Pie Chart
Activity 3.03 Formatting a Chart Title by Applying a WordArt Style and Changing Font Size
Activity 3.04 Formatting Chart Elements by Removing a Legend and Adding and Formatting Data Labels
Activity 3.05 Formatting a Data Series with 3-D Effects
Activity 3.06 Formatting a Data Series with a Shadow Effect
Activity 3.07 Rotating a Pie Chart by Changing the Angle of the First Slice
Activity 3.08 Exploding and Coloring a Pie Slice
Activity 3.09 Formatting the Chart Area
Objective 3 Edit a Workbook and Update a Chart
Activity 3.10 Editing a Workbook and Updating a Chart
Objective 4 Use Goal Seek to Perform What-If Analysis
Activity 3.11 Using Goal Seek to Perform What-If Analysis
Activity 3.12 Preparing and Printing a Workbook with a Chart Sheet
GO! with Office Web Apps
Objective Create a Jpeg Photo of a Chart and Upload to a OneNote Web App Notebook
Activity Creating a Jpeg Photo of a Chart and Uploading It to a OneNote Web App Notebook
Project 3B Tourism Spending Projection with Line Chart
Objective 5 Design a Worksheet for What-If Analysis
Activity 3.13 Using Parentheses in a Formula to Calculate a Percentage Rate of Increase
More Knowledge Use of Parentheses in a Formula
Activity 3.14 Using Format Painter
More Knowledge Percentage Calculations
Activity 3.15 Calculating a Value After an Increase
More Knowledge Percent Increase or Decrease
Objective 6 Answer What-If Questions by Changing Values in a Worksheet
Activity 3.16 Answering What-If Questions and Using Paste Special
Objective 7 Chart Data with a Line Chart
Activity 3.17 Inserting Multiple Rows and Creating a Line Chart
Activity 3.18 Formatting Axes in a Line Chart
Activity 3.19 Formatting the Chart Area in a Line Chart
Activity 3.20 Formatting the Plot Area Gridlines and Axis Fonts in a Line Chart
More Knowledge Resizing a Chart
GO! with Office Web Apps
Objective Convert an Excel Worksheet to a Google Docs Spreadsheet with a Chart
Activity Converting an Excel Worksheet to a Google Docs Spreadsheet with a Chart
GO! with Microsoft Office 365
Activity Using a Team Site to Collaborate
Summary, GO! Learn It Online, GO! For Job Success
Guide to Chapter Assessments
Glossary
Skills Review
Mastering Excel
Rubric
GO! Think
