$6.$ M is a functional language, meaning that each line returns a new answer or table.

We can view and modify the code created from our drag$-$and$-$drop steps using the Advanced Query Editor. This is a great way to learn how both simple and complex functions are written. Use the Advanced Query Editor to explore the code from the exercises in this course. Which Power Query M functions are used to extract the first or last characters from a text string?

a$.$ Text.First$()$ & Text.Last$()$

b$.$ None of the above

c$.$ Text.Left$()$ & Text.Right$()$

d$.$ Text.Start$()$ & Text.End$()$