Adobe Acrobat Reader: Adobe Acrobat Reader is needed for viewing PDF files. If it is not installed on your computer, you can download a free copy from this site. Click on the link to "Free Adobe Acrobat Reader" at the top of the page.

- Grade Sheet Exercise: Illustrates how to create a basic spreadsheet by entering text, numbers, and formulas.
- Checkbook Exercise: Introduces formatting of cells and columns.
- Mortgage Exercise: See how functions can be used to create a spreadsheet to perform "what if?" calculations.
- Using ChartWizard: Demonstrates the ease of creating charts.
- Sorting Exercise: Learn how to sort data and print portions of a worksheet.
- Special Formats and Exporting Exercise: Illustrates how to dress up a table using special formats and how to export a table or chart into a Microsoft Word document.
- Cost-Benefit Analysis Exercise: Demonstrates a basic cost-benefit analysis using Excel.
- Linking Exercise: Learn how to consolidate several worksheets into one and to link several worksheets to a master worksheet.
- Regression Exercise: Illustrates the use of analysis tools for conducting bivariate regression and forecasting.
- Statistical Analysis Exercise: Use a worksheet to calculate descriptive statistics (e.g., mean, standard deviation, skewness, kurtosis, frequency distribution, correlation).
- Bivariate Regression Exercise: Estimate a bivariate regression equation and related summary statistics.

- Exam #1 and Solution
- Exam #2 and Solution
- Exam #3 and Solution
- Exam #4 and Solution
- Exam #5 and Solution

David J. Houston

E-mail: dhouston@utk.edu

Revised -- September 14, 1999

URL: http://web.utk.edu/~dhouston/excel/exercise.html