Flashcards
ICT flash cards
Flashcards do conjunto (4)
- 1Spread sheet softwareThe benefits of using spreadsheets:
+ Can perform 'what if' investigations
+ Automatic recalculation
+ Accurate calculation
+ Easy to produce graphs and chats - 2Components of spreadsheets: + Label- are used for titles,headings,names and for identifying rows or columns of data. +Data- Are the values (test or numbers) that enter into spreadsheets. Meaningless. + Formula - are used to perform calculations in a cell.Functions:
+ Specialised calculations that the spreadsheet has memorised
+ Average- To find the average of the numbers in a range of cells from A3 to A10, =average(A3-A10)
+ Sum- =sum(E3:P3) displays the total of a cell from E3-P3 - 3Cell referencing + Relative cell reference- the cells will move if copied. + Absolute cell reference- Locks or holds the position of a cell.Formatting data
+ Data
+Integer
+ Percentage
+ Currency
+ Text - 4Formatting your spreadsheet + Alignment- left/centre or right. IF: +IF statements allow information to be changed depending IF something is true or false
Informações
- Descrição
- Year 10 IT FlashCards sobre ICT flash cards, criado por Courtney Perry em 12-10-2017.
- Criado por
- Courtney Perry
- Visualizações
- 0
- Avaliação