Excel 2007 Chapter 6:
Creating Templates & Working with Multiple Worksheets and Workbooks

All assignments on this page are due on 10 May, and may not be accepted for full credit past 14 May.

 

Chapter 6 Lessons


eBook Lesson 6:
Creating Templates & Working with Multiple Worksheets and Workbooks


Files to turn in:

LN NextDVR Profit Potential.xlsx
LN NVDR Company Profit Potental.xltx (template)
LN NVDR Kansas City Profit Potental.xlsx
LN NVDR Louisville Profit Potental.xlsx
LN NVDR Portland Profit Potental.xlsx
LN NextDVR Workspace.xlsx

 


Rubric

 


20 points

 

 

Chapter 6
Review & Practice:

 

eBook Review Activities:

Apply Your Knowledge


Extend Your Knowledge

Make It Right

In the Lab
Lab 6-1





Lab 6-2





Lab 6-3

Files to turn in:

LN Apply 6-1 Annual Payroll Totals Complete.xlsx (skip printouts)

LN Extend 6-1 Tennis Summary Complete.xlsx

LN Make It Right 6-1 Gems for Everyone Complete.xlsx

LN Lab 6-1 Part 1 Rings and Things Annual Sales Analysis.xlsx
LN Lab 6-1 Part 2 Rings and Things Annual Sales Analysis.xlsx
LN Lab 6-1 Part 3 Rings and Things Annual Sales Analysis.xlsx
(skip printouts)

Folder (zipped) containing:
LN Lab 6-2 Part 1 Emp Annual Payroll Totals.xlsx
+ all support files
LN Lab 6-2 Part 2 Emp Annual Payroll Totals.xlsx
+ any changed support files
(skip printouts)

LN Lab 6-3 Learn-N-Earn Stock Club Portfolio.xlsx
(skip printouts)

 

Rubric

 

Rubric


Rubric


Rubric





Rubric





Rubric



10 points

 

10 points


10 points


40 points

 



25 points

 



20 points


Chapter 6 Assessments

Complete as Homework!


Vocab Quiz 6 (Quia)

Quia Review Worksheet 6


points

points

 

Chapter 6:
Reflection Question

Complete as Homework!

Copy and paste the questions below into a new email message.

Add the subject line Excel RQ 6

Answer each question fully as directed in the RQ guidelines & Rubric page

Send the email to kerri.pangman@eu.dodea.edu

.

 

 

 

 

15 points