Module 3 Flashcards
constants
a value in a formula that doesnt change
significant digits
the number of digits that should be displayed for a calculation; they indicate the accuracy of the measure and calculated values
COUNTA function
a function that tallies how many cells in specified range contain any entries (numbers, dates, or text)
nested
to place one thing inside another, such as a function inside another function
what-if analysis
a way to explore the impact that changing input
values has on calculated values in a workbook
trial and error
a way to perform what-if analysis by changing one or more of the input values to a value you estimate to see how it impacts the calculated results
goal seek
Definition:
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.
error value
a message in a cell that indicates some part of a formula is preventing Excel from returning a calculated value
fill handle
a box that appears in the lower-right corner of a selected cell or range
lookup function
a function that retrieves a value from a table of data that matches a specified condition
lookup table
a table that sores the data you want to retrieve with a lookup function
horizontal lookup table
a lookup table in which the compare values are located in the first row
exact match lookup
a lookup where the lookup value must exactly match one of the compare values in the lookup table
approximate match lookup
a lookup where the lookup value falls within a range of numbers in the compare values in the lookup table
logical function
a function that returns a different value depending on whether the given condition is true or false
