Shared Flashcard Set

Details

Spotlight on Spreadsheets
Chapters 2 Vocabulary
13
Computer Science
7th Grade
10/26/2010

Cards Return to Set Details

Term
 Average function formula
Definition
 a formula that adds a range of numbers and divides the total by the quantity of numbers in that range.
Term
 Cell cursor
Definition
 solid outline around a cell that is used to indicate the selected cell.
Term
 Fill Handle
Definition
 used to copy a cellâ€™s contents to adjacent cells.
Term
 Formula
Definition
 equation that uses basic operators to calculate values in a spreadsheet cell. (addition, subtraction, multiplication and division)
Term
 Function formula
Definition
 a special formula containing a word to perform predetermined calculations using specific cells.
Term
 Label
Definition
 words or characters stored in a cell that cannot be used in calculations.
Term
 Maximum function formula
Definition
 a formula used to find the highest number in a range.
Term
 Minimum function formula
Definition
 a formula used to find the lowest number in a range.
Term
 Range
Definition
 adjacent cells in a row or column; group of cells (ex: B3:B8)
Term
 Sum function formula
Definition
 a formula used to add up all numbers in a range.
Term
 Values
Definition
 numeric data that can be stored in cells and used in calculations.
Term
 Workbook
Definition
 an excel spreadsheet file (usually contains three or more worksheets).
Term
 Worksheet
Definition
 one of three pages located inside the Excel workbook.
Supporting users have an ad free experience!