Excel 2007 Chapter 2:
Formulas, Functions, Formatting & Web Queries

All assignments on this page are due on 23 Feb, and may not be accepted for full credit past 25 Feb.



Chapter 2 Lessons

 

eBook Lesson 2:
Formulas, Functions, Formatting & Web Queries


Files to turn in:

LN Silver Dollars Stock Club Portfolio Summary.xlsx
+ 3 printouts

 


Rubric

 


25 points

 

 

Chapter 2
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:

LN Apply 1-1 Car-B-Clean Profit Analysis Complete.xlsx
+ 4 printouts

LN Extend 2-1 Biology 201 Midterm Scores Complete.xlsx

LN Make It Right 2-1 El Centro Diner Payroll Report Corrected.xlsx

SAM Lab 2-1 (link)

LN Weight Loss Plan.xlsx
or
LN Doze-Now Profit Potential.xlsx

 

Rubric



Rubric


Rubric

 

 

Rubric



15 points



10 points


10 points


30 points

40 points


Chapter 2 Assessments

Complete as Homework!


Vocab Quiz 2 (Quia)

Quia Review Worksheet 2


19 points

47 points

 

Chapter 2
Reflection Question

Complete as Homework!

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

Add the subject line Excel RQ 2

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

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

Do you prefer to enter formulas and functions using automatic options such as Point Mode and the Insert Function box, or do you prefer to type the formulas and functions directly yourself?

 

 

 

 

15 points