Homework #4: MISB-500-01 Fall 2000
You are starting a small business called "Spread the Light" at a flea market. You have decided to sell candles. You have bought various amounts of a variety of candles (see below), but you haven't paid attention to the overall totals. Create a Microsoft Excel spreadsheet that looks like this:
|
A
|
B
|
C
|
D
|
E
|
F
|
|
|
1
|
Spread the Light
|
|||||
|
2
|
Inventory
|
|||||
|
3
|
||||||
|
4
|
Item | Cost | Quantity | Invested | Selling Price | % Markup |
|
5
|
Candles, boxed | 4.15 | 120 | 6.95 | ||
|
6
|
Incense, cones | 0.04 | 300 | 0.06 | ||
|
7
|
Incense, sticks | 0.03 | 750 | 0.05 | ||
|
8
|
Incense, bottled | 0.99 | 100 | 1.25 | ||
|
9
|
Tapers, thin | 0.29 | 850 | 0.42 | ||
|
10
|
Tapers, wide | 0.49 | 400 | 0.95 | ||
|
11
|
Votive | 0.09 | 500 | 0.20 | ||
|
12
|
||||||
|
13
|
Average percentage markup: | |||||
|
14
|
||||||
- In cell D5, use a function to show the amount invested in boxed candles.
- Copy the formula down column D.
- In cell F5, write a formula to calculate the percentage markup on boxed candles. Don't forget to format the result as a percent.
- Copy the formula down column F.
- Use a function to show the average markup on all the products.
- Forumat rows 1 through 4 to resemble those in the table above.
- Format the numbers appropriately (if dollar amounts, format them in dollars, i.e. $ 4.05).
- Save the file as your last name.xls (EX: Smith.xls)
- Print out the worksheet to fit on one page, landscape orientation.
- Print the formulas with the row and column headings.
Use the Microsoft Excel section of your Quick Easy Microsoft Office 2000 book for tips on how to do each of these tasks.
Send an email to booka@slu.edu with the Excel file attached by October 10th at classtime. Turn in printouts of the worksheet at classtime on October 10th.
Grading criteria:
| File completed |
20
|
| Printouts turned in |
10
|
| Formulas correct |
10
|
| Formatting correct |
10
|
| TOTAL POINTS POSSIBLE: |
50
|