IUS Doughnut Shop Worksheet.
1. Start Microsoft Excel.
2. Documents are untitled and unsaved at first.
3. Save the blank
document. This involves giving the
document a name and placing it where it can be found. SAVE under the name IUS Doughnut Shop
4. Enter the following TEXT
in each cell.
LABELS CELLS LABELS CELLS
Monday B1 Glazed A2
Tuesday C1 Chocolate A3
Wednesday D1 Apple Fritter A4
Thursday E1 Cinnamon A5
Friday F1 TOTALS A6
Saturday G1 Week's Totals H8
Sunday H1
Totals I1
5. Make columns larger. Place mouse pointer between the letter of the columns. Hold down mouse button and move to right to make larger and left to make smaller.
6. SAVE by hitting the little disk on toolbar.
7. Enter the
following values into cells B2 through H5.
A B C D E F G H
8. Select all cell
9. What difference do you notice
* Now input FORMULA.
* To put total at the end of the column be in cell B6 next to the TEXT totals.
* Hit =b2+b3+b4+ b5
* Press enter. Sum should appear.
10. Now put totals in cells C6 through H6.
* In cell C6. This time use Autosum key and press enter.
11. Save and Exit program.
18. Start program and OPEN file called donut.
19. Graph - Click on A2 and select A2 through B7.
* Click on tool Graph
* Click on OK
* Click on Pie Graph Icon on toolbar
* Click on the pie graph with %
* Click Format color
* Click on Format 3D
20. Save and exit.
Try these Tricks
Using
the format command
1. format cells
boarders
2. Right-justify the TEXT in cells A2 through A6
3. Center TEXT in rows B1 through I1
4. Format cell to change TEXT to another font
and size.
5. Format Totals B6 through H6.
Check
totals:
A B C D E F G H
