Chapter 11 - Additional Specialized Functions Flashcards
A text function that** combines text strings and required seprate argument for each delimiter to include the combined text**.
CONCAT Function
A text function that combines text string and insert delimiter you specify in the first argument.
TEXTJOIN Function
A text function that capitalizes the first letter of each word in a text string.
PROPER Function
Range of cells that contains the list of records from a dataset that meets the specified conditions.
Output range
Databased function that i**dentifies the lowest value in a column **that mathces the specified function in a criteria range.
DMIN Function
Function that searches through a range for a specific value and returns the relative position of that value within the range.
MATCH Function
A text function that converts text strings to all capital letters.
UPPER Function
Databased function that adds the values in a column that matches conditions specified in a criteria range.
DSUM Function
Function that retuns a value at the intersection of a specified row and column within a given rage.
INDEX Function
Database function that counts the cells that contains number in a column that mathces specificed conditions in a criteria range.
DCOUNT Function
A text function that extracts the characters from the middle of a text string, given a strarting position and length.
MID Function
A text function that converts a tect string to all lowercase letters.
LOWER Function
A set of function that provides statistical calculations for a data base.
Database function
A database function determies the average of values ina column that mathces condition specificed in a criteria range.
DAVERAGE Function
A function that returns the text version of a formula stored in another cell
FORMULATEXT Function
A function that rearranges data from column to rows and rows to column.
TRANSPOSE function
Database that identifies the highest values ina column that mathces specified conditions ina criteria range.
DMAX Function
A range of 2 or more adjacent cells that specifies the condititions used to control the result of a filter.
Criteria range
A text function that extracts the specified number of characters from the right side of a text string.
RIGHT Function
A text function that extracts a specified number of characters from the left side of a
text string.
LEFT Function
