Match the Following Five Functions to Their Descriptions

question 23

Multiple Choice

Match the following five functions to their descriptions:
i.Flash Fill
II.Text Function
III.LEFT
IV.CONCATENATE
v.TRIM

• A)A text function that returns the specified number of characters from the beginning of a string of characters.
• B)A text function that can join up to 255 strings of characters.
• C)A function to combine or separate data,change case,and apply formatting to a string of characters.
• D)A text function to remove extra blank spaces from a string.
• E)A feature that predicts how to alter data based upon the pattern you enter into the cell at the beginning of the column.

---

Definitions:

Marketed Products

Goods or services that are actively promoted and sold to consumers through various marketing strategies.

Idea Generation

The creative process of coming up with new ideas, often the first step in the development of new products or strategies.

Rejecting Goods

The act of a buyer refusing to accept delivery of products or services because they do not meet the specified requirements or standards.

Services

Intangible actions or performances that one party can offer to another that does not result in the ownership of anything.