Activity

Additional Instructions

Submit

Excel Tutorial 3, Sessions 3.1 & 3.2

Drake.xlsx

 (35 points)

Read and complete pages EX 113 – EX 150.

NOTES:  print the 2010 Proposed Budget sheet of the Drake Family Budget workbook. Then print the Home Savings Plan and Loan Analysis worksheets showing formulas.


After answering the Quick Check questions on pages EX 130 and EX 152, check your answers at the end of the chapter and review the Key Terms on page EX 47 to make sure you have a clear understanding of the concepts covered.
Be prepared to discuss any of these questions or terms in class.

p. 150, Step 3______

(budget sheet)

Formulas—_______

Tutorial 3 :
Review Assignment

Timov.xlsx

(15 points)

Complete the Practice Review Assignment on pages EX 152 - EX 153. When you are done, save the file as directed and print formulas view of the Family Budget worksheet of the YI Timov Family Budget. After best-fitting the column widths, you will still need to set this sheet to print on two landscaped pages—2 pages wide by 1 page tall in order to make the font large enough to easily read.

Step 15

Formulas— _______

Tutorial 3:
Case Problem 1

Chemistry.xlsx

(15 points)

Complete the Apply Case Problem 1 Assignment on pages EX 153 - EX 154. When you are done, save the file as directed and print the formulas view of the First Semester Scores worksheet of the YI Chemistry 303 Final Scores workbook. After best-fitting the column widths, you will still need to set this sheet to print on two landscaped pages—1 page wide by 2 pages tall (repeating the first 3 rows on both pages) in order to make the font large enough to easily read.

Step 13,

Formulas— _______
 

Tutorial 3:
Case Problem 2

Wizard.xlsx

(15 points)

Complete the Apply Case Problem 2 Assignment on pages EX 155 - EX 156. When you are done, save the file as directed and print the Order Form sheet of the YI WizardWorks Order Form.xlsx workbook.

Although you won’t be printing the formulas on this one, check your formulas with the full workbooks available online to make sure your formulas are correct.

Step 13__________

(worksheet)

Tutorial 3:
Case Problem 3

Loan.xlsx

 

 (20 points)

Complete the Challenge Case Problem 3 on pages EX 156 - EX 158. When you are done, save the file as directed and print the Loan Calculation sheet of the YI Loan Grid.xlsx workbook.

Although you won’t be printing the formulas on this one, check your formulas with the full workbooks available online to make sure your formulas are correct.

Step 11 __________

(worksheet)

EXTRA CREDIT

V6.xlsx

(up to 10 points)

Complete the Create Case Problem 4 on pages EX 158 - EX 159. When you are done, save the file as directed, and print the YI V6 Driving Test.xlsx workbook.

There are many ways to complete this and, since it is Extra Credit, there is no sample online to help you with this one. If you’re not sure how to complete it, just skip it.

Step 22__________

(workbook)