Search
Browse
Create
Log in
Sign up
Log in
Sign up
BITM Excel 2
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (34)
Absolute Cell Reference
A designation that provides a permanent reference to a specific cell. The formula does not change, regardless of where you copy the formula. It appears with a dollar sign before the column letter and row number
Argument
A variable constant input, such as cell reference or value, needed to complete a function. The entire group of arguments for a function is enclosed in parentheses
AVERAGE Function
A statistical function that calculates the arithmetic mean, or average, of values in a range
Breakpoint
The lowest value for a specific category or series in a lookup table
Circular Reference
Occurs when a formula directly or indirectly refers to itself
Column Index Number
The number of the column in the lookup table that contains the return values. Used as the third argument in a VLOOUP or HLOOKUP function
COUNT Function
A statistical function that tallies the number of cells in a range that are not blank; that is, cells that contain data, whether a value, text or a formula
COUNTBLANK Function
A statistical function that tallies the number of cells in a range that are blank
Formula AutoComplete
A feature that displays a list of functions and defined names that match letters as you type a formula
Function
A predefined computation that simplifies creating a complex calculation and produces a result based on inputs known as arguments
Function ScreenTip
A small pop-up description that displays the arguments for a function as you enter it directly into a cell
HLOOKUP Function
A lookup & reference function that looks up a value in a horizontal lookup table where the first row contains the values to compare with the lookup value
IF Function
A logical function that evaluates a condition and returns one value if the condition is true and a different condition of the value is false
Logical Test
An expression that evaluates to true or false; the first argument in an IF function
Lookup Table
A range that contains data for the basis of the lookup and data to be retrieved. In vertical lookup table, the first column contains a list of values to compare to the lookup value. In a horizontal lookup table, the first row contains a list of values to compare to the lookup value
Lookup Value
The cell reference of the cell that contains the value to look up within a lookup table
MAX Function
A statistical function that finds the highest value in a range
MEDIAN Function
A statistical function that finds the midpoint value, which is the value that one half of the values in a list are above or below
MIN Function
A statistical function that finds the lowest value in a range
Mixed Cell Reference
A designation that combines an absolute cell reference with a relative cell reference, such as $B4 or B$4
Nested Function
A function that contains another function embedded inside one or more of its arguments
NOW Function
A date & time function that uses the computer's clock to display the current date and time in a cell
Nper
The number of payment periods over the life of a loan or investment; the second argument in the PMT function
PMT Function
A financial function in Excel that calculates the periodic loan payment
Pv
The present value of a loan or an annuity; the third argument in the PMT function and reference to the original amount of the loan
Quick Analysis
A tool that provides a fast way to analyze a selected range of data by inserting basic calculations, creating charts, converting the data to a table, or applying conditional formatting or other analytical features
Range Name
A word or string of characters assigned to one or more cells. It can be up to 255 letters, characters, or numbers but must start with a letter or underscore and have no spaces or special symbols
Rate
The periodic interest rate; the percentage of interest paid for each payment period; the first argument in the PMT function
Relative Cell Reference
A designation that indicates a cell's relative location within the worksheet using the column letter and row number. The cell reference changes when the formula is copied
SUM Function
A statistical function that calculates the total of values contained in two or more cells
Syntax
The rules that dictate the structure and components required to perform the necessary calculations in an equation or to evaluate expressions
Table Array
The range that contains the body of the lookup table, excluding column labels. The first column must be in ascending order to find a value in a range, or it can be in any order to look up an exact value. The second argument within a VLOOKUP or HLOOKUP function
TODAY Function
A date & time function that displays the current date in a cell
VLOOKUP Function
Looks up a value in a vertical lookup table and returns a related result from the lookup table
YOU MIGHT ALSO LIKE...
Chapter 2
35 Terms
delaneyb32
Excel Chapter 2
35 Terms
melcgarcia
Excel - Chapter 2
20 Terms
bitm215
Excel - Chapter 2
20 Terms
dongdong_wu
OTHER SETS BY THIS CREATOR
Chapter 17: Direct & Online Marketing
10 Terms
sraemsanchez
Chapter 15: Advertising & Public Relations
10 Terms
sraemsanchez
Chapter 13: Retailing & Wholesaling
10 Terms
sraemsanchez
Chapter 12 - Marketing Channels: Delivering Customer Value
10 Terms
sraemsanchez
THIS SET IS OFTEN IN FOLDERS WITH...
BITM Excel 1
45 Terms
sraemsanchez
BITM Excel 3
41 Terms
sraemsanchez
BITM Excel 4
17 Terms
sraemsanchez
Excel Chapter 1 Words To Know
67 Terms
MaddyNicole28
;