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

Spreadsheet Basics Vocabulary

25 Key Terms

AB
ColumnsVertical arrangement identified by letters
RowsHorizontal arrangement identified by numbers
Cellintersection of a row and column
Cell addressIndividual locations on a spreadsheet, identified by the column letter and the row number
Cell rangeA selected group of cells
WorkbookA file which contains one or more spreadsheets
LabelClassification used for cells that contain text or for numbers that will not be used in calculations
Active cellThe cell that is currently selected or the cell that you are working in
FormulaInstructs the software to perform a calculation
FunctionsShortcut for a formula
Fill handleCopying data to adjacent cells
ValueClassification used for cells when data has the potential to be used in calculations
MaximumReturns the higest number
MinimumReturns the smallest number
SUMAdd a range of cells
Relative cell referenceCell values change when formula is copied
Absolute cell referenceCell value does not change when copied to other locations, remains static (the same)
Wrap textDisplays text on multiple lines in a single cell
Sort ascendArranging data from smallest to largest or A-Z.
Sort descendArranging data from largest to smallest or Z-A.
RenamingA spreadsheet adds a descriptive identifier to the spreadsheet tab
Mixed cell referenceA combination of absolute and relative
Order of operationsPEMDAS
Equal signTells Excel to perform a mathematical operation
SpreadsheetAn arrangement of cells in columns and rows used to organize, analyze, calculate and report information, usually in numeric form.


Business Education Teacher
Hope Mills Middle School
Hope Mills, NC

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