Benchmark Series: Microsoft Excel 365 Levels 1 and 2

Microsoft Excel 365, 2019 Edition, Levels 1-2
	Copyright Page
	Brief Contents
	Contents
	Preface
		Achieving Proficiency in Excel
			Proven Instructional Design
			Chapter Openers Present Learning Objectives
			Activities Build Skill Mastery within Realistic Context
			Chapter Review Tools Reinforce Learning
		The Cirrus Solution
			Dynamic Training
			Chapter Review and Assessment
			Unit Review and Assessment
			Student eBook
			Instructor eResources
		About the Authors
	Getting Startedin Office 365
		Identifying Computer Hardware
			System Unit (PC/Tower)
			Monitor
			Keyboard
			Drives and Ports
			Printer
			Mouse
			Touchpad
			Touchscreen
		Choosing Commands
			Using Keyboard Shortcuts and Accelerator Keys
			Choosing Commands from a Drop-Down List
			Choosing Options from a Dialog Box or Task Pane
			Choosing Commands with Shortcut Menus
		Working with Multiple Applications
		Maintaining Files and Folders
			Creating and Naming a Folder
			Selecting and Opening Files and Folders
			Deleting Files and Folders
			Moving and Copying Files and Folders
			Renaming Files and Folders
			Viewing Files and Folders
			Managing Files at the Info Backstage Area
		Customizing Settings
		Retrieving and Copying Data Files
	Microsoft Excel, Level 1, Unit 1 - Preparing and Formatting Worksheets
		1 - Preparing an Excel Workbook
			Performance Objectives
			Creating a Worksheet
				Entering Data in a Worksheet
				Saving a Workbook
				Editing Data in a Cell
				Printing a Worksheet
				Closing a Workbook and Closing Excel
			Using Automatic Entering Features
				Using AutoComplete
				Using AutoCorrect
				Using AutoFill
			Opening a Workbook
				Opening a Workbook from the Recent Option List
				Pinning and Unpinning Workbooks and Folders
			Entering Formulas
				Using the AutoSum Button to Add Numbers
				Using the AutoSum Button to Average Numbers
				Using the Fill Handle to Copy a Formula
			Selecting Cells
				Selecting Cells Using the Mouse
				Selecting Cells Using the Keyboard
				Selecting Data within Cells
			Applying Basic Formatting
				Changing Column Width
				Merging and Centering Cells
				Formatting Numbers
			Using the Tell Me Feature
			Using Help
				Getting Help from a ScreenTip
				Getting Help in a Dialog Box or at the Backstage Area
			Chapter Summary
			Commands Review
		2 - Inserting Formulas in a Worksheet
			Performance Objectives
			Writing Formulas with Mathematical Operators
				Copying a Formula with Relative Cell References
				Checking Cell References in a Formula
				Writing a Formula by Pointing
				Determining the Order of Operations
				Using the Trace Error Button
				Identifying Common Formula Errors
			Inserting Formulas with Functions
				Writing Formulas with Statistical Functions
				Writing Formulas with the NOW and TODAY Functions
			Displaying Formulas
			Using Absolute and Mixed Cell References in Formulas
				Using an Absolute Cell Reference in a Formula
				Using a Mixed Cell Reference in a Formula
			Chapter Summary
			Commands Review
		3 - Formatting a Worksheet
			Performance Objectives
			Changing Column Width
				Changing Column Width Using Column Boundaries
				Changing Column Width at the Column Width Dialog Box
			Inserting and Deleting Cells, Rows, and Columns
				Inserting Rows
				Inserting Columns
				Deleting Cells, Rows, or Columns
				Clearing Data in Cells
			Applying Formatting
				Applying Font Formatting
				Formatting with the Mini Toolbar
				Applying Alignment Formatting
			Applying a Theme
			Formatting Numbers
				Formatting Numbers Using Number Group Buttons
				Applying Number Formatting at the Format Cells Dialog Box
			Applying Formatting Using the Format Cells Dialog Box
				Aligning and Indenting Data
				Changing the Font
				Adding Borders to Cells
				Adding Fill and Shading to Cells
				Repeating the Last Action
			Formatting with Format Painter
			Hiding and Unhiding Columns and Rows
			Chapter Summary
			Commands Review
		4 - Enhancing a Worksheet
			Performance Objectives
			Formatting a Worksheet Page
				Changing Margins
				Centering a Worksheet Horizontally and/or Vertically
				Changing Page Orientation
				Changing the Paper Size
				Inserting and Removing Page Breaks
				Printing Column and Row Titles on Multiple Pages
				Scaling Data
				Inserting a Background Picture
				Printing Gridlines and Row and Column Headings
				Printing a Specific Area of a Worksheet
			Inserting Headers and Footers
			Customizing Print Jobs
			Checking Spelling
			Using Undo and Redo
			Finding and Replacing Data and Cell Formatting
			Sorting Data
				Completing a Custom Sort
				Sorting More Than One Column
			Filtering Data
			Chapter Summary
			Commands Review
	Microsoft Excel LEvel 1, Unit 2 - Enhancing the Display of Workbooks
		5 - Moving Data within and between Workbooks
			Performance Objectives
			Creating a Workbook with Multiple Worksheets
				Inserting a New Worksheet
				Deleting a Worksheet
				Selecting Multiple Worksheets
			Copying, Cutting, and Pasting Cells
				Copying and Pasting Selected Cells
				Using Paste Options
				Moving Selected Cells
				Copying and Pasting Using the Clipboard Task Pane
				Pasting Values Only
			Managing Worksheets
				Hiding and Unhiding a Worksheet in a Workbook
				Printing a Workbook Containing Multiple Worksheets
				Changing the Zoom
				Splitting a Worksheet and Freezing and Unfreezing Panes
			Naming and Using a Range
			Working with Windows
				Opening Multiple Workbooks
				Arranging Workbooks
				Hiding and Unhiding Workbooks
				Sizing and Moving Workbooks
			Moving, Linking, Copying, and Pasting Data between Workbooks
				Moving and Copying Data
				Linking Data
				Copying and Pasting Data between Programs
			Chapter Summary
			Commands Review
		6 - Maintaining Workbooks
			Performance Objectives
			Managing the Recent Option List
				Pinning and Unpinning a Workbook
				Recovering an Unsaved Workbook
				Clearing the Recent Option List and the Recent List
			Managing Worksheets
				Copying a Worksheet to Another Workbook
				Moving a Worksheet to Another Workbook
			Formatting with Cell Styles
				Applying a Cell Style
				Defining a Cell Style
				Modifying a Cell Style
				Copying Cell Styles to Another Workbook
				Removing a Cell Style
				Deleting a Cell Style
			Inserting Hyperlinks
				Linking to an Existing Web Page or File
				Navigating Using Hyperlinks
				Linking to a Place in the Workbook
				Linking to a New Workbook
				Linking Using a Graphic
				Linking to an Email Address
				Modifying, Editing, and Removing a Hyperlink
			Using Excel Templates
			Inserting and Managing Comments
				Inserting a New Comment
				Posting a Comment
				Editing and Deleting a Comment
				Viewing and Managing Comments at the Comments Task Pane
			Writing Formulas with Financial Functions
				Finding the Periodic Payments for a Loan
				Finding the Future Value of a Series of Payments
			Chapter Summary
			Commands Review
		7 - Creating Charts and Inserting Formulas
			Performance Objectives
			Creating a Chart
				Sizing and Moving a Chart
				Editing Data and Adding a Data Series
				Formatting with Chart Buttons
			Printing a Chart
			Changing the Chart Design
				Changing the Chart Style
				Switching Rows and Columns
				Changing Chart Layout and Colors
				Changing the Chart Location
				Adding, Moving, and Deleting Chart Elements
			Changing Chart Formatting
				Formatting a Selection
				Inserting a Shape
				Creating Alternative Text for an Image
				Using the Quick Analysis Feature
				Applying Formatting at a Task Pane
				Changing Chart Height and Width Measurements
				Deleting a Chart
			Writing Formulas with the Logical IF Function
				Writing Formulas with an IF Function Using the Function Arguments Dialog Box
				Writing IF Statements Containing Text
			Chapter Summary
			Commands Review
		8 - Adding Visual Interest to Workbooks
			Performance Objectives
			Inserting Symbols and Special Characters
			Inserting an Image
				Customizing and Formatting an Image
				Sizing and Moving an Image
				Formatting an Image at the Format Picture Task Pane
				Inserting an Online Image
			Creating and Inserting a Screenshot
			Inserting and Formatting a Shape
			Inserting and Modifying Text Boxes
			Inserting and Customizing Icons
			Inserting and Customizing 3D Models
			Inserting a SmartArt Graphic
				Entering Data in a SmartArt Graphic
				Sizing, Moving, and Deleting a SmartArt Graphic
				Changing the SmartArt Graphic Design
				Changing the SmartArt Graphic Formatting
			Creating, Sizing, and Moving WordArt
			Chapter Summary
			Commands Review
	Index
	Microsoft Excel, Level 2, Unit 1 - Advanced Formatting, Formulas,and Data Management
		1 - Advanced Formatting Techniques
			Performance Objectives
			Applying Conditional Formatting
				Applying Conditional Formatting Using a New Rule
				Editing and Deleting a Conditional Formatting Rule
				Applying Conditional Formatting Using an Icon Set
				Applying Conditional Formatting Using Data Bars and Color Scales
				Applying Conditional Formatting Using a Formula
				Applying Conditional Formatting Using Quick Analysis
			Applying Fraction Formatting and Scientific Formatting
			Applying Special Number Formatting
			Creating a Custom Number Format
			Filtering a Worksheet Using a Custom AutoFilter
			Filtering and Sorting Data and Removing a Filter
				Filtering and Sorting Data Using Conditional Formatting or Cell Attributes
				Removing a Filter
				Defining a Custom Sort
			Applying an Advanced Filter
			Chapter Summary
			Commands Review
		2 - Advanced Functions and Formulas
			Performance Objectives
			Managing Range Names
			Using Statistical Functions
				Using Statistical Functions: COUNTIF and COUNTIFS
				Using Statistical Functions: AVERAGEIF and AVERAGEIFS
			Using Math and Trigonometry Functions: SUMIF and SUMIFS
			Using Lookup Functions
				Using the VLOOKUP Function
				Using the HLOOKUP Function
			Using the PPMT Financial Function
			Using and Nesting Logical Functions
				Using the Nested IF Logical Function
				Using Logical Functions: Nested IF, AND, and OR
				Using the ROUND Function
				Using the IFS Logical Function
				Viewing Long Formulas in the Formula Bar
			Chapter Summary
			Commands Review
		3 - Working with Tables and Data Features
			Performance Objectives
			Formatting Data as a Table
				Modifying a Table
				Applying Table Styles, Table Style Options, and Table Properties
			Sorting and Filtering a Table
			Working with Data Tools
				Separating Data Using Text to Columns
				Identifying and Removing Duplicate Records
				Validating Data Entry
			Converting a Table to a Normal Range and Subtotaling Related Data
				Modifying Subtotals
				Selecting Data from Different Outline Levels
			Grouping and Ungrouping Data
			Chapter Summary
			Commands Review
		4 - Summarizing and Consolidating Data
			Performance Objectives
			Summarizing Data in Multiple Worksheets Using Range Names and 3-D References
			Summarizing Data by Linking to Ranges in Other Worksheets or Workbooks
			Maintaining External References
			Summarizing Data Using the Consolidate Feature
			Creating PivotTables
				Creating a Recommended PivotTable
				Building a PivotTable
				Formatting and Filtering a PivotTable
				Changing the PivotTable Summary Function
				Filtering a PivotTable Using Slicers
				Filtering a PivotTable Using a Timeline
			Creating a PivotChart
			Summarizing Data with Sparklines
				Creating Sparklines
				Customizing Sparklines
			Chapter Summary
			Commands Review
	Microsoft Excel, Level 2, Unit 2 - Managing and Integrating Data and the Excel Environment
		5 - Using Data Analysis Features
			Performance Objectives
			Pasting Data Using Paste Special Options
				Selecting Other Paste Special Options
				Transposing Data
				Performing a Mathematical Operation While Pasting
			Using Goal Seek to Populate Cells
			Adding, Editing, and Applying Scenarios
				Applying a Scenario
				Editing a Scenario
				Deleting a Scenario
				Generating a Scenario Summary Report
			Performing What-If Analysis Using Data Tables
				Creating a One-Variable Data Table
				Creating a Two-Variable Data Table
			Using Auditing Tools
				Tracing Precedent and Dependent Cells
				Troubleshooting Formulas
				Circling Invalid Data
				Watching a Formula Cell
			Chapter Summary
			Commands Review
		6 - Exporting, Importing, and Transforming Data
			Performance Objectives
			Exporting Data from Excel
				Copying and Pasting Data into Word
				Breaking a Link to an Excel Object
				Copying and Pasting Data into PowerPoint
				Copying and Pasting Data into Access
				Exporting a Worksheet as a Text File
			Importing Data into Excel
				Importing Data from Access
				Modifying Data with the Power Query Editor
				Importing Data from a Text File
				Refreshing, Modifying, and Deleting Queries
				Editing or Removing the Source for a Query
				Transforming Data Using Flash Fill
			Using Text Functions
			Chapter Summary
			Commands Review
		7 - Automating Repetitive Tasks and Customizing Excel
			Performance Objectives
			Changing Display Options
			Minimizing the Ribbon
			Customizing Ribbons and the Quick Access Toolbar
				Exporting and Importing Customizations
				Customizing the Ribbon
				Customizing the Quick Access Toolbar
				Resetting the Ribbons and the Quick Access Toolbar
			Creating and Applying a Custom View
			Automating Tasks Using Macros
				Creating a Macro
				Saving Workbooks Containing Macros
				Running a Macro
				Assigning a Macro to a Shortcut Key
				Editing a Macro
				Managing and Deleting Macros
			Inserting and Configuring Form Controls
				Inserting Form Controls
				Configuring Form Controls
				Creating a Macro Button Form Control
			Saving a Workbook as a Template
				Using a Custom Template
				Deleting a Custom Template
			Customizing Save Options
			Viewing Trust Center Settings
			Chapter Summary
			Commands Review
		8 - Protecting and Distributing a Workbook
			Performance Objectives
			Adding Workbook Properties
			Protecting and Unprotecting Worksheets
				Protecting and Unprotecting the Structure of a Workbook
			Adding and Removing a Password to Open a Workbook
			Preparing a Workbook for Distribution
				Checking for Accessibility Issues
				Inspection Results
				Inspecting a Workbook and Removing Information before Distributing It
				Marking a Workbook as Final
				Using the Compatibility Checker
			Distributing Workbooks
				Publishing a Workbook as a PDF File
				Publishing a Workbook as an XPS File
				Publishing a Worksheet as a Web Page
				Exporting and Importing XML Data
				Creating an XML Schema
				Exporting a Worksheet as an XML File
				Importing an XML File
			Chapter Summary
			Commands Review
	Index
Benchmark Series: Microsoft Excel 365, 2019 Edition, Level 1, Review and Assessment
	Copyright Page
	Contents
	Microsoft Excel, Level 1, Unit 1 - Preparing and Formatting Worksheets
		1 - Preparing an Excel Workbook
			Skills Assessment
				Assessment 1 - Create a Worksheet Using AutoCorrect and AutoComplete
				Assessment 2 - Create and Format a Worksheet
				Assessment 3 - Create a Worksheet Using the Fill Handle
				Assessment 4 - Insert Formulas in a Worksheet
			Visual Benchmark
				Create, Format, and Insert Formulas in a Worksheet
			Case Study
				Part 1
				Part 2
				Part 3
				Part 4
		2 - Inserting Formulas in a Worksheet
			Skills Assessment
				Assessment 1 - Insert AVERAGE, MAX, and MIN Functions
				Assessment 2 - Insert the SUM Function and Enter Formulas with Mathematical Operators
				Assessment 3 - Write Formulas with Absolute Cell References
				Assessment 4 - Write Formulas with Mixed Cell References
				Assessment 5 - Use Help to Learn about Excel Options
			Visual Benchmark
				Create a Worksheet and Insert Formulas
			Case Study
				Part 1
				Part 2
				Part 3
				Part 4
		3 - Formatting a Worksheet
			Skills Assessment
				Assessment 1 - Format a Sales Worksheet
				Assessment 2 - Format an Overdue Accounts Worksheet
				Assessment 3 - Format a Supplies and Equipment Worksheet
				Assessment 4 - Format a Financial Analysis Worksheet
			Visual Benchmark
				Create a Worksheet and Insert Formulas
			Case Study
				Part 1
				Part 2
				Part 3
				Part 4
		4 - Enhancing a Worksheet
			Skills Assessment
				Assessment 1 - Format a Data Analysis Worksheet
				Assessment 2 - Format a Test Results Worksheet
				Assessment 3 - Format an Equipment Rental Worksheet
				Assessment 4 - Format an Invoices Worksheet
				Assessment 5 - Create a Worksheet Containing Keyboard Shortcuts
			Visual Benchmark
				Create and Format an Expense Worksheet
			Case Study
				Part 1
				Part 2
				Part 3
		Unit 1 Performance Assessment
			Assessing Proficiency
				Assessment 1 - Calculate Total, Maximum, Minimum, and Average Yearly Sales
				Assessment 2 - Create a Worksheet with AutoFill and Calculate Total Hours and Gross Pay
				Assessment 3 - Create a Sales Bonus Workbook
				Assessment 4 - Format a Department Budget
				Assessment 5 - Format a Weekly Payroll Workbook
				Assessment 6 - Format a Customer Sales Analysis Workbook
				Assessment 7 - Format an Invoices Workbook
			Writing Activities
				Activity 1 - Plan and Prepare an Orders Summary Workbook
				Activity 2 - Prepare a Depreciation Workbook
				Activity 3 - Insert a Straight-Line Depreciation Formula
			Internet Research
				Create a Travel Planning Worksheet
	Microsoft Excel, Level 1, Unit 2 - Enhancing the Display of Workbooks
		5 - Moving Data within and between Workbooks
			Skills Assessment
				Assessment 1 - Copy and Paste Data between Worksheets in a Sales Workbook
				Assessment 2 - Copy, Paste, and Format Worksheets in an Income Statement Workbook
				Assessment 3 - Freeze and Unfreeze Window Panes in a Test Scores Workbook
				Assessment 4 - Create, Copy, Paste, and Format Cells in an Equipment Usage Workbook
				Assessment 5 - Copying and Linking Excel Data in a Word Document
			Visual Benchmark
				Create and Format a Sales Worksheet Using Formulas
			Case Study
				Part 1
				Part 2
				Part 3
				Part 4
		6 - Maintaining Workbooks
			Skills Assessment
				Assessment 1 - Define and Apply Cell Styles to a Projected Earnings Workbook
				Assessment 2 - Insert Hyperlinks in a Bookstore Workbook
				Assessment 3 - Write a Formula with the PMT Function
				Assessment 4 - Write a Formula with the FV Function and Insert Comments
				Assessment 5 - Apply Conditional Formatting to a Sales Workbook
			Visual Benchmark
				Fill in an Expense Report Form
			Case Study
				Part 1
				Part 2
				Part 3
				Part 4
		7 - Creating Charts and Inserting Formulas
			Skills Assessment
				Assessment 1 - Create a Net Profit Chart
				Assessment 2 - Create a Company Sales Column Chart
				Assessment 3 - Create Quarterly Domestic and Foreign Sales Bar Chart
				Assessment 4 - Create a Fund Allocations Pie Chart
				Assessment 5 - Write a Formula with the IF Function
				Assessment 6 - Create a Stacked Column Chart
				Assessment 7 - Learn about Excel Options
			Visual Benchmark
				Create and Format a Pie Chart
			Case Study
				Part 1
				Part 2
				Part 3
				Part 4
				Part 5
		8 - Adding Visual Interest to Workbooks
			Skills Assessment
				Assessment 1 - Insert an Image and WordArt in an Equipment Sales Workbook
				Assessment 2 - Insert Formulas and an Icon and Format a Travel Company Workbook
				Assessment 3 - Insert and Format Shapes in a Company Sales Workbook
				Assessment 4 - Insert and Format a SmartArt Graphic in a Sales Workbook
				Assessment 5 - Insert and Modify a 3D Model
			Visual Benchmark
				Insert Formulas, WordArt, an Image, and a Shape in a Worksheet
			Case Study
				Part 1
				Part 2
				Part 3
				Part 4
		Microsoft Excel Unit 2 Performance Assessment
			Assessing Proficiency
				Assessment 1 - Copy and Paste Data and Insert WordArt in a Training Scores Workbook
				Assessment 2 - Manage Multiple Worksheets in a Projected Earnings Workbook
				Assessment 3 - Create Charts in Worksheets in a Sales Totals Workbook
				Assessment 4 - Create a Line Chart and Insert a Comment
				Assessment 5 - Create a Pie Chart and Insert an Icon
				Assessment 6 - Use the PMT Function and Apply Formatting to a Workbook
				Assessment 7 - Use the IF Function and Apply Formatting to a Workbook
				Assessment 8 - Insert a Text Box and Hyperlinks in a Travel Workbook
				Assessment 9 - Insert an Image and a SmartArt Graphic in a Workbook
				Assessment 10 - Insert a Symbol, WordArt, and Screenshot in a Sales Workbook
				Assessment 11 - Insert and Format a Shape in a Budget Workbook
			Writing Activities
				Activity 1 - Prepare a Projected Budget
				Activity 2 - Create a Travel Tours Bar Chart
				Activity 3 - Prepare a Ski Vacation Worksheet
			Internet Research
				Find Information on Excel Books and Present the Data in a Worksheet
			Job Study
				Create a Customized Time Card for a Landscaping Company
Benchmark Series: Microsoft Excel 365, 2019 Edition, Level 2, Review and Assessment
	Copyright Page
	Contents
	Microsoft Excel, Level 2, Unit 1- Advanced Formatting, Formulas, and Data Management
		1 - Advanced Formatting Techniques
			Skills Assessment
				Assessment 1 - Use Conditional and Fraction Formatting
				Assessment 2 - Apply Custom Number Formatting
				Assessment 3 - Use Custom AutoFilter and Filter and Sort by Color
				Assessment 4 - Create, Edit, and Delete Formatting Rules
				Assessment 5 - Apply an Advanced Filter
			Visual Benchmark
				Format a Billing Summary
			Case Study
				Part 1
				Part 2
				Part 3
				Part 4
		2 - Advanced Function sand Formulas
			Skills Assessment
				Assessment 1 - Create Range Names and Use the Lookup Function
				Assessment 2 - Use Conditional Statistical and Math Functions
				Assessment 3 -Use the PMT and PPMT Financial Functions
				Assessment 4 - Use Logical Functions
				Assessment 1 - Use the HLOOKUP Function
			Visual Benchmark
				Activity 1 - Use Lookup, Statistical, and Math Functions in a Billing Summary
				Activity 2 - Use Lookup and Logical Functions to Calculate Cardiology Costs
			Case Study
				Part 1
				Part 2
				Part 3
				Part 4
		3 - Working with Tables and Data Features
			Skills Assessment
				Assessment 1 - Create and Format a Table
				Assessment 2 - Use Data Tools
				Assessment 3 - Subtotal Records
			Visual Benchmark
				Activity 1 - Using Table and Data Tools in a Call List
				Activity 2 - Using Subtotals in a Call List
			Case Study
				Part 1
				Part 2
				Part 3
				Part 4
		4 - Summarizing and Consolidating Data
			Skills Assessment
				Assessment 1 - Summarize Data in Multiple Worksheets Using Range Names
				Assessment 2 - Summarize Data Using Linked External References
				Assessment 3 - Summarize Data Using 3-D References
				Assessment 4 - Summarize Data in a PivotTable and a PivotChart
				Assessment 5 - Filter a PivotTable Using a Slicer and a Timeline
				Assessment 6 - Create and Customize Sparklines
			Visual Benchmark
				Summarize Real Estate Sales and Commission Data
			Case Study
				Part 1
				Part 2
				Part 3
				Part 4
		Unit 1 Performance Assessment
			Assessing Proficiency
				Assessment 1 - Conditionally Format and Filter a Help Desk Worksheet
				Assessment 2 - Use Conditional Logic Formulas in a Help Desk Worksheet
				Assessment 3 - Use Table and Data Management Features in a Help Desk Worksheet
				Assessment 4 - Add Subtotals to and Outline a Help Desk Worksheet andApply an Advanced Filter
				Assessment 5 - Use Financial and Text Functions to Analyze Data for a Project
				Assessment 6 - Analyze Sales Using a PivotTable, a PivotChart, and Sparklines
				Assessment 7 - Link to an External Data Source and Calculate Distributor Payments
			Writing Activities
				Activity 1 - Create a Worksheet to Track Memberships
				Activity 2 - Create a Worksheet to Log Hours Walked in a Company Fitness Contest
			Internet Research
				Create a Worksheet to Compare Online Auction Listing Fees
	Microsoft Excel 365, 2019 Edition, Level 2, Unit 2 - Managing and Integrating Dataand the Excel Environment
		5 - Using Data Analysis Features
			Skills Assessment
				Assessment 1 - Convert Columns to Rows, Add Source Cells to Destination Cells, and Filter Data
				Assessment 2 - Use Goal Seek
				Assessment 3 - Use Scenario Manager
				Assessment 4 - Create a Two-Variable Data Table
				Assessment 5 - Find and Correct Formula Errors
			Visual Benchmark
				Activity 1 - Find the Base Hourly Rate for Drum Lessons
				Activity 2 - Create Scenarios for Drum Lesson Revenue
			Case Study
				Part 1
				Part 2
				Part 3
				Part 4
		6 - Exporting, Importing, and Transforming Data
			Skills Assessment
				Assessment 1 - Link Data to a Word Document
				Assessment 2 - Embed Data in a PowerPoint Presentation
				Assessment 3 - Export Data as a Text File
				Assessment 4 - Import Data from Access and a Text File
				Assessment 5 - Import and Transform Data
			Visual Benchmark
				Import, Analyze, and Export Population Data
			Case Study
				Part 1
				Part 2
				Part 3
		7 - Automating Repetitive Tasks and Customizing Excel
			Skills Assessment
				Assessment 1 - Customize the Excel Environment
				Assessment 2 - Create Custom Views
				Assessment 3 - Create Macros and Save as a Macro-Enabled Workbook
				Assessment 4 - Run Macros
				Assessment 5 - Create Macros and Save as a Macro-Enabled Workbook
				Assessment 6 - Print Macros
				Assessment 7 - Create and Use a Template
			Visual Benchmark
				Activity 1 - Customize the Ribbon
				Activity 2 - Create a Custom Template
			Case Study
				Part 1
				Part 2
				Part 3
		8 - Protecting and Distributing a Workbook
			Skills Assessment
				Assessment 1 - Enter and Display Workbook Properties
				Assessment 2 - Protect an Entire Worksheet and Add a Password to a Workbook
				Assessment 3 - Unlock Cells and Protect a Worksheet and Protect a Workbook Structure
				Assessment 4 - Prepare a Workbook for Distribution
				Assessment 5 - Prepare and Distribute a Workbook
				Assessment 6 - Import an XML file
			Visual Benchmark
				Import, Analyze, and Export Population Data
			Case Study
				Part 1
				Part 2
				Part 3
				Part 4
		Unit 2 Performance Assessment
			Assessing Proficiency
				Assessment 1 - Use Goal Seek and Scenario Manager to Calculate Investment Proposals
				Assessment 2 - Calculate Investment Outcomes for a Portfolio Using a Two-Variable Data Table
				Assessment 3 - Solve an Error and Check for Accuracy in Investment Commission Formulas
				Assessment 4 - Export a Chart and Prepare and Distribute an Investment Portfolio Worksheet
				Assessment 5 - Import Investment Clients into a Workbook
				Assessment 6 - Automate and Customize an Investment Portfolio Workbook
				Assessment 7 - Create and Use an Investment Planner Template
				Assessment 8 - Protect a Confidential Investment Portfolio Workbook
			Writing Activity
				Create a Computer Maintenance Form Template
			Internet Research
				Activity 1 - Apply a What-If Analysis to a Planned Move
				Activity 2 - Research and Compare Smartphones
			Job Study
				Prepare a Wages Budget and Link the Budget to a Word Document