These exercises are designed to help one learn and practice spreadsheet concepts using

(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

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.

Macintosh |
Windows |

SSEx1e.doc (Mac) | budgetA.xls budgetExe.xls BudgetA.exe(Windows) budgetQ.xls |

(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:

Macintosh |
Windows 95 or 98 |

SSEx2a.doc (Mac) |

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!):

Macintosh |
Windows 95 or 98 |

SSEx2b.doc (Mac--ASAP) | SSEx2b.doc
(Windows--ASAP) chkBkA.xls chkBkExe.xls chkBkQ.xls |

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:

Macintosh |
Windows 95 or 98 |

SSEx2c.doc (Mac--ASAP) | SSEx2c.doc (Windows--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

__Spreadsheet Exercise 5__

Micros (ASAP)

May be duplicated above:

(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

(e) **NO SAMPLE
SPREADSHEET--but there
is data check **Lets assume you just purchased a__ car with a cost
of
$10,00__0 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. i*nclude 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 Shee__t/DB for k-6
class

SS_k6GdesDB.xls
**(labels and data no
formulas)
** SS_k6GdesWks.xls** ** **(working
SS)**

** **
(l) __College
loan cos__t: Create a spreadsheet that covers the 4 years of
your
college education cost. i*nclude 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)**