Google Answers Logo
View Question
 
Q: Microsoft Excel Exercises ( Answered 5 out of 5 stars,   1 Comment )
Question  
Subject: Microsoft Excel Exercises
Category: Reference, Education and News > Education
Asked by: mediatek01-ga
List Price: $10.00
Posted: 02 Apr 2004 08:40 PST
Expires: 02 May 2004 09:40 PDT
Question ID: 324061
I'm looking for quality exercises that will help students (seniors) learn 
Microsoft EXCEL.  The exercises will be given to students who have
little computer experience.  Ideally I would like the exercises to be
basic and thorough and take the students through a progression of
learning (from typing simple tables using basic formulas to more
complicated tables using advanced formulas).  I'm looking for a list
of about 10 - 20 exercises.

Thanks, 
mediatek
Answer  
Subject: Re: Microsoft Excel Exercises
Answered By: bobbie7-ga on 02 Apr 2004 09:56 PST
Rated:5 out of 5 stars
 
Hi Mediatek01!

Here are the results of my research regarding Microsoft Excel exercises.

====================================================================


Microsoft Excel Exercises by David J. Houston is a comprehensive
tutorial that provides the following exercises:


Exercises:

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.

Practice Exams and solutions

Here is the link to the tutorial.
http://web.utk.edu/~dhouston/excel/exercise.html


====================================================================


Hands On Exercises with Excel 97 
 
 
This section of In and Out of the Classroom with Microsoft Office 97
is designed to provide self-paced Hands-on Exercises that can be used
in staff development workshops or with students.
http://www.microsoft.com/education/default.asp?ID=Excel97HandsOn


====================================================================


Introductory Exercises In Microsoft Excel 97

This document contains a series of exercises which give an
introduction to the Excel spreadsheet program.

AUTHOR 
Information Systems Services
University of Leeds
http://www.leeds.ac.uk/iss/documentation/tut/tut78/tut78.html


====================================================================


Basic Spreadsheet Exercises

These are suited to people who have learned the basic features of
Excel and need to practice setting up a spreadsheet.
7 exercises
http://www.abacustraining.biz/Exercises/Excel/BasicSSConcepts.htm


====================================================================

Intermediate Spreadsheet Exercises

These are suited to people who have learned the basic and intermediate
features of Excel and need to practice constructing spreadsheets.
http://www.abacustraining.biz/Exercises/Excel/InterSSConcepts.htm

  
====================================================================

Introduction to Excel v.4
http://www.cof.orst.edu/net/software/spread/excel/intro4.sht


====================================================================


EXERCISES IN THE USE OF MICROSOFT EXCEL
http://www.le.ac.uk/eg/design/year1/excel.pdf


====================================================================


Microsoft Excel XP Beginners - Exercises
http://www.gre.ac.uk/it-courses/downloads/exercises/Excel_XP_Beginners_Exercises.pdf


====================================================================


Microsoft Excel XP Intermediate Level - Exercises
http://www.gre.ac.uk/it-courses/downloads/exercises/Excel_XP_Intermediate_Exercises.pdf


====================================================================

Fundamental Excel Lessons
Great step by step lessons for the beginner Excel user.
http://www.saskschools.ca/~ehs/HeiseIntra/excel.html


====================================================================


Learning Microsoft Excel 

?Learning Microsoft Excel is designed to introduce you to the basic
operation and functions of Microsoft Excel for Windows 5.0. The
lessons include practice exercises to work through as well as examples
for using spreadsheets in your work.?

Iowa State University Extension
http://www.exnet.iastate.edu/Pages/Excel/


====================================================================

A Spreadsheet Activity 
http://www.internet4classrooms.com/M%26M_spreadsheet.xls


====================================================================


Using Excel to analyze the results of a simple survey
http://www.internet4classrooms.com/excel_survey.htm


====================================================================


Excel tutorial from Microsoft

Explore the powerful features of Microsoft® Excel 97 to simplify data
research and organization by using worksheets and charts

Collect, analyze, and format data in an Excel 97 workbook 

Use powerful formulas and functions to calculate grades, create
budgets, and more, while using built-in tools to correct errors and
ensure accuracy

Create dynamic charts and graphs from worksheet data by using the
quick and easy graphing capabilities of Excel 97

Enhance presentations by inserting or linking charts and graphs to
Microsoft Word 97 documents
http://www.microsoft.com/education/default.asp?ID=Excel97Tutorial

Table of Contents
http://download.microsoft.com/download/3/b/d/3bd4ae43-73e6-47ff-8d75-5dcf70968ebd/TOC.doc



====================================================================


Search criteria:

Microsoft Excel Exercises
Excel Exercises
Excel tutorials
Microsoft Excel beginners Exercises


I hope you find these resources helpful!


Best regards,
Bobbie7
mediatek01-ga rated this answer:5 out of 5 stars and gave an additional tip of: $2.00
Hi bobbie,
Great stuff. 
Thanks,
mediatek01

Comments  
Subject: Re: Microsoft Excel Exercises
From: bobbie7-ga on 03 Apr 2004 06:16 PST
 
Thank you for the five stars and tip!
--Bobbie7

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy