SPREADSHEET SPLENDOR

Create the following spreadsheet. We will be filling in the blanks by using formulas. Follow the steps below or try to do it on your own and make it look like this sample:

1. File - Page Setup - Change the orientation to LANDSCAPE and under “other options” tell it to PRINT GRIDLINES.

2. In Cell C1 type the title in BOLD 14pt.

3. In Cell D2 type “Inventory 2000” in Italics.

4. Select Row 4 by clicking on the gray 4 on the side. Format- Shading and choose a solid light gray shading for that row.

Also, turn on the center alignment button for this row.

5. Type in the headings with the CAPS LOCK on.

6. Adjust your columns by dragging the area between the letters in the gray to make the spreadsheet as wide as your screen.

7. Type in the rest of the data in the corresponding cells.

8. Row 14 is in BOLD and cell F14 should have shading behind it.

NOW you’re ready for the FORMULAS!

(Review)

All formulas begin with an =.

Use the corresponding cell names with the COLUMN first, then the ROW #.

Use the following signs for operations:

add +

subtract -

multiply *

divide /

Finally use the calculator button if you don’t want to type in the formula by hand, but still check to make sure the cell names are correct.

1. SALE PRICE is going to be 20% off.

This means that we want the customer to pay 80% of the regular cost.

Therefore our formula should be

=C5*.8

for the first sale price.

***Make sure you learn the trick for copying this formula for the rest of the cells!

2. TOTAL SALE will be the sale price times how many on-hand.

Therefore our formula should be

=B5*D5

for our first total sale.

***Copy this formula to the rest of the cells!

3. AVERAGE will be the average of the entries in column B, column C, and column D.

=AVG(B5:B10)

for column B

****Copy this formula for columns C and D.

4. Total inventory will consist of a total for Column B and Column E.

=SUM(B5:B10)

*Make sure you don’t include the “Average” cell in your total!

Do another SUM formula for cell F14 where we put the shading.

ALSO ---

Highlight all the cells that you want to be formatted as dollars and cents and turn on the $ button in the tool bar. This will automatically make them read as $ rounded to the nearest cent.

NOW, Check your spreadsheet with my answer key--- how did you do?

NICE WORK!

Save and print your spreadsheet.

CHALLENGE:

One last thing. Highlight the spreadsheet and copy it.

Now open up a blank word processing document and turn the page orientation to landscape. Then PASTE the spreadsheet. You can type around it, including your name or any other information.

Try pasting into your email sometime!