Excel 2007 Chapter 3:
What-If Analysis, Charting
& Working with Large Worksheets

All assignments on this page are due on 4 Mar, and will not be accepted for full credit past 8 Mar.



Chapter 3 Lessons

 

eBook Lesson 3:
What-If Analysis, Charting & Working with Large Worksheets


Files to turn in:

LN Campus Clothiers Semiannual Financial Projection.xlsx
+ printout

 


Rubric

 


20 points

 

 

Chapter 3
Review & Practice:

 

eBook Review Activities:

Apply Your Knowledge




Extend Your Knowledge

Make It Right


In the Lab

Cases & Places:
Choose #1 or #2

Files to turn in:

Apply & Extend Answers in xlsx or docx file for Apply Parts 1-2 & Extend Part 1
LN Apply 3-1 Cell References Complete.xlsx


LN Extend 3-1 Complete Series Complete.xlsx

LN Make It Right 3-1 e-MusicPro.com Annual Projected Net Income Complete.xlsx

SAM Lab 3-1 (link)

LN Millenium Steel Sales Projection.xlsx
or
LN Chesterton Trib Bimonthly Projected Earnings and Expenditures.xlsx

 

Rubric




Rubric


Rubric

 

 

Rubric



10 points



10 points


10 points


30 points


40 points


Chapter 3 Assessments

Complete as Homework!


Vocab Quiz 3 (Quia)

Quia Review Worksheet 3


17 points

33 points

 

Chapter 3:
Reflection Question

Complete as Homework!

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

Add the subject line Excel RQ 3

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

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

Explain the difference between absolute, relative, and mixed cell referencing.

 

 

 

 

15 points