click below
click below
Normal Size Small Size show me how
U2L4
Vocab
Question | Answer |
---|---|
1. Absolute Reference | A cell reference that does not change when a formula is copied to a new location. |
2. Chart | A graphic that organizes data visually . |
3. Condition | A rule. |
4. COUNT | A function that counts the number of cells in the range that contain numbers. |
5. COUNTA | A function used to find the number of cells in a range that contain data. |
6. Filter | A feature that allows you to look at only the data that you need. |
7. Function | A list of present formulas that are used to solve equations. |
8. IF | A function that checks to see if a condition is met and then has one result if it is true and another if it is false. |
9. Mixed Reference | A cell reference that is part relative and part absolute. |
10. NOW | A function that displays the date and time that a worksheet is opened or used. |
11. Operator | A symbol that represents a mathematical function. |
12. PMT | A function that calculates payments for a loan based on interest rate, number of payments and the amount of the loan. |
13. Range | A group of cells. |
14. Relative Reference | A cell reference that changes when a formula is copied to a new location. |
15. Sort | To put a list of data in ascending or descending order. |
16. Adjust | To adapt or conform. |
17. Version | A form or variant of a type or original. |