click below
click below
Normal Size Small Size show me how
vocab part 5
vocab
| Question | Answer |
|---|---|
| Function | Function is a built-in Formula that helps you calculate or analyze data quickly in Excel |
| Count | Counts cells with numbers only |
| If | Returns a result based on a condition |
| Countif | Counts cells that meet ONE condition |
| Countifs | counts cells that meet MULTIPLE conditions |
| Sumif | Adds numbers that meet one condition |
| sumifs | Adds numbers that meet MULTIPLE conditions |
| Vlookup | Looks for a value in a table and returns matching data |
| Cell Range | A collection of two or more selected cells in a spreadsheet program. |
| Workbook vs Worksheet | A workbook is the Excel file itself, which can contain one or more worksheets. |