Module 3 Excel Definitions Flashcards
absolute cell reference
A cell reference that does not change when the formula containing that reference is moved to a new location.
approximate match lookup
A lookup where the lookup value falls within a range of numbers in the compare values in the lookup table.
argument
The numbers, text, or cell references used by the function to return a value
AutoFill
A feature that enters formula or data patterns into a selected range based on the content of the starting cells in the range.
compare values
The categories in a lookup table that are used for matching to a specified lookup value.
comparison operator
A symbol that indicates the relationship between two values.
constant
A value in a formula that doesn’t change.
COUNT function
The Excel function that tallies how many cells in specified range contain numbers or dates.
error value
A message in a cell that indicates some part of a formula is preventing Excel from returning a calculated value.
exact match lookup
A lookup where the lookup value must exactly match one of the compare values in the lookup table.
fill handle
A box that appears in the lower-right corner of a selected cell or range.
Goal Seek
A feature that automates the trial-and-error process by allowing you to specify a value for the calculated item, which Excel uses to determine the input value needed to reach that goal.
horizontal lookup table
A lookup table in which the compare values are located in the first row.
IF function
A logical function that tests a condition and then returns one value if the condition is true and another value if the condition is false.
logical function
A function that returns a different value depending on whether the given condition is true or false.
lookup function
A function that retrieves a value from a table of data that matches a specified condition.
lookup table
A table that stores the data you want to retrieve with a lookup function.
lookup value
MAX function
MEDIAN function
A function that returns the middle value in a range.
MIN function
A function that returns the minimum value in the range.
mixed reference
A cell reference that has both absolute and relative components.
relative cell reference
A cell reference that changes when the formula containing that reference is moved to a new location.
required argument
An argument that is needed for the function to return a value
return values
The data values you want to retrieve from a lookup table.
significant digits
The number of digits that should be displayed for a calculation; they indicate the accuracy of the measured and calculated values.
TODAY function
A date function that returns the current date.
vertical lookup table
A table used to retrieve data based on matching the category values found in the first column of the table.
VLOOKUP function
A function that returns values from a vertical lookup table.
WORKDAY function
A function that displays the date of a weekday that is a specified number of weekdays past a starting date.