Assignment3_Payroll Problem

Assignment3_Payroll Problem - ,October13th(10points ....

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Assignment 3 – due at the beginning of class on Wednesday, October 13 th  (10 points) Assume you work for a small company that is looking for a better way to track the time an hourly employee  works and the money each employee earns each day.  You are asked to develop a spreadsheet to help  accomplish this task.  Your worksheet should be professional in appearance, well organized, and  it must  be your own work .     In this assignment, you will be learning about the following spreadsheet concepts and functionality: - Relative and absolute cell addressing - Excel functions, including =Sum(); =IF(); =Average(); =Now() - How Excel uses time/date data in formulas Assignment Instructions; please follow the instructions as described below.   1.  Open a new Excel file and save the file with the assignment number and your last name.  For example,  my file would be saved as “a3easton.xls”  Note: I used lowercase letters as this file may be referenced in  our RSS feed.  Be sure to save this file so you can retrieve it.   2.  Create a “Header” (use Insert Text your Name;  your RedID;   the Assignment number;  Design FilePath) (Note: this is the Header to use for all Excel assignments in this class, unless otherwise specified).  If your  header covers some of your worksheet, you can adjust the “Top Margin” to expand the header area. 3.  Beneath the header, on the worksheet, enter a title that includes 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/16/2010 for the course IDS 180 taught by Professor Clague during the Fall '08 term at San Diego State.

Page1 / 3

Assignment3_Payroll Problem - ,October13th(10points ....

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online