Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
NP Excel 3
New Perspective Excel Unit 3
| Term | Definition |
|---|---|
| absolute reference | A cell reference that remains fixed when the cell formula is copied to a new location. |
| AutoFill | A feature that copies content (text, values, or formulas) and formats from a cell or range into an adjacent cell or range |
| comparison operator | A symbol that indicates the relationship between two values. |
| Constant | A value in a formula that doesn’t change. |
| COUNT function | A function that tallies how many cells in specified range are not blank (contain numbers, dates, or text) |
| fill handle | A small black square in the lower-right corner of a selected cell or range that you drag over an adjacent cell or range to copy the original content and formatting into the selected range |
| Goal Seek | A feature that automates the trial-and-error method by allowing you to specify a value for the calculated item, and Excel determines the input value needed to reach that goal. |
| 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 works with statements that are either true or false |
| lookup function | A function that finds a value in a table of data and inserts it in another location in the worksheet, such as a cell or in a formula. |
| lookup value | The category you want to find in a lookup table |
| MAX function | A function that displays the maximum value in a range. |
| Median | The middle value in data |
| MIN function | A function that displays the minimum value in the range |
| mixed reference | A cell reference that contains both relative and absolute references; for example, the mixed reference for cell D2 can have an absolute row (such as $D6) or an absolute column (such as D$6). |
| nest | To place one thing inside another, such as a function inside another function |
| relative reference | A cell reference that is interpreted in relation to the location of the cell containing the formula. |
| TODAY function | A date function that displays the current date. |
| what-if analysis | A way to explore the impact that changing input values has on the calculated values in a workbook |
| WORKDAY function | A function that displays the date of a weekday that is specified number of weekdays past a starting date. |
| VLOOKUP function | A function that returns values from a vertical lookup table. |
Created by:
skindawg
Popular Business sets