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