Chapter 2 - Projects 2A and 2B

Using Functions, Creating Tables, and Managing Large Workbooks

Project 2A

Outcomes

Analyze inventory by applying statistical and logical calculations to data and by sorting and filtering data.

Objectives

• Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions
• Move Data, Resolve Error Messages, and Rotate Text
• Use COUNTIF and IF Functions, and Apply Conditional Formatting
• Use Date & Time Functions and Freeze Panes
• Create, Sort, and Filter an Excel Table
• View, Format, and Print a Large Worksheet

Project 2B

Outcomes

Summarize the data on multiple worksheets.

Objectives

• Navigate a Workbook and Rename Worksheets
• Enter Dates, Clear Contents, and Clear Formats
• Copy and Paste by Using the Paste Options Gallery
• Edit and Format Multiple Worksheets at the Same Time
• Create a Summary Sheet with Column Sparklines
• Format and Print Multiple Worksheets in a Workbook

Assignments

• Complete Project 2A on pages 124 thru 146
  • Submit the Project 2A Tree Inventory workbook 
• Complete Project 2B on pages 148 thru 165
  • Submit the Project 2B Weekly Sales workbook

 How do I submit my assignment files?