|
1-Using Functions:
Open the sample spreadsheet District School Library Funding and try the following functions:
(use column J for your calculations)
=COUNT(C5:E8)
|
12
|
counts the numbers
|
=MAX(C5:E8)
|
598
|
finds the maximum number
|
=MIN(C5:E8)
|
22
|
finds the minimum number
|
=MAX(C5:E8)*.10
|
59.8
|
Finds the MAX number in the range : cells (C5:E8)
then finds 10% of that Max (598) |
=MAX(C5:E8)-MIN(C5:E8)
|
576
|
Finds the MAX number in the range : cells (C5:E8)
Then subtracts the Min number in the range: cells (C5:E8)
|
| =AVERAGE(H3:H13) |
5,601 |
Finds the average value of the the range : cells (H3:H13) |
=IF(F4>20000,1,0)
|
0
|
Binary True-False statement
returns 1 if True that F4>20000
returns 0 if False that F4>20000
note: do NOT use , to indicate thousand 2000
|
2- Formatting Cells:
Download, save and open excelLab2.xls
- Open the worksheet budget
- Resize columns so that all information is visible
- Change color scheme of colored cells to yellow and orange
- Format Utilities column as currency
- Change font size, weight and color
- Use the Max function to find the most costly expense category
=Max(Cell:Cell)
3- Creating Charts and Graphs:
- Create a Pie Chart of the Annual Expenses;
Use ctrl+click to select the titles row (2) and the totals row (17)
|