POWER BI QUIZ QUESTIONS

Which option in Power Query Editor is used to rename columns?

• A) Edit Column

• B) Rename Columns

• C) Remove Columns

• D) Split Column

What is the primary purpose of data cleaning in Power BI?

• A) To make the data visually appealing

• B) To remove errors and inconsistencies in the data

• C) To increase the size of the dataset

• D) To enhance data security

Which Power BI tool is commonly used for data cleaning and transformations?

• A) Power Query Editor

• B) Power Pivot

• C) Power View

• D) Power Map

Which transformation in Power Query Editor is used to unpivot columns into rows?

• A) Pivot Columns

• B) Unpivot Columns

• C) Merge Columns

• D) Split Column

Which transformation in Power Query Editor is used to split a column into multiple columns based on a delimiter?

• A) Split Column

• B) Merge Columns

• C) Remove Columns

• D) Replace Values

What does the "Fill Down" option do in Power Query Editor?

• A) Fills empty cells with the value from the cell above

• B) Deletes empty cells from the dataset

• C) Fills cells with a predefined value

• D) Sums up the values in the cells

Which step in Power Query Editor allows you to remove duplicate rows from your dataset?

• A) Remove Rows

• B) Remove Duplicates

• C) Filter Rows

• D) Remove Errors

Which Power BI feature helps in detecting and removing errors in the dataset?

• A) Data Model

• B) Relationships

• C) Data Profiling

• D) Data Visualization

Which transformation in Power Query Editor is used to merge data from multiple tables?

• A) Merge Queries

• B) Append Queries

• C) Merge Columns

• D) Remove Columns

What is the purpose of the "Change Type" transformation in Power Query Editor?

• A) To change the font type of the text in a column

• B) To change the data type of a column

• C) To change the color of the data in a column

• D) To change the alignment of the data in a column