Create a worksheet in Excel that does calculations for the IRS tax form 1040
Create a worksheet in Excel that does calculations for the IRS tax form 1040 (first page only) filled by Franklin Roosevelt in 1937 and finds the balance of tax: http://www.taxhistory.org/www/website.nsf/web/presidentialtaxreturns (Links to an external site.) – Use %8 tax rate for line #29 – Use 0 for line #23 and #31 and #32 – Create a pie chart that shows normal tax (line #28) and surtax tax (line #29) – Use the Excel section of the lecture video from chapter 3 to get started.