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

Excel Functions and Formulas Glossary

AB
FunctionA predefined formula that performs a calculation
SumAdds all the numbers in a range of cells
AverageAdds a range of cells and then divides by the number of cell entries
CountCounts the number of numeric entries in a range
MinReturns the smallest value in a set of values
MaxReturns the largest value in a set of values
ArgumentThis can be a value, a cell reference, a range of cells, or even another function.
FormulaA formula is the equation used to calculate values in a cell
Cell ReferenceA unique identifier for a cell which is formed by combining the cell's column letter and row number
OperatorA symbol that indicates the type of calculation to perform on the operands, such as a plus sign (+) for addition.
OperandA constant (text or number) or cell reference used in a formula.
Order of OperationsThe mathematical rules used for calculating the value of a formula
Absolute Cell ReferenceCell reference that does not adjust to the new cell location when copied or moved
Relative Cell ReferenceCell reference that adjusts to a new location when copied or moved
Mixed Cell ReferenceA cell reference that contains both relative and absolute references


Stuttgart Jr. High
Stuttgart, AR

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