Spreadsheets

Description

GCSE IT (Manipulating Data) Flashcards on Spreadsheets, created by Dean Whittle on 10/04/2014.
Dean Whittle
Flashcards by Dean Whittle, updated more than 1 year ago
Dean Whittle
Created by Dean Whittle over 11 years ago
27
0
1 2 3 4 5 (0)

Resource summary

Question Answer
Formula Performs calculations using numbers, cell references and mathematical operators.
Function a standard routine to perform common tasks. A complex formula which uses reserved words.
Absoloute cell reference When a formula is copied from one cell to another there may be a need to maintain an absolute reference with the original cells
Relative Cell reference when a formula is copied / replicated into another cell the cell references change with it.
Spreadsheet Model A series of equations that have been inserted into a spreadsheet to simulate a real situation.
Variable A value that can be changed
Macros A way to automate a task or procedure which are performed on a regular basis.
Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

Similar

Geography Coastal Zones Flashcards
Zakiya Tabassum
Biology- Genes and Variation
Laura Perry
Enzymes and Respiration
I Turner
GCSE AQA Biology - Unit 2
James Jolliffe
GCSE AQA Physics - Unit 3
James Jolliffe
GCSE History – Social Impact of the Nazi State in 1945
Ben C
GCSE Maths: Understanding Pythagoras' Theorem
Micheal Heffernan
GCSE Combined Science
Derek Cumberbatch
GCSE Biology AQA
isabellabeaumont
GCSE Biology B2 (OCR)
Usman Rauf