Using a Spreadsheet Assignment
In this assignment you will create a Salary Translation Spreadsheet. This spreadsheet will allow you to compare hourly rates to monthly and Annual Salary rates. To complete this assignment use the instructions below:
	In cells A2 - G2 place the words Increase, Minute, Hour, Day, Week, Month, Year Respectively (Example : Cell E2 should have the word - Week) Select Columns A-G and format them for money Place this Word in cell A3 Current Place this formula in cell B3 =C3/60 Place this formula in cell D3 =C3*8 Place this formula in cell E3 =D3*5 Place this formula in cell G3 =D3*365/7*5 Place this formula in cell F3 =G3/12 Select cells B3-G3 and do a fill down to row 4 Place this formula in cell A4 =0.5 Place this formula in cell C4 =IF(ISBLANK($C$3),0,C3+A4) Select cells A4-G4 and do a fill down to row 100 Enter your Hourly Rate in cell C3
Submit your .xlsx worksheet file as an attachment in an email Use "Spreadsheet Assignment 1 - Excel" for the Subject line and remember to identify yourself by name and class in the email body. NOTE: You can use Excel 2007 for this assignment.
Return to Assignments Index