Flashcards
Topic 10
Cards in this deck (26)
- 1WorkbookMade up of one or more worksheets
- 2Worksheetsingle tab in the spreadsheet workbook
- 3cell referenceStarts with a letter and ends with a number
- 4Range cellsSet of cells in a row or column
- 5Range of cells isEither in rows or colunms
- 6Data can be entered into different data typestext, number, currency, date, percentage etc
- 7labelsany text in a cell describing the data in a row or column(titles, headings that identify data)
- 8Dataany values (text or numbers) that are entered for the use of calculation
- 9 Formulas and functionsmathematical calculations carried out automatically
- 10Formula must start with=
- 11 The 4 main mathematical operations+ Add
- Subtract
* Multiply
/ Divide - 12Function name describes what a function canSUM, COUNT, AVERAGE, MIN, MAX, IF
- 13Cells are often formatted to reflect the data that is held in them. Data types includeCurrency, number, real, integer (whole number), date, text
- 14Replicating cellsWhen you position the mouse pointer in the bottom right hand corner of the cell and drag down or across the spreadsheet tries to respond intelligently. If 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.
- 15Using charts/graphs allows us tonotice patterns & trends more easily
- 16 Bar chartsto compare values
- 17 Pie chartsto show how a total is divided among a number of different categories.
- 18 Line graphdisplay trends
- 19Relative cell references:If a formula is copied by filling down, the cell references are adjusted as you drag the replication pointer down the page. This is because it uses the relative address of the cells based on their position in the worksheet.
- 20Absolute cell references:Some we need to use part of a formula that does not change. All the other cell ranges will change. When the formula is copied down, the relative address changes but the absolute doesn’t.
- 21‘What if?’ calculationsChanging the data in a spreadsheet model allows you to make and test predictions.They allow you to use a spreadsheet to see what would happen if certain figures changed in a spreadsheet.
- 22benefit of Automatic recalculationEvery time the content of a cell is changed, calculations are performed and other cells are updated if necessary.
- 23benefit of Accurate calculations Providing the formulas have been set up correctly, the formulas will always produce a correct calculation
- 24Benefit of Graphs/Charts Can be drawn using data in selected cells.
- 25Benefit of ReplicationOnce the first formula is correctly entered, it is possible to drag across to adjacent cells in a row or column so the computer copies the pattern of the calculation.
- 26Benefit of What if calculationsFormulas can be reused and stored
Calculations involving large numbers are possible
Information
- Description
- Flashcards on Topic 10, created by leef033 on 11/02/2015.
- Created by
- leef033
- Views
- 1
- Rating