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 about 11 years ago
26
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

Biology Revision - Y10 Mock
Tom Mitchell
Hitler and the Nazi Party (1919-23)
Adam Collinge
Biology- Genes and Variation
Laura Perry
FREQUENCY TABLES: MODE, MEDIAN AND MEAN
Elliot O'Leary
CUMULATIVE FREQUENCY DIAGRAMS
Elliot O'Leary
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 Combined Science
Derek Cumberbatch