Flashcards
I.C.T Topic 10 revision
Cards in this deck (25)
- 1What is a workbook?A spreadsheet application such as Excel can store all its data in a single file (with an .xls extension). This file is called a 'workbook'.
- 2What is a worksheet?A worksheet is a single tab in the spreadsheet workbook.
- 3What is a workbook made up of?A workbook is made up of one or more 'worksheets'
- 4What do cell references always start and end with?A cell reference always starts with a letter and ends with a number e.g. A5 or H28
- 5What is a range of cells?A range of cells is a set of cells in a row or column
- 6Name four data types that can be entered in a celltext, number, currency, date, percentage etc.
- 7What is a label? Labels – any text in a cell describing the data in a row or column(titles, headings that identify data)
- 8What is data? Data – any values (text or numbers) that are entered for the use of calculation
- 9What are formulas and functions? Formulas and functions – mathematical calculations carried out automatically
- 10What must formulas and functions start with?Must start with an =
- 11Where do formulas appear?Formulas appear in the formula bar.
- 12What are the four main mathematical operations? + Add
- Subtract
* Multiply
/ Divide - 13What are functions?Functions are part of spreadsheet software. They are specialised calculations built in to the spreadsheet software.
- 14What are the six main functions?SUM, COUNT, AVERAGE, MIN, MAX, IF
- 15What are the main features of formatting a cell?Font style, size, colour, border style, alignment, cell colour.
Multiple cells can be merged in to one cell - 16Name three data typesCurrency, number, real, integer (whole number), date, text
- 17What is replicating a cell?When 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.
- 18What is a benefit of creating graphs and charts?Using charts/graphs allows us to notice patterns & trends more easily
- 19Name two different types of charts and graphs that can be created and give an example when they can be used. Bar charts – to compare values
Pie charts – to show how a total is divided among a number of different categories.
Line graph – display trends - 20What is cell referencing?When a formula is copied by ‘filling down’ the cell references in cells are adjusted as you drag the pointer down the page.
- 21What is relative cell referencing?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.
- 22What is a absolute cell references?Absolute cell referencing is where a reference to a cell used in a formula where, when the formula is copied to a new cell reference (cell address), the cell reference (cell address) does not change, it is glued in place.
- 23What needs to be added to the cell reference to make it an absolute cell reference?You need to put a $ sign. e.g =B3*$C$9
- 24What is a "what if" calculation?A "What If" calculation allows you to use a spreadsheet to see what would happen if certain figures changed in a spreadsheet. For example, you may want to explore what would happen to your profit if VAT changed to 30%.
- 25Give four benefits of using a spreadsheet.Automatic recalculation: When content of cell is changed, other cells update if necessary.
Accurate calculations: Providing the formulas have been set up correctly.
Graphs/Charts can be created
What If calculations
Formulas can be reused and stored
Calculations involving large numbers are possible
Replication: Dragging a formula down a column so it performs it in the other cells; saves a lot of time.
Information
- Description
- Flashcards on I.C.T Topic 10 revision, created by Georgina Jeffries on 12/02/2015.
- Created by
- Georgina Jeffries
- Views
- 0
- Rating