Name: Monday Evening Excel Chapter 2A Homework Assignment

Monday Evening Excel Chapter 2A Homework Assignment Due: March 6th ... Complete “Metropolitan Zoo Gift Shop Weekly Payroll” starting on page 193 follo...

6 downloads 561 Views 361KB Size
Name: ________________ Monday Evening Excel Chapter 2A Homework Assignment Due: March 6th Printing Instructions…READ: For all assignments, unless instructed otherwise, print the worksheet twice…once as values and once as formulas. The keystroke to toggle between values and formulas is Control + ` (don’t press the + key). All printouts should show gridlines and row/column headings (numbers and letters). Click on File/Print/Page Setup/Sheet/ and check “Row and Column Headings” and “Gridlines”. Each solution should fit on one page. For instance, you will have two printouts for your file (workbook). Formulas should appear on one page and the values should appear on one page. You may have to print “landscape” to do this.  

The above instructions will generally apply to all assignments unless otherwise instructed. For the following exercises, you may use range names if you wish. You will have to make-up appropriate range names. The book instructions don’t use range names but it’s OK for you to do so.

Part 1 Complete “Hamilton Heights Auto Sales” starting on page 190 following the instructions in your textbook. It is OK to use range names if you want to. To print your worksheet(s) use the Printing Instructions above (top of page).

Part 2 Complete “Lockridge Marketing Analysis” starting on page 191 following the instructions in your textbook. Print as directed in Printing Instructions above (top of page).

Part 3 Complete “Metropolitan Zoo Gift Shop Weekly Payroll” starting on page 193 following the instructions in your textbook. Do not print rows 27 through 34 Print as directed in Printing Instructions above (top of page).

Part 4 (Wait until next class meeting on March 6th to work on Part 4) Complete “Mortgage Calculator” starting on page 194 following the instructions in your textbook. Use Printing Instructions above (top of page).

Part 5 



When you have completed your assignment, put all printouts together in order by Part Number (values on top of formulas for each part number, lay this sheet on top, staple all pages together in the top left corner. A staple is a staple, not a rubber band, not a paper clip, not a fold and tear, and not sheet protectors. Turn in your assignment at the beginning of class on the due date listed at the top of this page.