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:
- Start and Quit Excel
- Describe the Excel worksheet
- Enter text and numbers
- Use the AutoSum button to sum a range of cells
- Copy a cell to a range of cells using the fill handle
- Format a worksheet
- Create a 3-D Clustered column chart
- Open, save and print a worksheet
- Use the AutoCalculate area to determine statistics
- Correct errors on a worksheet
- Use the Excel Help system to answer questions
Lecture/Demo:
- In Class demonstration on how to create a Worksheet and Embedded Chart in Excel or view the following presentation: Project One –Creating a Worksheet and Embedded Chart in Excel
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.
- Apply Your Knowledge Assignment 1, page EX70
- Make it Right - Page EX73
- In the Lab 1 - Create a Cost of Goods Worksheet. page EX74
- In the Lab 2 - Create an Annual Sales Analysis, page EX 75
- In the Lab 3 - Create a College Cost & Financial Worksheet, page EX77
Homework:
- Read EX2 - EX 6 Worksheet Design Requirements
- Cases and Places Assignment 4 – Create a Worksheet to Analyze your field of interest. (page EX 80)
Resources:
