Task execution.
Use a formula to calculate the temperature for Nakuru, given that the
temperature for Nakuru is ¾ that of Mombasa.
Create two blank rows below Row 1.
Type “Temp. in degrees Celsius” in Cell A2 and “Temp.
in degrees
Fahrenheit” in Cell A9.
Calculate the temperature in F using the conversion factor given as
F=(C+19)*9/5.
Insert a blank row before Nakuru and enter the row heading Kericho in both
temperature versions.
Calculate the temperature for Kericho in both versions given that it is 4/5 that
of Kisumu.
Type “Average Temp. (C)” in Cell G3 and “Average Temp. (F)” in Cell G11
respectively. Calculate the average temperatures for all the towns.
Format all cells containing the temp. values to
zero decimal places with no
commas.
Format all cells containing Average Temp. to Arial Black, Italics, size 12.
Centre the Titles across columns A and G.
Put a double border round the whole table and a single
line border inside the
table. Shade the column for Average temperature gray.
Use the Average values (C) in column G to create a 3-D Exploded Pie Chart to
show distribution of temperature for the towns.
The title should be “Average Temp. (C)”. Use
the text in column A as the
legend.
In the data labels, select Show Value.
Move the chart created above to Sheet3. Do not insert it as an object.
Move the left top corner of the chart in Sheet3 to cell A7. Resize the chart to
fit into the range A7:h20.