Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
17 Cards in this Set
- Front
- Back
Constants |
A value in a formula that doesn't change |
|
Significant digits |
The number of digits that should be displayed for a calculation; they indicate the accuracy of the measured and calculated values |
|
Count function |
A function that tallies how many cells in a 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 a 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 |
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 |
|
Workday function |
A function that displays the date of a weekday that is a specified number of weekdays past a starting date |
|
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 |
|
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 |
|
Comparison operator |
A symbol that indicates the relationship between two values |