Home
Browse
Create
Search
Log in
Sign up
Upgrade to remove ads
Only $2.99/month
Year 7: Spreadsheet modelling
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
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...
Year 7: Intro to graphics
19 terms
Year 7: Intro to coding
11 terms
Year 7: All about me
17 terms
YOU MIGHT ALSO LIKE...
Spreadsheet Terms
46 terms
Spreadsheet Terms 7th
46 terms
excel-computer basics
62 terms
CIS: Excel
53 terms
OTHER SETS BY THIS CREATOR
Y9: Chens' holiday
16 terms
Y9: 3D graphics & animation
18 terms
Y9: Databases
19 terms
Year 8: Research project
17 terms