Example of Microsoft Excel
| Office Supplies | ||||||||
| (Enter time / date stamp here) | ||||||||
| Name | Note Pad | Pens | Paper | Total by function | Total by adding | Average by function | Average by dividing | Percent |
| Darlene Smith | $156 | $64 | $72 | |||||
| Kedzie White | $275 | $96 | ||||||
| Glenda Latham | $210 | $177 | $44 | |||||
| Tony Jones | $176 | $54 | $76 | |||||
| Total | ||||||||
| Average | ||||||||
| Maximum | ||||||||
| Minimum | ||||||||
1. To see two different ways of calculation on "Total".
(a) Using additions
(b) Using function sum()
2. To see two different ways of calculation on "Average".
(a) Using sum / number
(b) Using function average()
(c) Watching a missing value cell.
3. Percent = each one / grand total
How to fix a cell when you drag down a formula. (Absolute
Address Concept)
To get an absolute address, you hit the
F4 function key from your keyboard after you have a relative
address.
4. Copy the content from the first sheet to the second sheet and the third sheet. Rename sheet 1 as original, sheet 2 as what-if -data, and sheet 3 as what-if-result
5. Enter $20 for paper of Kedzie White on sheet 2 (what -if-data). Are two ways to get average getting the same results? What is the new percent for him?
6. Use Go-Seek Tool to do what-if analysis on sheet 3 (what -if-result) : If Kedzie is getting 28% of the office supplies by changing his paper cost, how much can he get from paper?
7. Copy the original sheet to sheet 4 and rename it as formula. Show formula on the sheet.
8. Copy the original sheet to sheet 4, 5, 6 and rename it as
Sort by Name; Sort by Percent;
Sort by pens.
(a) How to highlight, where to start, cover how many columns,
how many rows.
(b) A short cut vs. a pull-down menu.
9. Make a bar chart like as below.
10. Make a pie chart as below.
To see the line graph, click here.