Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
vocan4
| Question | Answer |
|---|---|
| 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 a. Ex. =COUNT(A1:A10) |
| if | - Returns a result based on a condition a. =IF(A1>=60,“Pass”,“Fail”) |
| countif | Counts cells that meet ONE condition a. Ex. =COUNTIF(A1:A10,“>=70”) |
| countifs | - Counts cells that meet MULTIPLE conditions a. Ex. =COUNTIFS(A1:A10,“>=70”, B1:B10,“Yes”) |
| sumif | - Adds numbers that meet ONE condition a. Ex. =SUMIF(A1:A10,“>=70”) |
| sumifs | - Adds numbers that meet MULTIPLE conditions a. Ex. =SUMIFS(A1:A10, B1:B10,“Yes”) |
| vlookup | - Looks for a value in a table and returns matching data a. Ex. =VLOOKUP(A2, A1:C10, 3, FALSE) |
| cell range | - a collection of two or more selected cells in a spreadsheet program. A group of contiguous or non-contiguous cells forming a block or selection. a. You can name cell ranges once selected in the top left, just remember to click enter after naming your |
| workbook vs worksheet | – A Workbook is the Excel file itself, which can contain one or more worksheets. A worksheet is a single spreadsheet page within a workbook, often referred to as a "sheet". |
Created by:
29kcannon