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 focuses only on the center of the screen

C.

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

D.

The eye reads data tables vertically first

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

A.

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

B.

To import custom visuals from the marketplace

C.

To generate the data model automatically

D.

To write DAX code manually

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

A.

Scatter Plot

B.

Card Visual

C.

Table

D.

Pie Chart

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

A.

Importing data from SQL

B.

Writing complex measures

C.

Formatting axis titles

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.

Donut Chart

B.

Line Chart

C.

Pie Chart

D.

Clustered Column Chart

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

A.

Showing proportions of a whole

B.

Visualizing trends over time

C.

Displaying a single number

D.

Comparing geographical density

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

A.

Modeling > New Parameter

B.

Get Data > Image

C.

Insert > Image

D.

Visualizations Pane > Image Chart

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

A.

Animate the data changes over time

B.

Drill down into the matrix

C.

Filter the data by the top 10 items

D.

Change the colors of the dots

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

A.

Funnel Chart

B.

Gauge Chart

C.

Area Chart

D.

Tree Map

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.

Pie Chart

D.

Waterfall Chart

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

A.

The Fields pane

B.

The Filters pane

C.

The Analytics pane (magnifying glass icon)

D.

The Format pane

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

A.

The visual must be a Pie Chart

B.

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

C.

The data must be categorical

D.

The data must contain negative values

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

A.

Tables are only for text

B.

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

C.

Matrices cannot display totals

D.

Tables can show pictures

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

A.

The latitude

B.

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

C.

The population density

D.

The geographic region area

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

A.

Filled Map (Choropleth)

B.

Scatter Chart

C.

Dot Map

D.

Shape 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 change the background color

D.

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

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

A.

Bookmarks

B.

Sync Slicers

C.

Selection Pane

D.

Drillthrough

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

A.

Basic Filtering

B.

Advanced Filtering

C.

Top N Filtering

D.

Drill-down

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.

Using only black and white

C.

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

D.

Making the text invisible

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

A.

Line Chart

B.

Scatter Plot

C.

Donut Chart

D.

KPI Visual

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

A.

Edit Interactions

B.

Group the visuals

C.

Lock the visual

D.

Hide the visual

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

A.

Forecasting future trends

B.

Displaying hierarchical data using nested rectangles

C.

Displaying a single text value

D.

Showing routes on a map

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

A.

Forecast

B.

Slicer

C.

Constant Line

D.

Trend Line

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

A.

Between

B.

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

C.

Before

D.

Text Search

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

A.

The matrix becomes a chart

B.

All data is shown in one column

C.

Sub-categories are indented below their parent category in a single 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.

Pie Chart

B.

Gauge

C.

Card

D.

Scatter Plot

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

A.

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

B.

To hold all the visual elements

C.

To publish the report

D.

To write SQL queries

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

A.

The Model View

B.

The Query Editor

C.

The Canvas

D.

The Ribbon

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.

Sort By Column

B.

Data Category

C.

Group Data

D.

Edit Interactions

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

A.

Slicer

B.

KPI Visual

C.

Card

D.

Gauge Chart

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

A.

The area where data is missing

B.

Empty space between visuals to reduce clutter and improve readability

C.

A formatting error

D.

The background color of the slicer

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

A.

Map and Table

B.

Line and Column

C.

Scatter and Bubble

D.

Pie and Donut

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 sorts the table alphabetically

C.

It deletes the text

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.

Report level filters

C.

Drillthrough filters

D.

Page level filters

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

A.

Change the page size

B.

Write a measure

C.

Use the 'Align' options in the Format tab

D.

Drag them roughly into place

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

A.

Filtering data

B.

Showing exact values in a grid

C.

Displaying a single percentage

D.

Showing rank changes between categories over time

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

A.

Slicer

B.

Basic Filtering

C.

Advanced Filtering

D.

Top N

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.

A tool to edit the data model

C.

The axis label

D.

The title of the chart

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

A.

Max Line

B.

Average Line

C.

Constant Line

D.

Min Line

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

A.

A scatter plot correlation

B.

Value, Goal, and Trend status

C.

A large table of data

D.

A map of locations

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

A.

Play a sound

B.

Change the font to Wingdings

C.

Insert a video

D.

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

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

A.

Pie Chart

B.

Card

C.

Decomposition Tree

D.

Line Chart

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

A.

The Filters Pane

B.

Format Pane > Slicer settings > Orientation

C.

Changing the data type

D.

It is not possible

45 $What is the 'Visual Header'?$

A.

The data source name

B.

The main title text inside the chart

C.

The page footer

D.

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

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

A.

To provide subtle branding or texturing without distracting from visuals

B.

To hide the data

C.

To increase file size

D.

To act as a slicer

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

A.

Heat Map Matrix

B.

Map Visual

C.

Scatter Plot

D.

Tree Map

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

A.

It refreshes the data

B.

It creates a new visual

C.

It copies formatting settings from one visual to another

D.

It paints the background red

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

A.

It changes the background color

B.

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

C.

It filters the data

D.

It adds a title

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

A.

No, backgrounds must be static colors

B.

Only if the visual is a Card

C.

Only in Excel, not Power BI

D.

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

Unit 5 - Practice Quiz