Upgrade to remove ads
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.
Automatically replicates data and formulae into cells.
A function that automatically adds the values in a range.
To not make a profit, not make a loss, but arrive at an outcome of zero.
A graphical way to show data.
Allows you to display only certain data to make it easier to find specific information in a table.
Equation that performs a calculation on values in a worksheet.
A built-in formula that makes it easy for you to perform common calculations.
A process that automatically works out a specific required value by changing the value in a related cell.
Show or reveal selected rows or columns.
a computer program that is designed to simulate what might (or what did) happen in a situation.
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.
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.
Another word meaning "to copy", especially for formulae.
Arranging the contents of a range in ascending (A to Z) or descending (Z to A) order.
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.
The workspace where you enter data.
THIS SET IS OFTEN IN FOLDERS WITH...
Year 7: Intro to graphics
Year 7: Intro to coding
Year 7: All about me
YOU MIGHT ALSO LIKE...
Spreadsheet Terms 7th
OTHER SETS BY THIS CREATOR
Y9: Chens' holiday
Y9: 3D graphics & animation
Year 8: Research project