User Rating: 5 / 5     ### Syllabus

Features of spread sheet applications for personal use;              11 GEN

• simple formulas; multiplication, subtraction, addition, subtraction
• functions; sum, average, max, min
• formatting and graphs

### Simple formulas

• use the symbols; + for plus, - for minus, / for divide, * for multiplication
• use grid-like references called cell references
• eg =A1 + A2   this will give the sum of the number in cell A1 and the number in A2.

### Functions

• a function is an automatic formula
• it automatically does what its name suggests
• eg =SUM(A1:A2)   this function will add A1 and A2
• eg =SUM(A1:A2000)  this function will add all numbers A1 through A2000
• another function is =AVERAGE(A1:A2000) this will give the average of all the numbers
• another function is =MAX(A1:2000) this will give the maximum number from all these numbers
• another function is =MIN(A1:2000) this will give the minimum number from all these numbers

### Formatting and Graphs

• Formatting can be done on labels.
• You can format in the following ways
• bold
• italic
• alignment left, centre, right
• font colour, size and more

### Graphs

• a graph is used to show a visual representation of numbers.
• to make a graph
• highlight the numbers to use
• choose insert > graph

### For You To Do

1. Start making spreadsheets and experimenting with formatting and graphs. Your teacher will provide you with more details.
`Found an error or enhancement? Please fill out this contact us form.`