Java Games: Flashcards, matching, concentration, and word search.

Spreadsheet Terms

AB
Absolute cell referencekeeping a cell reference constant when copying a formula
AverageA function that indicates the average of a group of numbers in a range
Active cellthe cell in which you are currently working
ArgumentA value needed to calculate a function
Bar graphA type of graph represented by using bars
CellThe point at which a column and row intersects
Cell addressThe location of a cell as identified by a column letter and a row number
Circular referenceOccurs when a formula in a spreadsheet refers to itself.
ColumnsVertical sections of a spreadsheet identified by a letter.
CountA spreadsheet function that counts the number of cells in a range that contains data.
FormulaStatement that performs a calculation
Formula barThe bar below the standard and formatting toolbars where date entered from the keyboard is displayed
FunctionBuilt in formulas used with a range to perform calculations.
If statementA logical function (formula) that allows the user to set up a condition to test data
Labelalphabetical text in a spreadsheet
Landscape orientationA paper orientation that is wider than it is tall
Line graphA type of graph that shows changes in data over a period of time.
MAXA spreadsheet function that indicates the highest value in a range
MINA spreadsheet function that indicates the lowest value in a range
OperationA symbol that represents a mathematical function.
Pie graphA type of graph that shows changes in data over a period of time
Portrait orientationA paper orientation that is taller than it is wide
RangeA group of cells closely related.
Relative cell referenceAdjusts the cell references in a formula while retaininig the mathematical processes.
RowsHorizontal sections of a spreadsheet identified by a number.
SpreadsheetAn application software program consisting of rows and columns that is used to calculate and analyze data.
SUMA function used to add numbers in a range.
ValueA number used for calculations in a spreadsheet
What if analysisA spreadsheet tool used to play out different situations to determine an outcome


CTE Business Educator
Person High School
Roxboro, NC

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities