Wentworth Institute of Technology
Division of Professional and Continuing Studies
COMP112 Section 71 – Introduction to Computers and Programming – Spring, 2009
Homework 5 – Excel Assignment 1
Instructor: Bob Goldstein (617) 912-2512
http://home.comcast.net/~goldsteinr/Courses/index.html
http://goldstein.eri.harvard.edu/courses/index.html
http://myweb.wit.edu/goldsteinr/Courses/index.html
Due Date: March 23, 2009
Hand In: Excel document as specified (via email)
Purpose:
This homework is intended to establish basic familiarity with Excel
Description:
YOU MUST SUBMIT THIS HOMEWORK AS AN EMAIL ATTACHMENT (ie – that is part of the
homework). Make sure you send it to the above email address, and NOT the WIT email address.
1. Download the Payroll.xls file from the course website. Do the hands-on exercise that is described
on the following pages taken from “Grauer and Barber, Exploring Brief Office XP, Prentice
Hall,2002”
2. ALSO – Add two additional employees. Make one of them your full name and the other should
have a names and data of your choosing.
Extra Credit
1. Move the “Assumptions” section to a separate worksheet, and use NAMES in the formulas.
/app/work/qkd3s3-385982-2765004-homework5-doc.doc 1 11/29/2020 11/29/2020