click below
click below
Normal Size Small Size show me how
Excel vocab
Digitools vocab 7
| Term | Definition |
|---|---|
| Function | is a built in formula that helps you calculate or analyze data quickly in Excel. All functions start with =. Functions use parentheses. |
| COUNT | Counts cells with numbers only. =COUNT(A1:A10) |
| IF | Returns a result based on a condition. =IF(A1>=60, "Pass", "Fail") |
| COUNTIF | Counts cells that meet ONE condition. =COUNTIFS(A1:A10, ">=70", B1:B10, "Yes") |
| COUNTIFS | |
| SUMIF | |
| SUMIFS | |
| VLOOKUP |