Why is the Trim option in text-specific tools an important tool?

Select an answer:

It turns text in a column to more valuable abbreviations.

It gets rid of blank spaces before or after text.

It narrows the width of a column containing text.

It gets rid of blank spaces between words or letters in text.

You have connected to a data source, you have applied changes to the Query Editor, and now you need to load the data from Power Query into Excel. What options do you have?

Select an answer:

• all of these answers

• Table

• Add to Data Model

• Connection Only

Quarterly sales bonuses are based on order amount by customer. How would you set up conditional statements to return No_Bonus, Bonus, and Extra-Bonus?

Select an answer:

• Use two If statements, and then use an Else-If statement.

• Use an If statement, use an Else statement, and then place a value in Otherwise.

• Use an If statement, and then use two Else-If statements.

• Use an If statement, use an Else-If statement, and then use another If statement.