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

MOAC Excel Lesson 8 Terms Review

AB
absolute cell referenceA reference that does not change when a formula is copied or moved.
external referenceA cell or range on a worksheet in another Excel workbook, or a defined name in another workbook.
mixed referenceA reference in which one component is absolute and one is relative.
referenceA component of a formula that identifies a cell or a range of cells on a worksheet.
relative cell referenceA reference that changes “relative” to the location where it is copied or moved.
argumentsA component of a function that is enclosed in parentheses.
constantA number or text value that is entered directly into a formula.
formulaAn equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
functionA predefined formula that performs a calculation.
mathematical operatorAn element that specifies a calculation to be performed.
nameA meaningful and logical identifier that a user can apply to make it easier to understand the purpose of a cell reference, constant, formula, or table.
operandAn element that identifies the value to be used in a calculation.
scopeThe location within which Excel recognizes an item without qualification.


Business Education Teacher
Mount Airy High School
NC

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