## Microsoft Excel Exercises

### David J. Houston

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.

### Exercises:

1. Grade Sheet Exercise: Illustrates how to create a basic spreadsheet by entering text, numbers, and formulas.
2. Checkbook Exercise: Introduces formatting of cells and columns.
3. Mortgage Exercise: See how functions can be used to create a spreadsheet to perform "what if?" calculations.
4. Using ChartWizard: Demonstrates the ease of creating charts.
5. Sorting Exercise: Learn how to sort data and print portions of a worksheet.
6. 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.
7. Cost-Benefit Analysis Exercise: Demonstrates a basic cost-benefit analysis using Excel.
8. Linking Exercise: Learn how to consolidate several worksheets into one and to link several worksheets to a master worksheet.
9. Regression Exercise: Illustrates the use of analysis tools for conducting bivariate regression and forecasting.
10. Statistical Analysis Exercise: Use a worksheet to calculate descriptive statistics (e.g., mean, standard deviation, skewness, kurtosis, frequency distribution, correlation).
11. Bivariate Regression Exercise: Estimate a bivariate regression equation and related summary statistics.

### Practice Exams:

David J. Houston
E-mail: dhouston@utk.edu

Revised -- September 14, 1999
URL: http://web.utk.edu/~dhouston/excel/exercise.html