Lab 7: Calculating 1040 EZ
The handouts for lab 7 were distributed in class. They include - 1040EZ, the dependent worksheet on the back, and a portion of the tax table including the$8,000-$8,999 tax bracket
In this lab we will create a sheet to compute the 1040EZ calculations for student Josef Q Learner. You will need to have 3 separate areas on the sheet: a) the 1040 EZ form, b) the dependent worksheet, and c) a lookup table for the $8000's section of the tax table.
For the 1040 and worksheet use two or three columns for the numbering and descriptions and another for the calculations. You should make the first few columns look as much like the 1040 as you (easily) can without using any special formatting
Above line 1 - The items above line 1 at the top of the form should be made up names, addresses and SS numbers etc.
The lines on the 1040 and worksheet fall into three groups, i. Data, ii. Formulas, and iii. Ignored (enter 0.00)
Data entry lines are cells in which the user enters values. Make the background color of these cells a light yellow(or other light color of your choice) color to indicate that a number needs to be entered by the user. Data entry lines include - 1040: lines 1, 2, and 7.
The lines we will ignore (and enter zeroes if appropriate) are 1040 lines 3, 8, 11b and 11c and worksheet line F.
Most other lines will contain formulae so that they change automatically when the data changes. You may want to use IF, VLOOKUP, MAX, and MIN as well as standard arithmetic plus and minus.
To test your sheet: