Microsoft Excel

Creating a Worksheet and an Embedded Chart

Week 4

Class Objectives:

Students will have mastered the material in this project when they can:

Lecture/Demo:

Lab/Hands On:

Do the following exercises from the Chaper "Creating a Worksheet and an Embedded Chart " in the assigned textbook. If necessary, download the exercises from the Book Resources opposite in the menu.

  1. Apply Your Knowledge Assignment 1, page EX70
  2. Make it Right - Page EX73
  3. In the Lab 1 - Create a Cost of Goods Worksheet. page EX74
  4. In the Lab 2 - Create an Annual Sales Analysis, page EX 75
  5. In the Lab 3 - Create a College Cost & Financial Worksheet, page EX77

Homework:

  1. Read EX2 - EX 6 Worksheet Design Requirements
  2. Cases and Places Assignment 4 – Create a Worksheet to Analyze your field of interest. (page EX 80)

Resources:

MS Excel Tutorials

Book Resources at www.scsite.com