Excel Ch2 Flashcards
Relative Cell Reference
Moves with the formula (5 to the right, 3 down) changes
Function ScreenTip
A small pop-up description that displays the functions arguments
Median
Midpoint Value
Quick analysis
set of analytical tools you can use to apply formatting, create charts or tables, and insert basic functions
Today Function
Shows current date- Excel updates each time you open or print the worksheet
Now Function
Shows time along with date- Military time
IF Function
Tests specified criteria to see if it is true or false, then returns one value when condition is true and another when condition is false
Logical Test
An expression that evaluates to true or false
VLookup Function
A lookup and reference function that accepts a value, looks up value in a vertical lookup table (or Range) with data in columns and returns a result.
Lookup Table
A range that contains data for the basis of the lookup and the data to be received
Breakpoint
The lowest value for a category or in a series
PMT Function
A financial function that calculates the periodic loan payment given a fixed rate, number of periods and present value of the loan.
Rate
Periodic interest rate. the percentage of of interest paid for each payment period
NPer
Total number of payment periods
PV
Present value of the loan
