Clean function in power query is found in ------tab?Options :HomeTransformAdd columnView

In using Power Query, you notice that a field of data is not joining with data that appears the same. You have already removed trailing and leading spaces. What cleaning command should you consider next?

You have a filtered dataset for Customer Sales with some null value rows. You want to remove these rows completely. How will you do this?Select an answer:Deselect (null) in the pull-down menu for Customer Sales in the Power Query Editor.Change the filter so null value rows are not displayed.Place your cursor to the left of the rows, and then select Delete.Deselect (blank) in the pull-down menu for Customer Sales in the dataset.

What does Power Query use to change to what it determines is the appropriate data type? Select an answer:the headersthe first real row of datadata in the formula bar

Question 9The Power Query Editor allows you to ____ , ___ , and ____ data before loading it into Power BI. (Select all that apply.) 1 pointCreateSelectTransformEdit

James wants to perform an Append Query based on the column title in two tables and uses the merge query function in Power Query.Question 24Select one:a.Trueb.False