Spreadsheets Revision Resource 0.0 / 5 ? ICTSpreadsheets and DatabasesGCSEAQA Created by: notae003Created on: 12-05-14 10:29 What is a workbook? An application that can store all its data in a single file. 1 of 26 What does a workbook contain? Worksheets 2 of 26 What is a worksheet? A single tab in the spreadsheet workbook 3 of 26 What does a cell reference start and end with? A letter and a number 4 of 26 What is a range of cells? A set of cells in a row or column 5 of 26 What is a label? Any text in a cell describing the data in a row/column e.g titles 6 of 26 What is data? Any values (text/numbers) that are entered for the use of calculation 7 of 26 What are formulas/functions? Mathematical calculations carried out automatically 8 of 26 Name the four operators for formulas + Add, - Subtract, * Multiply and / Divide 9 of 26 What must formulas/functions start with? An equals sign (=) 10 of 26 What do formulas/functions perform calculations on? Cell contents 11 of 26 Where do formulas/functions appear? In the formula bar 12 of 26 What are functions (specific definition)? Specialised calculations built into the spreadsheet software 13 of 26 Give three examples of different functions SUM, AVERAGE, IF, COUNT, MIN/MAX, COUNTIF, WHATIF 14 of 26 What is relative cell reference? When a cell is used in a formula and the formula is copied to a new cell reference and changes to take account of the formula's new position 15 of 26 What is absolute cell referencing? Where a reference to a cell used in a formula where, when the formula is copied to a new cell reference, the cell reference doesn't change 16 of 26 Benefits of using a spreadsheet are... Auto-recalculation, accurate calculations, graphs/charts, replication etc. 17 of 26 What is the active cell? The cell that is currently in use - it is featured in the name box 18 of 26 What is automatic recalculation? Every time the content of a cell changes, calculations are performed and other cells are updated if necessary 19 of 26 Give three examples of different graphs/charts Bar charts, pie charts and line graphs 20 of 26 Why are graphs/charts used in spreadsheets? They allow us to notice patterns/trends more easily 21 of 26 Why are bar charts used in spreadsheets? To compare values 22 of 26 What are pie charts used in spreadsheets? To show how a total is divided among a number of different categories 23 of 26 Why are line graphs used in spreadsheets? To display trends 24 of 26 Give 6 different ways that a cell can be formatted Font style, size, colour, border style, alignment, cell colour 25 of 26 Why are 'what if' calculations used? To allow us to use a spreadsheet to see what would happen if certain figures changed in the spreadsheet 26 of 26
Comments
No comments have yet been made