SPREADSHEETS: Graphical Aspects of Spreadsheets

GRAPHICAL ASPECTS OF SPREADSHEETS

1. Creation of simple spreadsheets to explore numeracy
Layout
Selecting Cells
Selecting Columns & Rows
Entering Data
Basic Formatting
Entering Formulas
Autosum
2. Graphical aspects of spreadsheets
Introduction to Graphs
Creating a Graph
Pasting a Graph into a Word document
Pasting a Table into a Word document
Task
3. Functions
Inserting Functions
4. Exploring Mathematical Ideas
Visual Representation
Scatter diagrams
Clock faces & fancy fonts
Formatting Numbers
Number Patterns
Number Grids

Pasting a Table into a Word document

Word is open already.

1. To select the table, click and drag on the entire table.

Copy the table by accessing the EDIT menu and clicking on COPY or pressing Ctrl C

2. Go to WORD. Before pasting the table type a sentence explaining what the table is……..

The original information is presented below in table format.

3. Place your cursor where you want to paste the table.

Then go to EDIT and then PASTE SPECIAL

Select PASTE As Microsoft Excel Worksheet Object

Next: Task