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

Unit 5 Spreadsheets

Terminology

AB
Absolute cell referenceKeeping a cell reference constant when copying a formula
AVERAGEA spreadsheet function that indicates the average of a group of numbers in a range
Active cellThe cell in which you are currently working
Bar graphA type of graph that represents different quantities by using bars
CellThe point at which a column and a row intersect or meet.
Cell address/cell referenceThe location of a cell as identified by the column letter and row number
ColumnVertical 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 data entered from the keyboard is displayed as it is entered into the cell
FunctionBuilt-in formulas used with a range to perform calculations.
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.
Pie graphA type of graph that divides the total into the parts of a circle
Portrait orientationA paper orientation that is taller than it is wide
RangeA group of cells closely related
RowHorizontal sections of a spreadsheet. Identified by a number
SpreadsheetA row and column arrangement of data used to enter, calculate, manipulate, and analyze numbers. They are used to prepare budgets, financial statements, and inventory management.
SUMA function used to add numbers in a range.
ValueA number entered on a spreadsheet



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