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
