Fichas
Topic 10
Fichas del conjunto (11)
- 1what do functions start with?an = sign
- 2what can a function do?SUM, COUNT, AVERAGE, MIN, MAX, IF
- 3What are some examples of formatting?font style, size, colour, border style, alignment etc.
- 4what graphs and carts can you use on a spread sheet?bar charts
pie charts
line graphs - 5what is cell referencing?when a formula is copied by filling down the cell references in cells are adjusted as you drag the pointer down the page.
- 6what is relative cell references?if a formula is copied by filling down, the cell references are adjusted as you drag the replication down the page.
- 7what are absolute cell references?some parts of the formula that you do now want to change you can put a $ in front of it so it acts as glue.
- 8what are the benefits of using a spread sheet?automatic calculation
accurate calculations
graphs/charts
replication - 9What are 'What if' calculations?changing the data in a spread sheet model allows you to make and test predictions. these are known as what if calculations. they allow you to use a spread sheet to see what would happen if certain figures changed in a spread sheet.
- 10what are relative cell references?is when a cell is used in a formula and the formula is copied to a new cell reference, the cell references changes to take account of the formula new position
- 11what are relative cell references?is when a cell is used in a formula and the formula is copied to a new cell reference, the cell references changes to take account of the formula new position
Información
- Descripción
- Fichas sobre Topic 10, creado por Abby Debell el 10/03/2015.
- Creado por
- Abby Debell
- Visitas
- 1
- Valoración