Detailed guide to all the buttons on the toolbar

Details of the buttons on the toolbar

In what follows the array of cells in rows and columns that Microsoft refers to as a 'worksheet' is called a spreadsheet (this tallies with commmon with everyday usage and it avoids confusion with the written worksheets that students use). Similarly, all types of graph and bar chart are referred to here as graphs (rather than charts, as Microsoft do). (Note, however, that when you create new graphs, the tab at the bottom assigns the default names Chart1, Chart2, etc., if they are normal Excel graphs, but Graph1, Graph2, etc. if they are ImagineIT Super Graphs.)

Tables of data

Resize, create or delete a table

To create a new ImagineIT table,
either click on the top left hand cell in your table of data first, then click the toolbar button and enter the numbers of rows and columns when asked,
or select the whole of your table first and then click the toolbar button.

Up to two separate ImagineIT tables can be created but they must not overlap.

To change the size of an ImagineIT table,
either click on any cell in the table, then click the toolbar button and enter the number of rows and columns when asked,
or select all the cells along any edge of the table and then drag inwards or outwards using the mouse,
or insert or delete rows or columns in the table in the usual Excel way (this is useful if you want data plotted on graphs to continue to refer to all rows in a table).

To delete an ImagineIT table, click on any cell in the table, then click the toolbar button and choose 'Delete'.

Tables are colour-coded in yellow (unless you choose otherwise).