IPW - Maths Guide

1) Creating / Editing of graphs and charts in Excel

(a) A template has been provided in the Project Work folder:

(b) Highlight the data area, then go to Insert a Chart

(c) Select Pie, then click on Next

(d) Click on Next after checking if the chart reflects the numbers entered:

(e) Enter an appropriate title for the chart, before clicking on Finish:

(f) To change the chart / graph type, select the graph, right-click and select Chart Type… It will bring the students back to (c), at which students can select a different chart / graph type.


2) Sum function in Excel

(a) Select the numbers that are to be totaled, then click on the Sum symbol at the top of the screen (Σ):

b) Alternatively, you can type in the Sum function: =SUM (D3:D7) and press Enter.