GRADE 11

A way of representing the relationships in a real-life, complex system using text, diagrams, symbols or numbers and formulae

• Simulation
• Visualization
• Analysis
• Data Model

Made up of cells that are adjacent to each other and go from left to right or right to left horizontally

• vertical
• diagonal
• rows

• column

Made up of cells that are adjacent to each other and go from top to bottom or bottom to top vertically

• Columns

• Diagonal
• Horizontal
• Row

The small rectangular sections on spreadsheets used to enter data such as text, numbers or symbols and to perform calculations using formulae and functions

• Segments
• Spaces
• Blocks
• Cells

When more than one single cell has been joined to make a larger cell

• spreadsheet

• Merged cells

• cell references

a way of pointing to a part of a spreadsheet using letters for columns and numbers for rows

• Cell location
• Grid reference
• Coordinate system
• Cell references

arithmetical operations carried out on the contents of cells. The plural of formula is formulae

• formulas
• formulums
• formula

• formuli

A cell reference that changes as it is copied down columns or across rows

• Fixed cell reference
• Relative reference

• Static cell reference
• Absolute reference

A cell reference that does not change as it is copied down columns or across rows

• Absolute reference

• Relative reference

• Dynamic cell reference
• Stationary cell reference

a range of cells filled with values that increment

• Series

• Range

• function