A |
B |
C |
D |
E |
F |
REGION |
JANUARY |
FEBRUARY |
MARCH |
APRIL |
TOTAL |
DBN |
3.3 |
1.2 |
2.7 |
3.5 |
|
JHB |
3.4 |
5.6 |
2.2 |
2.1 |
|
CTN |
4.2 |
2.5 |
1.7 |
1.1 |
|
|
|
|
|
|
|
FORMAT ALL NUMBERS TO 2 DECIMAL PLACES.
CALCULATE THE AVERAGE FOR EACH CITY OVER THE FOUR MONTHS AND PLACE THE VALUE IN CELL F7 WITH A COMMENT INCATING AVERAGE.
FREEZE THE PANES AT C4
INSERT A PIE CHART TO REPRESENT THE DATA IN THE TABLE ABOVE. FORMAT THE GRAPGH TO IMPROVE ILLUSTRATIONS O F DATA. SAVE THE WORK AS PERFORMANCE 2014