ICT Spreadsheet Theory

HideShow resource information
Spreadsheet
Columns and rows that assist finacial modelling
1 of 17
Row
Horizontal - Numers
2 of 17
Column
Veritcal - Letters
3 of 17
Replication
Copying of a cell either horizontialy or vertically
4 of 17
Variable
Identifies cells, either with a cell reference or cell name
5 of 17
Formulae
A way that a calculation is represented in a spreadsheet
6 of 17
Rules
A procedure that must be followed
7 of 17
Functions
Represents a formulae that is already programmed into the spreadsheet - SUM
8 of 17
SUM
Adds a range of cells
9 of 17
MIN/MAX
Shows the min value or max in selected data
10 of 17
COUNTIF
Counts the number of cells within a range that meet a given critera
11 of 17
Worksheet
A page of cells inside a work book
12 of 17
Work book
The document that holds worksheets
13 of 17
Cell
An individual data store
14 of 17
Range
A group of cells within a worksheet I.E A1:A11
15 of 17
Relative Cell Referencing
When the formula changes when copied to other cells
16 of 17
Absolute Cell Referencing
When the formula stays the same when copied to other cels $$
17 of 17

Other cards in this set

Card 2

Front

Horizontal - Numers

Back

Row

Card 3

Front

Veritcal - Letters

Back

Preview of the back of card 3

Card 4

Front

Copying of a cell either horizontialy or vertically

Back

Preview of the back of card 4

Card 5

Front

Identifies cells, either with a cell reference or cell name

Back

Preview of the back of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Databases resources »