Term | Definition |
Convert range to table | This alternative will give you access to additional features not available in a cell range. |
Begins with Da | To find all girls named Darla, Danna, and Dana, apply this filter. |
Ends with son | To find all students whose names end with "son", apply this filter. |
Use filter Contains: Day Camp, Overnight Camp or Nature Camp | To find anyone whose camp is either Day Camp, Overnight Camp or Nature Camp. |
Count | If you want to work with non numeric data in your pivot table, what function would you use? |
TRUE | Evaluate the formula =AND(G2="FT",M2>=1). What value is returned assuming G2 contains the value"FT" and M2 contains the value "2"? |
FALSE | Evaluate the formula =AND(G2="FT",M2>=1). What value is returned assuming that G2 contains the value "PT" and M2 contains the value "2" |
If you entered a letter for the col_index_num instead of a number what would happen? | You would get the #VALUE! error as the result of the formula typo. |
#N/A | This error value means that a value is not available to a function or formula |
SUMIF | This function adds the value in a range that match criteria you specify. |
AVERAGEIF | This function calculates the average of values in a range that match criteria you specify. |
COUNTIF | This function calculates the number of cells in a range that match criteria you specify. |
organized | The major difference between HLOOKUP and VLOOKUP functions is the way the lookup tables are: |
VLOOKUP | You can use this function to return a value from a table that is based on an approximate match lookup. |
AND | You could test two or more conditions and determine whether all condition are true using this function. |
| If you use the name box to name a range of cells, that can be managed |