Excel Chapter 10 Vocabulary
TRIM
Removes spaces at the beginning and end of text
Arguments
The values that an Excel function uses to perform calculations or operations
Table
A range of cells in a worksheet that can be used by a lookup function
Table array
A table of text, numbers, or values used for VLOOKUP
SUMIFS
Adds the cells in a range that meet multiple criteria
SUMIF
Adds the cells specified by a given criteria
PROPER
Capitalizes the first letter in each word of text
IF
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
LOWER
Converts text to lowercase
UPPER
Converts text to uppercase
COUNTIFS
Counts the number of cells within a range that meet multiple criteria
COUNTIF
Counts the number of cells within a range that meet the given condition
Conditional formulas
Formulas that result in a logical value that is TRUE or FALSE and uses AND and OR functions
Lookup Functions
Functions used to find information stored in a table in an Excel worksheet
CONCATENTATE
Joins multiples texts into a sing text string
AND
Returns TRUE if all of its arguments are TRUE
OR
Returns TRUE if any argument is TRUE
MID
Returns a specific number of characters from a text string starting at the position you specify
RIGHT
Returns a specified number of characters starting from the end of a block of text
AVERAGEIFS
Returns the average (arithmetic mean) of all cells that meet multiple criteria
AVERAGEIF
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
LEFT
Returns the specified number of charters from the start of a text string
HLOOKUP
Searches across the first row of the lookup table
VLOOKUP
Searches down the first column of the lookup table
Sum_range
The cells to add if the corresponding row's cells in the Range match the criteria; if this is blank, use the Range for both the cells to ass and the cells to evaluate the criteria against
Range
The range of cells that you want the function to evaluate; also add the matched cells if the Sum_range is blank
Criteria
a number, text, or expression that tests which cells to sum, count, or average