Excel 2010 Homework Assignments

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

resource_detail_not

Microsoft Excel

To access Microsoft Excel's Online Learning Resources, click on the link next to your book title below. For downloading Student Exercise Files, please follow these instructions.

Instructions for PC Users:

  1. Click the link under the Exercise Files column for your book.
  2. Follow the appropriate step for your web browser:
    • Internet Explorer: Click Run to open (or Save to save) the files to your computer. If necessary, click Actions, More Options, Run Anyway to confirm your choice.
    • Mozilla Firefox: Click Save File; double-click the filename in the Downloads dialog box.
    • Google Chrome: Click the filename that appears in the download bar; click Run in the dialog box.
    Depending on your web browser and its version, your process may differ. If you need help, ask your instructor.
  3. Click OK in the next dialog box to begin the extraction process.
  4. In the next dialog box, choose the location for your files and then click Unzip.
  5. Click OK and/or Close to exit the open dialog boxes.

Are you a Mac user? Click here for download information.


  BookWeb
Resources
Exercise
Files
Additional
Materials

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *