Flashcards
ICT flash cards
Cards in this deck (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
Information
- Description
- Year 10 IT Flashcards on ICT flash cards, created by Courtney Perry on 12/10/2017.
- Created by
- Courtney Perry
- Views
- 0
- Rating