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