Term

Definition
Excel is a powerful decisionmaking tool containing data that can be manipulated to answer "what if" situations. 


Term

Definition
After typing a formula in a cell, press the Enter key, the Tab key, Shift + Tab, or click the Enter button on the formula bar. 


Term

Definition
From Left to right in a formuala is an order of operations. 


Term

Definition
A situation where a formula is copied to another location in a worksheet. 


Term

Definition
Use the fill handle to copy a relative version of a formula. 


Term
Writing a Formula by Pointing 

Definition
Creating a formual is more accurate than typing the cell reference since a mistake can happen when typing the cell reference. 


Term

Definition
Pops up when you have a error it has a drop down list that displays options for updating the formual to include specific cells, getting help on the error, ignoring error, editing the error in the formula bar. and completing an error check. 


Term

Definition
The display of the smart tag button varies depending on the action performed. 


Term

Definition
Function is a built in formuala. for example =sum is a function 


Term

Definition
An argument may consist of a constant, a cell reference, or another function (refered to as a nested function) 


Term

Definition
If a function is includded in an argument within a function its called a nested function. 


Term

Definition
When a value calculated by the formula is inserted in a cell, the process is referred to as returing the result. 


Term

Definition
Refers to the process of calculating the formula. 


Term

Definition
Refers to inserting the value in the cell. 


Term

Definition
The formulas tab provided the insert function button as well as other buttons for inserting functions in a worksheet. 


Term

Definition
You can also display the Insert function dialog box by clicking the downpointing arrow at the right side of the Sum button and then clicking More Functions. 


Term

Definition
Click the downpointing arrow at the right side of the sum button in the Formulas tab and common functions display in a dropdown list. 


Term

Definition
A common function in a formual is the Average Function. 

