Karteikarten
MLF-Spreadsheets (10)
Karten in diesem Stapel (11)
- 1spreadsheetapplication such as excel can store all its date in a single file. this file is called a workbook
- 2workbook and worksheetsa workbook is made up of one or more worksheets. a worksheet is a single tab in the spreadsheet workbook
- 3cellsa cell reference always starts with a letter and ends with a number
a range of cells is a set of cells in a row or column
data entered in a cell can be of different typed e.g. text, number, currency, date, percentage - 4formulasstarts with =
perform calculations on cell contents
appear in formula bar
results are automatically recalculated each time when data changes - 5functionsstarts with =
specialised calculations built in to the software
function names describe what the function can do (SUM, COUNT, MIN, MAX, IF, AVERAGE) - 6Formattingfont style, size, colour, border style, alignment, cell colour.
multiple cells can be merged into one
they are often formatted to reflect the data that is held in them - 7replicating cellsif there is a formula in the cell, the spreadsheet tries to adjust it as it goes down the page to fit in with the new position and the cells being referred to.
- 8graphs and chartsallows you to notice patterns and trends more easily
specific data can be selected on a spreadsheet and a chart/graph can be made - 9relative cell referencingwhen 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 formulas new position
- 10absolute cell referencingwhen a reference to a cell used in a formula where, when the formula is copied to a new cell reference the cell reference does not change. it is glued in place by the $ character
- 11what If calculationsthey allow you to use a spreadsheet to see what would happen if certain figures changed in a spread sheet. Allows you to make predictions
Informationen
- Beschreibung
- year 10 ICT Karteikarten am MLF-Spreadsheets (10), erstellt von Alyina Alam am 08/03/2015.
- Erstellt von
- Alyina Alam · Mär 2015
- Aktualisiert
- 19 Feb 2016
- Aufrufe
- 0
- Bewertung