click below
click below
Normal Size Small Size show me how
BTA vocab 4-
Question | Answer |
---|---|
Absolute Reference | A cell reference that does not change when a formula is copied to a new location |
Chart | A graphic that organizes data visually Common charts are pie charts, bar charts, and line charts. |
Condition | A rule |
COUNT | A function that counts the number of cells in the range that contain numbers |
COUNTA | A function used to find the number of cells in a range that contain data |
Filter | A feature that allows you to look at only the data that you need |
Function | A list of preset formula that are used to solve equations |
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 |
Mixed Reference | A cell reference that is part relative and part absolute |
NOW | A function that displays the date and time that a worksheet is opened or used |
Operator | A symbol that represents a mathematical function |
PMT | A function that calculates payments for a loan based on interest rate, number of payments, and the amount of the loan. |
Range | A group of cells |
Relative Reference | A cell reference that changes when a formula is copied to a new location |
Sort | to put a list of data in ascending order |
Adjust | To adapt of confirm |
Version | A form of variant of a type or original |