Shared Flashcard Set

Details

Excel 2007 Ch.2 Notes
Chapter 2-Inserting formulas in a worksheet
34
Other
11th Grade
02/04/2009

Additional Other Flashcards

 


 

Cards

Term
relative cell reference
Definition
where a formula is copiedto other locations in a wrksheet
Term
Fill drop down list
Definition
click the desired direction
Term
smart tag
Definition
a button that pops up near the active cell.
Term
argument
Definition
may consit of a sonstant, a cell reference, or another function(referred to as a rested function).
Term
nested function
Definition
if a function is included in an argument within a function
Term
returning the result
Definition
when a value calculated by the formula is inserted in a cell
Term
returning
Definition
refers to the process of calculating the formula
Term
result
Definition
refers to inserting the value in the cell.
Term
Insert Function
Definition
dialog box by clicking the down-pointing arrow at teh right side of Sum button adn then clicking More Functions.
Term
hint
Definition
click the down pointing arrow at teh right side of trhe ?Sum button in the Formulas tab adn common functions display in a drop down list.
Term
SUM function
Definition
is included in teh Math&Trig category
Term
Formula Auto-Complete feature
Definition
that displays a drop-down list of functions
Term
function
Definition
the beginning of the formula, =SUM
Term
Formulas with Statistical Functions
Definition
AVERAGE,MAX,MIN, AND COUNT.
Term
AVERAGE function
Definition
returns teh average (arithmetic mean) of the arguments. which will add all of teh test scores for a student and then divide that number by the total number of tests.
Term
MAX function
Definition
returns teh largest value in a set of values.
Term
MIN function
Definition
returns the smallest value in a set of values.
Term
COUNT function
Definition
to count the number of cells that contain numbers within the list of arguments.
Term
ctrl + '
Definition
to turn off the diplay of formulas
Term
PMT function
Definition
finds the periodic payment for a loan based on constant interest rate. contains the arguments Nper, Pv, Fv, and Type.
Term
Nper arugment
Definition
is the number of payments that will be made to an investment or loan.
Term
Pv
Definition
is the current value of amunts to be recieved or paid in teh future.
Term
Fv
Definition
is the value of a loan or investment at the end of all periods, use this funcion to determine information such as how much money can be earned in an investment account with a specific interest rate adn over a specific period of time.
Term
Type
Definition
determines whether calculations will be based on payment made in arrears (at the end of each period) or in advance (at the beginning of each period).
Term
NOW function
Definition
returns the serial number of thecurrent date and time.
Term
DATE function
Definition
returns the serial number that represents a particular date.
Term
Aligning or Indenting Data
Definition
you can align adn indent data in cells using buttons in the Alignment group in the Home tab or with options at the Format cells dialog box with teh Alignment tab.
Term
TExt alignment
Definition
specifies horizontal and vertical alignment with options
Term
conditional function
Definition
to calcualte sales bonuses, determine letter grades based on test averages, adn identify discounts and discount amounts.
Term
logical test
Definition
a queation that can be answered with true or false.
Term
edit formula
Definition
by makin active the cell containing the formula adn then editing the formula in the cell or in teh Formula bare text box.
Term
Nested IF function
Definition
insert symbols such as commas, quotations marks, and parentheses in teh proper locations. formula begins with =IF()
Term
absolute cell reference
Definition
refer to cells in a specific location.
Term
mixed cell reference
Definition
either the column remains absolute adn teh row is relative, absolute, and mixed cell references using the dollar sign ($)
Supporting users have an ad free experience!