Question 1

How can you merge columns in Power BI?

Accepted Answer

Using the Merge Columns option in the Transform tab

Answer

Using the Concatenate function in the formula bar

Answer

Selecting the columns and right-clicking

Answer

Using the Filter option in the Home tab

Question 2

What can you use as a separator when merging columns?

Accepted Answer

A space, comma, colon, equal sign, or custom text

Answer

Line break

Answer

Nothing

Answer

Specific delimiter based on data type

Question 3

How do you select multiple non-contiguous columns in Power BI?

Accepted Answer

Hold the Ctrl key while clicking on the columns

Answer

Use the Shift key to select multiple columns

Answer

Use the Select All option

Answer

Drag the mouse to select the columns

Question 4

What is the name of the table used in this video as an example?

Accepted Answer

Employees

Answer

Sales

Answer

Customers

Answer

Orders

Question 5

How do you access the Power Query Editor in Power BI Desktop?

Accepted Answer

Click on Transform Data in the Home tab

Answer

Click on the table name in the Fields pane

Answer

Right-click on the table and select Edit in Power Query Editor

Answer

Go to the Data tab and select Transform Data

Question 6

What database is used as the data source in this video?

Accepted Answer

SQL Server (Optional)

Answer

Access

Answer

Excel

Answer

Text file

Question 7

What does clicking OK after selecting a table in the import process do?

Accepted Answer

Imports the selected table into Power BI

Answer

Refreshes the data in the table

Answer

Deletes the selected table

Answer

Creates a new calculated column

Question 8

What is the purpose of merging columns in Power BI?

Accepted Answer

To combine the data from multiple columns into a single column

Answer

To separate the data in a single column into multiple columns

Answer

To sort data by multiple columns

Answer

To filter data based on multiple columns

Question 9

Which of the following is NOT a valid way to select two columns in Power BI to be merged?

Accepted Answer

Clicking on one column header and then another

Answer

Right-clicking on one column header and selecting "Select All"

Answer

Using the navigation pane to select both columns

Answer

Using the Ctrl key and clicking on both column headers

Question 10

What happens when you rename a merged column in Power BI?

Accepted Answer

The name of the column is updated throughout the report

Answer

Only the name displayed in the Fields pane is updated

Answer

The formatting of the column is applied

Answer

The data in the column is changed

Related quizzes

Related quizzes