# Shared Flashcard Set

## Details

Excel 2007-Chapter 2 Notes
Chapter 2- Inserting Formulas in a Worksheet
18
Other
02/10/2009

Term
 Excel
Definition
 Excel is a powerful decision-making tool containing data that can be manipulated to answer "what if" situations.
Term
 Hint
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
 Order of Operations
Definition
 From Left to right in a formuala is an order of operations.
Term
 Relative Cell Reference
Definition
 A situation where a formula is copied to another location in a worksheet.
Term
 Hint
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
 Trace error
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
 Smart Tag
Definition
 The display of the smart tag button varies depending on the action performed.
Term
 Function
Definition
 Function is a built in formuala. for example =sum is a function
Term
 Argument
Definition
 An argument may consist of a constant, a cell reference, or another function (refered to as a nested function)
Term
 Nested Function
Definition
 If a function is includded in an argument within a function its called a nested function.
Term
 Returning the Result
Definition
 When a value calculated by the formula is inserted in a cell, the process is referred to as returing the result.
Term
 Returning
Definition
 Refers to the process of calculating the formula.
Term
 Return
Definition
 Refers to inserting the value in the cell.
Term
 Insert Function
Definition
 The formulas tab provided the insert function button as well as other buttons for inserting functions in a worksheet.
Term
 Hint
Definition
 You can also display the Insert function dialog box by clicking the down-pointing arrow at the right side of the Sum button and then clicking More Functions.
Term
 Hint
Definition
 Click the down-pointing arrow at the right side of the sum button in the Formulas tab and common functions display in a drop-down list.
Term
 Average
Definition
 A common function in a formual is the Average Function.
Supporting users have an ad free experience!