Spreadsheet Exercises --(not completed Edited (made additions to bottom 05/02/05)
These exercises are designed to help one learn and practice spreadsheet concepts using Microsoft Excel.  Some are sample spreadsheets that you download and modify, some are typical tasks one might have to perform using a spreadsheet.  You can follow different paths in using this material
(1) try these exercises and check out the tutorials if you have difficulties,
(2) check out the tutorials first then try perform these exercises

Temporary listing

CarLoan.xls

chkBkA.xls
chkBkExe.xls
chkBkQ.xls

CollegeLoan.xls
ComputerLoan.xls
ComputerLoanA.xls

CreditCard.xls
CreditCardA.xls

GPA.xls
gpaA.xls

gradesA.exe
gradesQ.exe

GST104aSSgradeA.xls
GST104aSSgradeQ.xls

GradeSheetMailMergeQ.doc

OfficeBudgetA.xls
OfficeBudgetExercise.doc
OfficeBudgetSample.xls

salesA.xls
salesQ.xls

SS_Gde4_Ex.xls

SS_k6Gdes.xls
SS_k6GdesDB.xls
SS_k6GdesWks.xls

SSgrade2ARevForm.xls
SSgrade2QRevForm.xls

SSgradeA.xls
SSgradeQ.xls

SSLectQuiz.xls

SStateGS104aPrePostQ.xls
SStatsGS104aPrePostA.xls

Statistical Analysis
DevianceStudyDescriptionQ.doc
DevianceStudyDescription.doc
DevianceData40.xls
DevianceDataALL.sav
DevianceDataALLSPSS.sav

Spreadsheet Exercise
StatChartExercise.xls  Simple example to test basics
Also Use Statistical Analysis and create charts to illustrate

Need to inmtegrate above into following format

Spreadsheet Exercise 1

(a) Budget: Basic spreadsheet composition (general version of basic spreadsheet formatting)

This exercise covers basic spreadsheet operations including labels, data, formulas and functions. You will create a six month record of your personal and household expenditures. Using this as a base you will create a column of monthly averages to make an informed guess about the next months expenditures.

Spreadsheet Exercise 2
(a)  Basic Spreadsheet Formatting (general version of basic spreadsheet formatting)
After completing the first exercise format your spreadsheet for readability with general formatting including, column width, font style and size, data format etc. To see a formatted spreadsheet similar to the assignment with attached notes on formatting download the following and view in a word processor: (b)  A checkbook balancing spreadsheet (general version of basic spreadsheet functions and formatting)
Using your spreadsheet skills developed in exercise one, develop a spreadsheet version of your checkbook balancing. To see a word version of how your spreadsheet should look (formulas won't show--thats your job!): (c) Personal worth statement (business version of basic spreadsheet functions)
For hints and an example of a personal worth statement click here*****.  This exercise covers spreadsheet skills learned above.  Your task is to create a personal worth statement.  For a look at sample click here: (d) College/Computer/Car loan Chart (ASAP)
CollegeLoan.xls
ComputerLoan.xls
ComputerLoanA.xls

(e) Construction Estimation (ASAP --a new fence/roof, etc.)

(f)  Car purchase decision Chart (ASAP)

(g)  Credit card payment (ASAP)
CreditCard.xls
CreditCardA.xls

Spreadsheet Exercise 3

(a) This exercise covers intermediate level spreadsheet tasks.  You will download the data from a class grade book and place the proper formulas in the spreadsheet-----.  Click here for instructions and downloads. (ASAP)

Spreadsheet Exercise 5
Micros (ASAP)


May be duplicated above:

##############FUTURE SPREADSHEET PROBLEMS IGNORE FOR NOW ################
(d) Not part of assignment but can demonstrate if time.  You have a credit card balance of $2500.00 and the interest rate is 11.9% with a minimum payment of  3% of your balance each month.  Assume you just pay the minimum payment, in 10 years how much will you have paid and how much will you still owe?

            CreditCard.xls  (labels and data no formulas)                    CreditCardA.xls  (working SS)  

     (e) NO SAMPLE SPREADSHEET--but there is data check Lets assume you just purchased a car with a cost of $10,000 and an interest rate of 6.5 API calculated monthly.  You are going to pay $250 a month.  Create a spreadsheet that will show your monthly payments interest paid, and balance until the car is paid.  Show on the spreadsheet how much the car really cost with interest.
    CarLoan.xls (Just an example from Kern schools--no data no formulas)

         (f) NO SAMPLE SPREADSHEET Create a spreadsheet that covers the 4 years of your college education cost.  include tuition.....textbooks (estimate $250 per quarter) and suppose that you don't have to start paying until 1 year after you graduate.  The interest rate is 6%.  Be sure and show what you owe after the 5 years.

        (g) NO SAMPLE SPREADSHEET Gas mileage Create a spreadsheet that shows how much it would cost for gas for a 4 week month  if you had to travel to Fresno M-F  for a job. Determine what it would cost if you had any of the following cars Hummer, Jeep Cherokee, Toyota Pris, Honda Civic, your current car. [Find this information on the web] Show the cost differences if the gas price is $1.50 a gallon, $1.75 a gallon, $2.00 a gallon, $2.50 a gallon or $2.75 a gallon.
             (NOT DONE)

        (h) NO SAMPLE SPREADSHEET You decide to put the $5 usually spent on a Lotto ticket each week in a savings account you have found that pays 6.5 % API (a really great rate but it's coming). How much would you have in 25 years? How much would you have spent for the Lotto tickets? [An interesting shortcut to use with some interest problems rule of 72]
    http://www.csubak.edu/~jross/classes/GS390/Exercises/Excel/CollegeLoan.xls

        (i) Grade Spreadsheet for class
              GST104aSSgradeQ.xls (labels and data no formulas)            GST104aSSgradeA.xls (working SS)

       (j) Sales and Salaries
              salesQ.xls   (labels and data no formulas)                               salesA.xls (working SS)

       (k) Grade Sheet/DB for k-6 class
              SS_k6GdesDB.xls   (labels and data no formulas)                  SS_k6GdesWks.xls  (working SS)

       (l)  College loan cost: Create a spreadsheet that covers the 4 years of your college education cost.  include tuition.....textbooks (estimate $250 per quarter) and suppose that you don't have to start paying until 1 year after you graduate.  The interest rate is 6%.  Be sure and show what you owe after the 5 years.
             CollegeLoan.xls  (NOT DONE)

NEED MORE BUSINESS EXAMPLES, QUESTIONNAIRE EXAMPLE (Deviance Survey),  GRAPHICS, etc.