Ms Excel Assignments For Beginners

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

You know the functions and formulas but need to practive your Excel skills? Or do you need Excel Practice Tests online? Well you are at the right place. We have free excel practice tests where you can sharpen your skill. These are not multiple choice questions in fact you learn by doing.

 

Most of the tests you find are multiple choice Excel questions. But we do Excel training and practice using Excel Online.

 

Here are a few Excel Practice Tests for Free:

 

More Excel Practice Worksheets:

 

See all of Courses and Tests, please visit our Learn Excel By Doing Courses.

 

 

Related Tutorials

Free Online Training For Excel

Excel is a life saver at work and there is always a free online training for Excel in the internet. At Sheetzoom, we offer free excel...

A 10 Min Tutorial On How Goal Seek Works

Businesses are all about decision making. If you are working for a firm, whether it is producing goods or providing services, you must have come across situation where...

Leave a Comment

(0 Comments)

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