Worksheet in Excel

Description

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