Microsoft Office Beginning Excel Intermediate Excel Advanced Excel  

Objectives

Exploring Strategies

Open for Business introduces the spreadsheets you need for a business or department: price sheets and check books. In both examples, there is a lot of repetitive data.

 

Copy and Paste are Iterative commands that let you quickly select a group of objects and replicate them.

 

Excel combines Copy and Paste into the AutoFill option.

 

Questions: How many steps are needed to select, copy and paste a cell? How is AutoFill more effective? Can you Autofill an Equation?

2. Downloads

Samples

 

3. Assessment

Performance

Multiple Choice

 

Resources

Lesson Plans

Exercises

 

Beginning Guide to Microsoft® Excel 2007

 

1. Guided Discovery

Read the lessons and follow the demonstrations.

 

Rain Washes Out Hamburg Page 7
Make a rainfall graph

 

It All Adds Up Page 20

Create a price sheet

 

A Question Of Balance Page 41

Calculate Revenue