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

Excel Definitions

Formatting Cells, Formulas & Functions

AB
CellThe box where the numbers, the labels, or the formulas are entered
ColumnThe collection of cells in a line from top to bottom
RowThe collection of cells in a line from side to side
WorksheetThe single page of rows and columns that is on the screen
WorkbookThe collection of pages (worksheets) that make up one file
RangeA group of cells that are next to each other
Mouse pointerThe arrow or other marker that indicates where the mouse is pointing
FormulaA mathematical expression that gives instructions to the computer about what to do with the contents of specified cells
FunctionA special formual that names a function instead of using operators to calculate a result
Active cellA cell that is selected indicated by a dark border
Fill handleA small square in the bottom right corner of an active cell in a worksheet
AutofitAutomatically adjusts column width to display data in cells
Absolute cell referenceA cell reference that does not change when the formula is copied or moved to a new location
Relative cell referenceA cell reference that is adjusted when the formula is copied or moved to a new location
ArgumentA value, cell reference, range or text that acts as an operand in a function formula
OperandA number or cell reference in a spreadsheet formula
OperatorA symbol that tells Excel what mathematical operation to perform in a worksheet formula
=AVERAGETotals the range of cells and then divides the total by the number of entries in the specified range
=COUNTCounts the number of cells with values in the specified range
=MAXDisplays the maximum value within the specified range of cells
=MINDisplays the minimum value within the specified range of cells
=MEDIANDisplays the middle value in the specified range of cells

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