| |
|
Points |
| |
|
|
| Chapter 4 |
Chapter 4, Main |
4 |
| |
Braden Mortgage Loan Payment |
|
| |
Pages EX 265 through EX 322
|
|
| |
|
|
| |
Chapter 4, Apply Your Knowledge |
4 |
| |
Monthly Loan Payment |
|
| |
Page EX 323 through EX 325 (Steps 1 through 8 only)
|
|
| |
|
|
| |
Chapter 4, In the Lab #1 |
5 |
| |
401(k) Retirement Planning Sheet |
|
| |
Pages EX 327 through EX 329
|
|
| |
|
|
| |
Chapter 4, In the Lab#2 |
5 |
| |
The Bean Bag Company , Quarterly Income Statement |
|
| |
Pages EX 330 through EX 332 (Steps 1 through 12 only)
|
|
| |
|
|
| |
Chapter 4, In the Lab#3 |
6 |
| |
eLoans Unlimited, Loan Analysis |
|
| |
Pages EX 332 through EX 334
|
|
| |
|
|
| |
Chapter 4, Cases and Places #1 |
6 |
| |
Fairview Clothing , Break-Even Point |
|
| |
Page EX 335
|
|
| |
|
|
| |
|
|
| Chapter 7 |
Chapter 7, Main |
8 |
| |
Caliber Steel |
|
| |
Pages EX 529 through EX 601 (skip pages 602 and 603)
|
|
| |
Note: On page EX 542, have the macro Print Preview and NOT Print the spreadsheet. |
|
| |
|
|
| |
Chapter 7, Apply Your Knowledge |
6 |
| |
Salioto's Food Mart |
|
| |
Pages EX 605 through EX 607
|
|
| |
Note: Have the macro Print Preview and NOT Print the spreadsheet. |
|
| |
|
|
| |
Chapter 7, In the Lab #1 |
7 |
| |
Richie's Subprime, Part 1 only |
|
| |
Pages EX 611 through EX 613
|
|
| |
|
|
| |
Chapter 7, Cases and Places #1 |
5 |
| |
Jack's Fish & Chips, Macros |
|
| |
Page EX 622
|
|
| |
|
|
| |
|
|
| Chapter 8 |
Chapter 8, Main |
5 |
| |
Perfected Packaging |
|
| |
Pages EX 625 through EX 689
|
|
| |
Note: Solver is an Add-in feature which can be found under Office button - Excel Options - Add-Ins - Manage - Go... You may need to install this Add-in prior completing the instructions beginning on page EX 648. |
|
| |
|
|
| |
Chapter 8, In the Lab #1 |
3 |
| |
Forrest Specialty Sports Caps |
|
| |
Pages EX 696 through EX 697
|
|
| |
|
|
| |
Chapter 8, Cases and Places #3 |
4 |
| |
Personal Car Loan Scenarios |
|
| |
Page EX 702
|
|
| |
|
|
| |
Chapter 8, In the Lab #2 |
5 |
| |
Witte Lawn Equipment |
|
| |
Pages EX 697 through 699 |
|
| |
|
|
| |
Chapter 8, Cases and Places #1 |
4 |
| |
Island Beverages |
|
| |
Page EX 702
|
|
| |
|
|
| |
|
|
| Chapter 9 |
Chapter 9, Apply Your Knowledge |
5 |
| |
Purity Systems |
|
| |
Pages EX 771 through 773
|
|
| |
|
|
| |
Chapter 9, In the Lab #1 |
6 |
| |
Jansen Builders, Importing Data into Excel |
|
| |
Pages EX 777 through EX 778
|
|
| |
Note: You will e-mail both the spreadsheet and exported text file. |
|
| |
|
|
| |
Chapter 9, Cases and Places #2 |
6 |
| |
City Sports |
|
| |
Page EX 783
|
|
| |
|
|
| |
Chapter 9, In the Lab #3 |
6 |
| |
Farmers Wholesale Cooperative, PivotTable and PivotChart |
|
| |
Pages EX 780 through EX 782
|
|
| |
|
|
|
|
|
| |
Total Points |
100 |
