Upgrade to remove ads
Only $2.99/month

Year 7: Spreadsheet modelling

Terms in this set (19)

Absolute cell reference
Cell reference that does not adjust to its new location when copied or moved.
Autofill
Automatically replicates data and formulae into cells.
Autosum
A function that automatically adds the values in a range.
Break even
To not make a profit, not make a loss, but arrive at an outcome of zero.
Chart
A graphical way to show data.
Filter
Allows you to display only certain data to make it easier to find specific information in a table.
Formula
Equation that performs a calculation on values in a worksheet.
Function
A built-in formula that makes it easy for you to perform common calculations.
Goal seek
A process that automatically works out a specific required value by changing the value in a related cell.
Hide/unhide
Show or reveal selected rows or columns.
Model
a computer program that is designed to simulate what might (or what did) happen in a situation.
Print area
Setting the print area restricts what is going to be printed. This is important when trying to fit a large spreadsheet on to one page while printing.
Range
A group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon. For example, A1:B20.
Relative cell reference
Cell reference that adjusts automatically when moved or copied.
Replicate
Another word meaning "to copy", especially for formulae.
Sort
Arranging the contents of a range in ascending (A to Z) or descending (Z to A) order.
Spreadsheet
A grid of rows and columns containing numbers, text, and formulas. Used to solve number-based problems.
What if...?' questions
Types of questions that explore different possible events or situations.
Worksheet
The workspace where you enter data.
THIS SET IS OFTEN IN FOLDERS WITH...