Term

Definition
Payment of a loan based on constant payments/rate =PMT(rate,nper,pv) 


Term

Definition
Mean list of values =median(range) 


Term

Definition
Count non empty cells =counta(range) 


Term

Definition
Most frequently occurring number in a list =mode(range) 


Term

Definition
Change the contents of a cell based on criteria =if(logical test, (true value), (false value) 


Term

Definition
Information returned from a table =vlookup(lookup value, table array, independent number) 


Term

Definition
Change the appearance of a cell based on criteria 


Term

Definition
Eliminate a decimal part of a number =trunc(number) 


Term

Definition
Displays date and time =now() 


Term

Definition
find the lowest number in a range =min(range) 


Term

Definition
find the highest number in a range =max(range) 


Term

Definition
Displays date and time =today() 


Term

Definition
Count cells based on criteria =countif(range,criteria) 


Term

Definition
Return the sum of products of the corresponding ranges or arrays =sumproduct(range,range) 


Term

Definition
Count the number of cells that contain numbers =count(range) 


Term

Definition
Format number to specific digits =round(number,number) 


Term

Definition
Finding the right insput when you know the result you want 


Term

Definition
Join several text strings together concatenate=(text 1, text 2, text 3) 


Term

Definition
The unique address of a cell 


Term

Definition


Term

Definition


Term

Definition


Term

Definition
Join several cells into one 


Term

Definition
A prewritten formula built into excel 


Term

Definition
Check which cells are reference sin the formula assigned to the active cell 


Term

Definition
Allows you to select cells for use in formula with a mouse 


Term

Definition
Format for fixed dollar sign 


Term

Definition
Format for Floating dollar sign 


Term

Definition
Allows you to create or modify a worksheet while viewing what it looks like printed 


Term

Definition
Display the formulas version 


Term

Definition
Clears date and resets format when used 


Term

Definition
Leaves format and data intact 


Term

Definition


Term

Definition
___ is inserted to the left 


Term

Definition
Keeps titles on the sreen no matter how far you scroll 


Term

Definition
A date is just a ___ since 1/1/1900 


Term

Definition
Addressing mode that keeps the column and row the same as you copy the formula 


Term

Definition
Addressing mode that keeps the column the same as you copy the formula 


Term

Definition
Addressing mode that adjusts the column and row as you copy the formula 


Term

Definition
Feature that scrutinizes the impact of changing values in cells mthat are references by a formula in another cell 


Term

Definition
Black square located in the lower right corner of an active cell 

