# data[].attributes.body
the dollar sign is inserted before the column or row reference that you do not want to change, for exanmple $A$2

# data[].attributes.body
1. Sum- Finds the total of a range of data
2. Max- Finds the maximum value in a rage of data
3. Count- Counts the number of items in a range of data
4. Min- Finds the minimum value in a range of data
5. Average- Finds the average in a range of data
6. If- Sets conditions for the data

Jordan Boyd

# data[].attributes.body
1. Producing a graph from a table of data
2. Importing or exporting data
3. Sorting data in a table
4. Saving contents of a worksheet
5. Printing a workbook

Emily Skillen

# data[].attributes.body
1. Accountants
2. Teachers
3. Engineers
4. Sales people
5. Scientists
6. Supermarkets
7. market researchers
Anyone can use a spreadsheet but these are the main people who use spreadhseets

# data[].attributes.body
one summary function used in spreadsheets is SUM. You can use this to add the numbers in cells together. For example if you wanted to add all the numbers in cells B1 to B175 use =SUM(B1:B175).
Jessica Robinson

# data[].attributes.body
+ A large number of tasks or actions can be recorded in a single macro
- can be used to spread computer viruses

Katie McEwan

# data[].attributes.body
Data validation is a tool that helps to ensure that data entered into a cell is valid. For example, you could make sure that no cells are left empty.
James Todd

# data[].attributes.body
A spreadsheet is a piece of software which is used to work out calculations and arrange data in a neat orderly way

Callum Glover

# data[].attributes.body
Spreadsheets offer a wide range of graphs such as bar charts, line graphs and pie charts which can provide information by summarising large amounts of numeric data
Lauren Hanna

# data[].attributes.body
Spreadsheets can contain multimedia:
Images, sounds and videos
These are used to keep the viewers attention and to prove points. They can also be used to show something that cannot be described by words as well as sounds can be used for background music.

Samuel Pickering

# data[].attributes.body
Anyone can use a spread sheet but the main jobs that use spreadsheets include
- Accountants
- Teachers
- Engineers
- Sales People
- Scientists
- Super Marketers
- Market Researchers

# data[].attributes.body
When you enter data into a cell, it is handled differently depending on what type of formatting you have assigned the cell. Examples:
Currency- £3.00
Date- 20/7/17
Percent- 30%

# data[].attributes.body
Conditional formatting is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of the formula.
Mattie Shanks.

# data[].attributes.body
A model allows you to try out different scenarios to see what would happen if you made a change without any of the risks of having to do them in real life.

# data[].attributes.body
A macro is a set of instructions that can be carried out using a single command. They are used as a way to automate a task or procedure which you perform on a regular basis.

Alan Matthews

# data[].attributes.body
Formulas are used to do every calculation. They can be as simple as adding two numbers or working out a statistical result from millions of pieces of data. All formulae start with a = sign.
David Camley