Excel IV

CS 14A

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)

  1. What are: legends, notes, data labels, and data series?

  2. Be familiar with the definitions of the chart types given in Table 6.1 on pg. 119.

  3. How do you create a chart on its own sheet? (Hint: look under the Insert menu.)


  1. On Your Own, pg. 131, Excel Essentials. The file name to use is master3.xls. Don't bother printing any copies of the spreadsheet.

  2. Deficit reduction or not, the Federal government spends billions more than it takes in; for example, in fiscal year 1992, government expenditures totaled $1,380 billion versus income of only $1,090, leaving a deficit of $290 billion. Thirty percent of the income came from social security and Medicare taxes, 35% from personal income taxes, 7% from corporate income taxes, and 7% from excise, estate, and other miscellaneous taxes. The remaining 21% was borrowed.

    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:
    http://www.financenet.gov/homea/gopher/data/docs/central/omb/budget.gop .) 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.

Thomas P. Kelliher
Sat Apr 5 12:31:58 EST 1997
Tom Kelliher