Chapter 1 Projects 1A and 1B

Creating a Worksheet and Charting Data

Project 1A

Outcomes

Create a sales report with an embedded column chart and sparklines.

Objectives

• Create, Save, and Navigate an Excel Workbook
• Enter Data in a Worksheet
• Construct and Copy Formulas and Use the SUM Function
• Format Cells with Merge & Center, Cell Styles, and Themes
• Chart Data to Create a Column
• Chart and Insert Sparklines
• Print a Worksheet, Display Formulas, and Close Excel

Project 1B

Outcomes

Calculate the value of a worksheet.

Objectives

• Check Spelling in a Worksheet
• Enter Data by Range
• Construct Formulas for Mathematical Operations
• Edit Values in a Worksheet
• Format a Worksheet

Assignment

• Complete Project 1A on pages 57 thru 85
  • Submit the Project 1A Quarterly Sales workbook 
• Complete Project 1B on pages 87 thru 100
  • Submit the Project 1B Plyo Products workbook

If you are having trouble submitting your files, watch this short video on How to Submit One or More Files in Canvas.