Fichas
spreadsheets
Fichas del conjunto (12)
- 1simple formula signsadd(+)
subtract(-)
multiply(*)
divide(/) - 2cell referencesa cell references is the the thing that is in the cell
you find this by there will be words on the top and numbers down the side - 3a function formula for sum=sum(b3:b6)
- 4a cell function formula for average=average(b3:b6)
- 5definition of columnvertical line down the spreadsheet-uses letters as its references
- 6definition for rowhorizontal line across the spreadsheet-uses numbers as its references
- 7definition of formulaa calculation set up in the spreadsheet
- 8Pie chartWhen you want to show data proportionally, e.g., male versus female
- 9Bar chartComparing values of different items e.g. profit on a company per year
- 10Radar chartComparing data with other similar dater e.g. track the cost of something other time
- 11Scatter graphComparing one set of data to another e.g if you had a ice cream shop you could compare when you sold your ice cream the most
- 12Line graphComparing data over time e.g. you could use it for how long it takes a ice cream to melt
Información
- Descripción
- Year 7 Computing Fichas sobre spreadsheets, creado por Austin Leach el 15/05/2018.
- Creado por
- Austin Leach
- Visitas
- 0
- Valoración