Microcomputer Concepts Module 9 Key Terms

Microcomputer Concepts Module 9 Key Terms

1. Absolute Reference

   • A cell reference that remains fixed when the cell formula is copied to a new location

2. Approximate match lookup

   • A look up where the lookup falls within a range of numbers in the compare values in the lookup table.sd

3. Argument

   • The numbers, text, or cell references used by the function to return a value

4. AutoFill

   • A feature that copies content and formats from a cell or range into an adjacent cell or range

5. Compare values

   • The categories used for matching to a specified lookup value in a lookup table

6. Comparison operator

   • A symbol that indicates the relationship between two values

7. Constant

   • A value in a formula that doesn't change

8. COUNT function

   • The Excel function that tallies how many cells in specified range contain numbers or dates

9. COUNTA function

   • A function that tallies how many cells in specified range are not blank

10. Date function

    • A function that inserts or calculates dates and times

11. Error Value

    • A message in a cell that indicates some part of a formula is preventing Excel from returning a calculated value

12. Exact Match lookup

    • A lookup where the lookup value must match one of the compare values in the lookup table

13. Fill Handle

    • A small black square in the lower-right corner of a selected cell or range that you drag over adjacent cell or range to copy the original content and formatting into the selected range

14. Goal Seek

    • A feature that automates the trial - and -error method by allowing you to specify a value for the calculated item, which Excel uses to determine the input value needed to reach that goal

15. 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

16. Logical 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

17. 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

18. Lookup table

    • A table that stores the data you want to retrieve with a lookup function in categories

19. Lookup value

    • The category you want to find in a lookup table

20. Max function

    • A function that displays the maximum value in a range

21. Median Function

    • A function that determines the middle value in a range

22. Median

    • The middle value in data

23. MIN function

    • A function that displays the minimum value in the range

24. 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 or and absolute column

25. nest

    • To place one thing inside another, such as a function inside another function

26. optional argument

    • An argument that is not required for the function to return a value

27. Relative Reference

    • A cell reference that is interpreted in relation to the location of the cell containing the formula

28. Required argument

    • An argument that is needed for the function to return a value

29. Return Values

    • The data values you want to retrieve from a lookup table

30. Significant digits

    • The number of digits that should be displayed for a calculation; they indicate the accuracy of the measured and calculated values

31. TODAY function

    • A date function that displays the current date

32. Trial - and - error method

    • 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

33. What-if analysis

    • A way to explore the impact that changing input value has on the calculated values in a workbook

34. WORKDAY function

    • A function that displays the date of a weekday that is specified number of weekdays past a starting date

35. VLOOKUP function

    • A function that returns values from a vertical lookup table