Files Created and/or Required For
The Office 2007 text by O’Leary Excel 2007 |
Hands-On Exercises |
Exercise 1. |
Exercise 2. |
Exercise 3. |
Exercise 4. |
Exercise 5. |
Lab 1. |
ex01_Animal Housing.xlsx, Animal
Housing Analysis.xlsx |
ex01_US Hurricanes.xlsx, US
Hurricanes Analysis.xlsx |
ex01_Family Income.xlsx, Family
Income.xlsx |
ex01_Publishing Salaries.xlsx,
Publishing
Salaries.xlsx |
Ex01_Pecan Groves Budget.xlsx, Pecan
Groves.xlsx |
Lab 2. |
ex02_Credit Data.xlsx,
Graphic ex02_Credit Card (Optional),
Teens and Credit.xlsx |
ex02_Music Download Analysis.xlsx,
ex02_mp3 player (Optional), Music
Download Analysis.xlsx |
ex02_Adoptions.xlsx, Graphic
ex02_Pets (Optional), Adoption
Tracking.xlsx |
Graphic ex02_Basketball or ex02_Volleyball (Optional),
Youth Sports Data.xlsx |
Graphic ex02_Computer Girl and ex02_Computer Boy (Optional),
Teen Online Activities.xlsx |
Lab 3. |
ex03_Juice Bar.xlsx, Juice Bar.xlsx |
ex03_Cookie Time.xlsx, Cookie
Time.xlsx |
ex03_Paris Tour.xlsx, Paris
Tour.xlsx |
ex03_Grade Report.xlsx, Grade
Report.xlsx (In
Folder Grade Analysis) |
ex03_Doggie Day Care.xlsx, Doggie
Day Care.xlsx |
|
|
|
|
|
|
|
|
|
|
|
|
|
Exercise 1. |
Exercise 2. |
Exercise 3. |
Exercise 4. |
Exercise 5. |
Working Together 1. |
exwt1_Rescue Memo.docx, exwt1_Contributions.xlsx,
Contributions.xlsx,
RescueMemo Linked.doxs
|
exwt1_Tour Status Report.docx, exwt1_Adventure Travel Status.xlsx,
Adventure Travel Status.xlsx,
March Status Report.docx
|
exwt1_Home Price Memo.docx, exwt1_Real Estate Prices.xlsx,
Home Price Memo.docx |
|
|
Hands-On Exercises |
Exercise 1. |
Exercise 2. |
Exercise 3. |
Exercise 4. |
Exercise 5. |
Lab 4. |
ex04_IronWorks Income.xlsx,IronWorks
Income1.xlsx, Template:IronWorks
Income Template |
ex04_Day Care.xlsx, Doggie Day
Care.xlsx |
ex04_Travel Analysis.xlsx, Airlines
Income Analysis.xlsx, Template:Income Analysis template |
ex04_Cards and Gifts 2009.xlsx, ex04_Cards and Gifts 2008xlsx,
Cards and Gifts 2009.xlsx, Template:Cards
and Gifts Analysis Template |
ex04_ARF Contributions.xlsx, ARF
Analysis.xlsx, Template: ARF
Analysis Template |
|
|
|
|
|
|
|
Exercise 1. |
Exercise 2. |
Exercise 3. |
Exercise 4. |
Exercise 5. |
Lab 5. |
ex05_ARF Volunteers.xlsx,
Volunteers.xlsx
|
ex05_Att Sales.xlsx, ATT Projected
Sales.xlsx, Template:Projected
Sales form |
ex05_Electronics Analyzer.xlsx,
Electronics Analyzer.xlsx |
ex05_Furniture sales.xlsx,
Furniture
Delivery.xlsx, Template:
Furniture Delivery Form |
ex05_Grades.xlsx,
Gradebook.xlsx |
Lab 6. |
ex06_LFC Employee List.xlsx, LFC
Analysis.xlsx |
ex06_Kodiak Jobs.xlsx, Kodiak Jobs
Update.xlsx |
ex06_Wilson employees.xlsx, Wilson
Employee Rewards.xlsx |
ex06_ATT Client Table.xlsx, ATT Client
Table2.xlsx |
ex06_Arf Inventory.xlsx, ARF
Inventory.xlsx |
Working Together 2. |
Exwt2_Decorator’s Resource Gallery.xlsx,
Artist Inventory.xlsx |
Wilson Employee rewards.xlsx,Lab 6,
#3, Employee Rewards Web Page.htm,
Graphic exwt2_Awards image |
|
|
|
|
|
|
|
|
|
On Your Own |
Exercise 1. |
Exercise 2. |
Exercise 3. |
Exercise 4. |
Exercise 5. |
Lab 1. |
Calorie Tracking.xlsx |
Personal Budget.xlsx |
Project Hours.xlsx |
Music Analysis.xlsx |
Electronics Analysis.xlsx
|
Lab 2. |
ex02_Job Market.xlsx, Seminar.xlsx |
Grades.xlsx |
Mutual Funds.xlsx |
ex02_Graduate School.xlsx, Graduate
School2.xlsx |
Insurance.xlsx |
Lab 3. |
Personal Budget2.xlsx
|
Company Business.xlsx (Folder named
Business) |
House Analysis.xlsx (Folder named
Housing) |
Inventory Tracking.xlsx |
My Business,.xlsx |
Lab 4. |
Video game Projections.xlsx |
Spring Break Analysis.xlsx |
Expansion Projections.xlsx |
Stock Analysis.xlsx |
Loan Analysis Template |
Lab 5. |
Car Purchase Analysis.xlsx,
Template:Payment Analysis Template |
My 401K.xlsx |
Furniture Loan Analysis.xlsx,
Template:Furniture Loan Analysis
Template |
Speeding Fines.xlsx,
Template:Speeding Fines template
|
Laptop Computers.xlsx,
Template:Laptop Computer Template |
Lab 6. |
Bradford Suppliers.xlsx |
Toy Inventory.xlsx |
Summer Baseball League.xlsx |
Pet Sitting Customers.xlsx |
CHB Inventory.xlsx |
|
|
|
|
|
|
1.
File names typed in blue and
italics are files created in the Exercise by the student.
2.
File names typed in red are files
created by the student in another Exercise and used by the student in the
current Exercise.
3.
Files typed in black are files provided by the authors.