click below
click below
Normal Size Small Size show me how
vocab 4
| Question | Answer |
|---|---|
| Function | built in formula that helps you calculate or anlyaze data quickly in Excel |
| COUNT | Counts cells with numbers only |
| IF | Returns a result based on a condition |
| COUNTIF | Counts cells that meet multiple conditions |
| COUNTIFS | Counts cells that meet multiple conditions |
| SUMIF | Adds numbers that meet ONE condiiton |
| SUMIFS | Add numbers that meet multiple conditions |
| VLOOKUP | Looks for a value that meets multiple conditions |
| Cell Range | a collection of two or more selected cells in a spreadsheet program. |
| Workbook vs. Worksheet | A workbook is in the excel file itself, a worksheet is a single spreadsheet page within a workbook |