Excel assignment

Step I.
The data in columns

1. Create some imaginary data in four columns:
2. First, enter a series last names into a column at left of your screen. Make it about 15 names long.
3. Next create a series of first names in the next column to the right.
4. Then, create a column of scores inthe next column. Let's pretend they are quiz scores with a maximum value of 25 points.
5. We are going to sort the data and check the scores with all sorts of awesome little measures.

You will be using batches of numbers to work with various Excel functions.

We will stick with fairly basic Excel functions, but please know that you can go completely wild with Excel. It can forever dominate your destiny - see Star Wars.

We are going to start out by entering and sorting data.

Begin by following the instructions in Step 1.

Part II.
Make a shopping list on the next spreadsheet in the workbook.

1. Create a five column group for data in Excel. The column titles will be Item Description, URL for Item, Quantity of Items, Price per Item, and Total for this Item.
2. Insert a function to calculate the price for each group of items in the cell under Total for this Item.
3. Repeat that function for 20 or thirty cells in the series of columns you are creating.
4. Create a total cost cell at the bottom of your column group. This needs to calculate the total spent for all the items in the column entitled Total for this Item, plus the Idaho State Sales Tax of 6%.
5. SAVE your workbook.
6. Go shopping! Log into at least three different shopping sites. Find about 20 or so items, but your goal is to spend between $1000 and $1010 dollars. Any items are OK as long as they are appropriate.
7. SAVE your workbook.

Directions:

Here are some handy tips for the data:

Keeping the data in similar groups that you can identify by appearance and location is handy.

Keeping your column and function descriptionsis also very handy.

I like to have my data sets close enough together that they can appear on one screen view.

You will create your own support file for the first two steps of this project.

Part III.
Creat an interest calculator.

1. Create a four column worksheet in Excel. Label the columns, annual contribution, year, interest rate, and total available.
2. Follow the in-class instructions for writing the formulae for the the cells.
3. SAVE this page as part of your workbook.