Apr. 7, 1997
Several of these exercises require pre-existing Excel documents. These documents may be found on your R: drive, in nearly the same location in which the previous exercise's documents were found --- the final folder on the ``trail of folders'' is named excel4. Don't forget to do a Save As after you've opened each document.
These questions may appear on a forthcoming quiz. They come from the Excel Essentials readings)
Social security and medicare accounted for 33% of the expenditures, and the defense budget another 24%. Social programs, including Medicare and Aid to Families with Dependent Children, totalled 17%. Community development (consisting of agricultural, educational, environmental, economic, and space programs) totalled 10% of the budget. Interest on the national debt amounted to 14%. The cost of law enforcement and government itself accounted for the final 2%.
Use the information contained within this exercise to create the
appropriate charts (with titles, legends, and notes) to reflect the
distribution of income and expenditures.
Do some independent research (Hint:
and obtain data on the budget, the deficit, and the national debt for the
years 1945, 1967, and 1980. The numbers may surprise you; for example, how
does the interest expense for 1992 compare to the total budget in 1967 (at
the height of the Vietnam War) or to the total budget in 1945 (at the end
of World War II)? Create charts to reflect your findings.