click below
click below
Normal Size Small Size show me how
U2L4voc
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 (both numbers and text) |
Filter | a feature that allows you to look at only the data that you need |
Function | a list of preset formulas that are used to solve equations |
IF | a function that checks to 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 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 or descending order |
Adjust | modify |
Version | variation of the original |