Excel Quiz 05 – BI Analyst – Power Query + Power BI Dashboard

What does the “Pivot Column” function do in Power Query?

1. Turns rows into columns based on unique values
2. Transposes data rows and columns
3. Groups data by categories
4. Merges multiple columns into one

Which component of Power BI is used for creating and sharing reports and dashboards online?

1. Power BI Desktop
2. Power BI Service
3. Power BI Report Builder
4. Power BI Mobile

Which of the following actions can be performed in Power Query Editor?

1. Add Calculated Columns
2. Transform Data Types
3. Create Reports
4. Publish Dashboards

Which data source can provide real-time data to Power BI dashboards?

1. CSV files
2. Google Sheets
3. Streaming data sources
4. PDF files

To fill empty cells in a column with the value above it, which function is used in Power Query?

1. Fill Down
2. Replace Empty
3. Group By
4. Fill Up

What is a primary key in a Power BI data model?

1. A unique identifier for each row in a table
2. A calculated column
3. A visualization tool
4. A field for sorting

What does the “Group By” function achieve in Power Query?

1. Aggregates data based on selected columns
2. Splits data by groups
3. Filters out data groups
4. Adds group labels

The DAX function “RELATED” is primarily used to:

1. Filter columns
2. Retrieve values from related tables
3. Aggregate values
4. Join tables

What type of relationship is most common in Power BI data models?

1. One-to-One
2. Many-to-Many
3. One-to-Many
4. One-to-Multiple

What is the first step in connecting Power BI to a data source?

1. Use the visualization pane
2. Select “Get Data”
3. Build a report
4. Select “Publish”

In Power BI, a slicer is used to:

1. Sort data
2. Filter data interactively
3. Create pivot tables
4. Adjust data types

What is the primary function of the Power Query Editor?

1. To perform calculations
2. To clean and transform data
3. To visualize data
4. To export data

What happens if you ‘Merge Queries’ in Power Query with a left outer join?

1. All rows from the left table are included, along with matching rows from the right table
2. Only rows with matches in both tables are included
3. Rows from the right table are included, regardless of matches in the left table
4. None of the rows are included

In Power BI, what is the purpose of data modeling?

1. Transforming raw data into a structured format
2. Creating visuals from data
3. Preparing a report
4. Combining and structuring data for relationships and analysis

Which function is used in DAX to create conditional calculations similar to an IF statement?

1. SWITCH
2. CASE
3. CONDITIONAL
4. TEST

Unpivoting a column in Power Query is used to:

1. Group rows by columns
2. Create unique column values
3. Transform columns into rows
4. Remove duplicates

Which option is used to import data from an Excel file in Power Query?

1. Get & Transform
2. Insert
3. Open
4. Tools

To export transformed data to a CSV file in Excel, which step should be followed?

1. Select data, right-click, choose Export
2. File > Save As > CSV
3. Use Export option in Power Query
4. Use Close & Load, then save as CSV

Which tool in Power BI is used to clean and transform data?

1. Data Model
2. Power Query Editor
3. Fields Pane
4. Visualization Pane

What does the “Group By” function do in Power Query?

1. Summarizes data based on a specified field
2. Combines data from different tables
3. Filters data based on conditions
4. Duplicates data

What does ‘Replace Errors’ in Power Query allow you to do?

1. Remove error rows
2. Replace cells with valid data or a default value
3. Delete all error values from the dataset
4. Ignore errors in the data transformation

The Power BI ecosystem consists of which of the following?

1. Power BI Desktop, Power BI Service, Power BI Mobile
2. Power BI Report Builder and Data Lake
3. Excel and Power BI
4. Power BI Desktop and SQL Server

How do you add a custom column in Power Query?

1. Home > New Column
2. Insert > Custom Column
3. Add Column > Custom Column
4. Data > Add Column

What does DAX stand for in Power BI?

1. Data Analysis Expressions
2. Data Aggregation XML
3. Data and Analysis Expressions
4. Dynamic Analytics Expressions

Which feature in Power BI allows you to view relationships between tables?

1. Query Editor
2. Data Model
3. Visualization Pane
4. Fields Pane

What is the purpose of the “Append Queries” function?

1. To split one table into multiple tables
2. To merge data from two or more queries
3. To add a new column
4. To update values in a query

DAX expressions are typically used for:

1. Creating calculated columns and measures
2. Importing data
3. Managing relationships
4. Building dashboards

Which feature allows you to keep specific rows based on conditions?

1. Filter Rows
2. Sort Rows
3. Split Column
4. Aggregate Values

What is the purpose of a lookup table in data modeling?

1. To store calculated values
2. To filter data
3. To serve as a reference table for creating relationships
4. To sort data

Which view allows you to create relationships between tables in Power BI Desktop?

1. Data View
2. Model View
3. Report View
4. Power Query