Microsoft Excel
Creating a Worksheet and an Embedded Chart
Lesson 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: (You need to be enrolled in Ecourse to view demos)
- In Class demonstration on how to create a Worksheet and Embedded Chart in Excel or view the following demo tutorial: Creating a Worksheet and Embedded Chart in Excel
Practice Exercises from Book:
(Once you get your book, download exercise files here.)
Do the following exercises from the Chaper "Creating a Worksheet and an Embedded Chart " in the assigned textbook.
- 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
Reading
- Read EX2 - EX 6 Worksheet Design Requirement
Assignment - Required for certificate
- Cases and Places Assignment 4 – Create a Worksheet to Analyze your field of interest. (page EX 80)