Name: Excel Chapter 2 Homework Assignment Due: September 21st

Excel Chapter 2 Homework Assignment Due: September 21st ... Complete “Metropolitan Zoo Gift Shop Weekly Payroll” starting on page 193 following the...

7 downloads 652 Views 237KB Size
Name: ________________ Wednesday Evening Excel Chapter 2 Homework Assignment Due: September 21st 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. These instructions will generally apply to all assignments unless otherwise instructed.

Part 1 Complete “Hamilton Heights Auto Sales” starting on page 190 following the instructions in your textbook. 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. Print as directed in Printing Instructions above (top of page).

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.