1 / 5

INF1060: SPREADSHEET1

INF1060: SPREADSHEET1. Assignment #2 The Fill Down Command. In this activity you will prepare a spreadsheet that calculates the net pay for each of the five employees of Crestwood Laundry for the week ending September 19, 2000.

bran
Download Presentation

INF1060: SPREADSHEET1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. INF1060: SPREADSHEET1

  2. Assignment #2The Fill Down Command • In this activity you will prepare a spreadsheet that calculates the net pay for each of the five employees of Crestwood Laundry for the week ending September 19, 2000. • Also, totalthe columns for Gross Pay, Income Tax, EI, Medical and Net Pay. INF1060 Spreadsheet I

  3. Assignment #2 (Cont’d) • Create a spreadsheet using the above information. Include titles, labels, values and formulas (don’t forget the planning sheet). • Save the spreadsheet as “1060 SS Assgn 2”. Submit the completed spreadsheet to Moodle. ? INF1060 Spreadsheet I

  4. Assignment #2b (Cont’d) • Now you will see the real power of the spreadsheet… FORECASTING! • Forecasts predict the future based on past results. • You will change several values in the spreadsheet and the computer will automatically update the spreadsheet for you. Answer the following questions on the print out of your spreadsheet. • Change the following amounts for Adams: • Gross Pay: $730 • Income Tax: $162.70 • EI: $51.83 • A). What is the new net pay for Adams? INF1060 Spreadsheet I

  5. Assignment #2b (Cont’d) • Change the following amounts for Bruckner: • Gross Pay: $440.86 • Income Tax: $58 • EI: $33 • B). What is the new net pay for Bruckner? • C). What are the new totals for Gross Pay, Income Tax and Net Pay? ***BONUS (1)*** What percentage of the gross pay is taken off as EI? Briefly explain how you arrived at your answer. INF1060 Spreadsheet I

More Related