1 $In the context of Dashboard Design Framework, what is the 'Z-pattern' regarding reading flow?$

A.

The eye scans from the bottom-left to top-right

B.

The eye scans from the top-left to top-right, then diagonally down, then across the bottom

C.

The eye reads data tables vertically first

D.

The eye focuses only on the center of the screen

2 $What is the primary purpose of sketching a dashboard layout before building it in Power BI?$

A.

To write DAX code manually

B.

To prototype the user journey and arrangement of visuals without software distractions

C.

To generate the data model automatically

D.

To import custom visuals from the marketplace

3 $Which Power BI object is best suited for displaying a single key performance indicator (KPI), such as 'Total Revenue'?$

A.

Table

B.

Pie Chart

C.

Card Visual

D.

Scatter Plot

4 $When designing a report page, where is the 'Selection Pane' most useful?$

A.

Formatting axis titles

B.

Importing data from SQL

C.

Writing complex measures

D.

Managing the layering order (z-order) and visibility of objects

5 $Which visual type is most effective for comparing values across different categories using vertical bars?$

A.

Pie Chart

B.

Donut Chart

C.

Clustered Column Chart

D.

Line Chart

6 $What is a primary use case for a Line Chart in Power BI?$

A.

Comparing geographical density

B.

Showing proportions of a whole

C.

Displaying a single number

D.

Visualizing trends over time

7 $Which feature would you use to add a static image, such as a company logo, to a report?$

A.

Get Data > Image

B.

Insert > Image

C.

Visualizations Pane > Image Chart

D.

Modeling > New Parameter

8 $In a Scatter Chart, what does the 'Play Axis' feature allow you to do?$

A.

Filter the data by the top 10 items

B.

Animate the data changes over time

C.

Change the colors of the dots

D.

Drill down into the matrix

9 $Which visual is best suited for analyzing the stages of a sales process or pipeline?$

A.

Funnel Chart

B.

Tree Map

C.

Area Chart

D.

Gauge Chart

10 $To display a running total or explain the change in a value from a starting point to an ending point, which chart is ideal?$

A.

Ribbon Chart

B.

Scatter Chart

C.

Waterfall Chart

D.

Pie Chart

11 $Where can you add a Trend Line to a Line Chart?$

A.

The Format pane

B.

The Fields pane

C.

The Analytics pane (magnifying glass icon)

D.

The Filters pane

12 $What is a prerequisite for using the 'Forecast' feature in the Analytics pane?$

A.

The data must contain negative values

B.

The visual must be a Pie Chart

C.

The x-axis must contain a continuous date/time field

D.

The data must be categorical

13 $What is the main difference between a Table visual and a Matrix visual?$

A.

Tables can show pictures

B.

Tables are only for text

C.

Matrices cannot display totals

D.

Matrices support row and column grouping (hierarchies) similar to PivotTables

14 $In a Map visual, what does the size of the bubble usually represent?$

A.

The geographic region area

B.

The population density

C.

A quantitative measure (e.g., Sales Amount)

D.

The latitude

15 $Which map visual is used to shade geographic regions (like states or countries) based on a data value?$

A.

Scatter Chart

B.

Shape Map

C.

Filled Map (Choropleth)

D.

Dot Map

16 $What is the primary function of a Slicer in a report?$

A.

To permanently delete data

B.

To sort the data alphabetically

C.

To allow users to filter the data displayed on the report page interactively

D.

To change the background color

17 $Which option allows a single slicer to filter visuals across multiple pages of a report?$

A.

Sync Slicers

B.

Bookmarks

C.

Drillthrough

D.

Selection Pane

18 $Which filter type would you use to show only the 5 products with the highest sales?$

A.

Drill-down

B.

Advanced Filtering

C.

Basic Filtering

D.

Top N Filtering

19 $Conditional Formatting can be applied to which aspects of a Table or Matrix?$

A.

Only the font style

B.

Only the column width

C.

Background color, font color, data bars, and icons

D.

The query dependencies

20 $What does 'Diverging' colors mean in the context of Conditional Formatting?$

A.

Using random colors

B.

Making the text invisible

C.

Using a three-color scale (e.g., Red, Yellow, Green) to represent low, middle, and high values

D.

Using only black and white

21 $Which visual is best for showing part-to-whole relationships where the total is 100%?$

A.

Line Chart

B.

Scatter Plot

C.

KPI Visual

D.

Donut Chart

22 $How can you prevent a specific visual from being affected by a Slicer selection?$

A.

Hide the visual

B.

Group the visuals

C.

Edit Interactions

D.

Lock the visual

23 $What is a 'Tree Map' used for?$

A.

Showing routes on a map

B.

Forecasting future trends

C.

Displaying hierarchical data using nested rectangles

D.

Displaying a single text value

24 $If you want to add a reference line to a chart indicating a target goal of 50%, which feature should you use?$

A.

Trend Line

B.

Slicer

C.

Constant Line

D.

Forecast

25 $Which of the following is NOT a standard option for a Date Slicer?$

A.

Relative Date (e.g., Last 30 Days)

B.

Text Search

C.

Before

D.

Between

26 $What happens when you enable 'Stepped layout' in a Matrix visual?$

A.

Sub-categories are indented below their parent category in a single column

B.

The matrix becomes a chart

C.

All data is shown in one column

D.

The colors change to a gradient

27 $To visualize the correlation between two numerical variables (e.g., Sales vs. Discount), which chart is best?$

A.

Card

B.

Gauge

C.

Scatter Plot

D.

Pie Chart

28 $What is the purpose of the 'Filters Pane' in the Report View?$

A.

To write SQL queries

B.

To publish the report

C.

To hold all the visual elements

D.

To manage filters applied to the visual, page, or entire report

29 $What acts as a container for visuals in Power BI?$

A.

The Ribbon

B.

The Query Editor

C.

The Model View

D.

The Canvas

30 $Which feature allows you to categorize geographic data (e.g., telling Power BI that a column contains 'City' names) to improve map accuracy?$

A.

Edit Interactions

B.

Data Category

C.

Sort By Column

D.

Group Data

31 $Which visual is effectively a speedometer used to show progress toward a goal?$

A.

Card

B.

KPI Visual

C.

Gauge Chart

D.

Slicer

32 $When designing a dashboard, what is 'White Space' (Negative Space)?$

A.

The area where data is missing

B.

The background color of the slicer

C.

Empty space between visuals to reduce clutter and improve readability

D.

A formatting error

33 $In a Combined (Combo) chart, what two chart types are typically mixed?$

A.

Pie and Donut

B.

Line and Column

C.

Map and Table

D.

Scatter and Bubble

34 $What is the benefit of using 'Data Bars' in a Table visual?$

A.

It adds a bar chart inside the cell to visualize the magnitude of the value

B.

It deletes the text

C.

It sorts the table alphabetically

D.

It turns the table into a map

35 $Which filtering scope applies to every page in the Power BI file?$

A.

Visual level filters

B.

Drillthrough filters

C.

Page level filters

D.

Report level filters

36 $How do you align multiple visuals perfectly on a page?$

A.

Drag them roughly into place

B.

Change the page size

C.

Use the 'Align' options in the Format tab

D.

Write a measure

37 $What is a 'Ribbon Chart' useful for?$

A.

Showing rank changes between categories over time

B.

Displaying a single percentage

C.

Showing exact values in a grid

D.

Filtering data

38 $If you want to filter a visual based on whether a text field contains specific words, which filter type do you use?$

A.

Advanced Filtering

B.

Slicer

C.

Top N

D.

Basic Filtering

39 $In the context of visuals, what is a 'Tooltip'?$

A.

A box that appears with details when you hover over a data point

B.

The title of the chart

C.

A tool to edit the data model

D.

The axis label

40 $Which analytics line indicates the arithmetic mean of the data displayed?$

A.

Average Line

B.

Constant Line

C.

Min Line

D.

Max Line

41 $What is the 'KPI' (Key Performance Indicator) visual specifically designed to show?$

A.

A map of locations

B.

A scatter plot correlation

C.

A large table of data

D.

Value, Goal, and Trend status

42 $You can use 'Icons' in conditional formatting to:$

A.

Play a sound

B.

Change the font to Wingdings

C.

Display symbols (arrows, flags) indicating if data is above or below a threshold

D.

Insert a video

43 $Which visual is commonly used to break down a measure by contributions of different factors (e.g., Variance Analysis)?$

A.

Line Chart

B.

Decomposition Tree

C.

Pie Chart

D.

Card

44 $What allows you to change the orientation of a Slicer from a vertical list to horizontal buttons?$

A.

Format Pane > Slicer settings > Orientation

B.

The Filters Pane

C.

Changing the data type

D.

It is not possible

45 $What is the 'Visual Header'?$

A.

The main title text inside the chart

B.

The set of icons (filters, focus mode, drill) that appear above a visual when hovered

C.

The data source name

D.

The page footer

46 $Why might you use a 'Background Image' on a report page with high transparency?$

A.

To hide the data

B.

To increase file size

C.

To act as a slicer

D.

To provide subtle branding or texturing without distracting from visuals

47 $Which chart type requires a 'Location' field or 'Latitude/Longitude' fields?$

A.

Scatter Plot

B.

Tree Map

C.

Map Visual

D.

Heat Map Matrix

48 $What is the function of the 'Format Painter' tool in Power BI Desktop?$

A.

It creates a new visual

B.

It paints the background red

C.

It copies formatting settings from one visual to another

D.

It refreshes the data

49 $When configuring a Line Chart, what does the 'Legend' field do?$

A.

It filters the data

B.

It creates a separate line for each category in the legend field

C.

It adds a title

D.

It changes the background color

50 $Can you format the background color of a visual based on a measure value (e.g., Sales)?$

A.

Only if the visual is a Card

B.

Only in Excel, not Power BI

C.

No, backgrounds must be static colors

D.

Yes, using the 'fx' (function) button in formatting options

Unit 5 - Practice Quiz