General
Purpose Packages
Automated
Systems
Commercial Data
Processing
Computer Systems
Hardware
Computer Systems
Software
Programming Course
Arrangements

Spreadsheet Glossary

 

Click on a letter!

 

A

Top
Absolute referencing A cell reference within a spreadsheet whih remains the same when copied (replicated) to another cell.
Alignment. The way that text is set out, for example, right, left, centered or justified.
AVERAGE(..) A function used to find the average value in a range.
   

B

Top
   

C

Top
Cell A box on a spreadsheet that can contain text numbers or a formulae.
Cell attributes The way the spreadsheet cell displays data such as numbers or dates.
Cell format The way the spreadsheet cell looks, for example changing the column width or alignment.
Cell protection Locking the contents of the cell to prevent them from being changed.
Charting Drawing a graph from a set of numerical data, usually from a spreadsheet program.
Columns Vertical parts of a spreadsheet.
Complex formulae Complicated formulaes used in a spreadsheet.
   

D

Top
Data A general term used for numbers, characters, symbols, graphics and sound which are accepted and processed by a computer system.
Delete To remove data
   

E

Top
   
   

F

Top
File Information held on backing storage or in memory.
Formulae A calculation involving one or more cell references in a spreadsheet.
   

G

Top
   
   

H

Top
Hard Copy A printed copy of your work, usually on paper.
   

I

Top
Insert To put Information.
Insert column To add a column .
Insert row To add a row.
Integer A whole number, with no fractional part or decimal point.
   

J

Top
   
   

K

Top
   

L

Top
   

M

Top
MAXIMUM(..) or MAX(..) A function used to find a maximum value in a range.
MINIMUM(..) or MIN(..) A function used to find a minimum value in a range.
   

N

Top
   

O

Top
   

P

Top
Print file To obtain hard copy.
   
   

Q

Top
   

R

Top
Relative Referencing When a formulae in a spreadsheet is changed relative to its position, during copying or replication.
Replicate To copy
Rows Horizontal parts of a spreadsheet.
   

S

Top
Spreadsheet A program used mainly for dealing with number data. It divides the screen into rows and columns. The cells can contain text, numbers and formulae.
   

T

Top
Table A table is made up of data arranged in rows and columns like a spreadsheet and data is placed in the cells.
   

U

Top
   

V

Top
   

W

Top
   

X

Top
   

Y

Top
   

Z

Top
   
 

 

 


 

 

 

 

 

Home | S1 Topics | S2 Topics
Computing Standard Grade | Info Systems Intermediate II | Info Systems Higher | Internet Safety
Log into Glow | School Website | Contact Us