1In 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
Correct Answer: The eye scans from the top-left to top-right, then diagonally down, then across the bottom
Explanation:
The Z-pattern describes the natural route the human eye travels when viewing a screen, suggesting that key high-level insights should be placed at the top.
Incorrect! Try again.
2What 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
Correct Answer: To prototype the user journey and arrangement of visuals without software distractions
Explanation:
Sketching allows designers to plan the narrative and layout rapidly without getting bogged down by technical implementation details.
Incorrect! Try again.
3Which 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
Correct Answer: Card Visual
Explanation:
The Card visual is designed to display a single data point or aggregate value prominently.
Incorrect! Try again.
4When 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
Correct Answer: Managing the layering order (z-order) and visibility of objects
Explanation:
The Selection Pane allows you to control which visuals are on top of others and toggle their visibility.
Incorrect! Try again.
5Which 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
Correct Answer: Clustered Column Chart
Explanation:
Column charts are standard for comparing categorical data vertically.
Incorrect! Try again.
6What 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
Correct Answer: Visualizing trends over time
Explanation:
Line charts connect data points to show continuous change, making them ideal for time-series analysis.
Incorrect! Try again.
7Which 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
Correct Answer: Insert > Image
Explanation:
The Insert tab in the ribbon provides the option to add static elements like images, shapes, and text boxes.
Incorrect! Try again.
8In 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
Correct Answer: Animate the data changes over time
Explanation:
The Play Axis allows users to see how the relationship between variables changes over a time dimension.
Incorrect! Try again.
9Which 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
Correct Answer: Funnel Chart
Explanation:
Funnel charts display a process with sequential stages, where the width represents the value at each stage.
Incorrect! Try again.
10To 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
Correct Answer: Waterfall Chart
Explanation:
Waterfall charts show how an initial value is affected by a series of positive and negative values.
Incorrect! Try again.
11Where 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
Correct Answer: The Analytics pane (magnifying glass icon)
Explanation:
The Analytics pane contains statistical overlays like trend lines, average lines, and forecast lines.
Incorrect! Try again.
12What 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
Correct Answer: The x-axis must contain a continuous date/time field
Explanation:
Forecasting algorithms require a time-series element (continuous date axis) to predict future values.
Incorrect! Try again.
13What 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
Correct Answer: Matrices support row and column grouping (hierarchies) similar to PivotTables
Explanation:
A Matrix visual allows for multi-dimensional analysis with row and column headers, whereas a Table is a two-dimensional grid.
Incorrect! Try again.
14In 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
Correct Answer: A quantitative measure (e.g., Sales Amount)
Explanation:
In a Bubble Map, the size of the circle indicates the magnitude of the measure being analyzed.
Incorrect! Try again.
15Which 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
Correct Answer: Filled Map (Choropleth)
Explanation:
Filled Maps color the entire area of a geographic region based on data intensity.
Incorrect! Try again.
16What 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
Correct Answer: To allow users to filter the data displayed on the report page interactively
Explanation:
Slicers are on-canvas visual filters that let users narrow down the portion of the dataset being shown.
Incorrect! Try again.
17Which option allows a single slicer to filter visuals across multiple pages of a report?
A.Bookmarks
B.Sync Slicers
C.Selection Pane
D.Drillthrough
Correct Answer: Sync Slicers
Explanation:
The Sync Slicers pane allows a designer to synchronize slicer selections across different report pages.
Incorrect! Try again.
18Which 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
Correct Answer: Top N Filtering
Explanation:
Top N filtering allows you to filter for the top or bottom number of items based on a specific measure.
Incorrect! Try again.
19Conditional 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
Correct Answer: Background color, font color, data bars, and icons
Explanation:
Power BI allows extensive conditional formatting on cell backgrounds, fonts, and the addition of visual indicators like bars and icons.
Incorrect! Try again.
20What 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
Correct Answer: Using a three-color scale (e.g., Red, Yellow, Green) to represent low, middle, and high values
Explanation:
Diverging color scales allow you to define a center point, distinguishing effectively between negative/low and positive/high values.
Incorrect! Try again.
21Which 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
Correct Answer: Donut Chart
Explanation:
Donut (and Pie) charts are specifically designed to show how a whole is divided into parts.
Incorrect! Try again.
22How 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
Correct Answer: Edit Interactions
Explanation:
The 'Edit Interactions' feature allows you to define how visuals influence each other, including disabling filtering for specific visuals.
Incorrect! Try again.
23What 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
Correct Answer: Displaying hierarchical data using nested rectangles
Explanation:
Tree Maps display data as a set of nested rectangles, where the size and color represent data values.
Incorrect! Try again.
24If 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
Correct Answer: Constant Line
Explanation:
A Constant Line in the Analytics pane allows you to draw a straight line at a specific value (e.g., a target or benchmark).
Incorrect! Try again.
25Which 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
Correct Answer: Text Search
Explanation:
While text slicers have search, date slicers specifically offer Between, Before, After, List, Dropdown, and Relative options.
Incorrect! Try again.
26What 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
Correct Answer: Sub-categories are indented below their parent category in a single column
Explanation:
Stepped layout places child rows underneath parent rows in the same column, saving horizontal space.
Incorrect! Try again.
27To 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
Correct Answer: Scatter Plot
Explanation:
Scatter plots plot two numerical values against each other on X and Y axes to reveal correlations.
Incorrect! Try again.
28What 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
Correct Answer: To manage filters applied to the visual, page, or entire report
Explanation:
The Filters Pane provides a centralized location to view and modify the scope of data filtering at three different levels.
Incorrect! Try again.
29What acts as a container for visuals in Power BI?
A.The Model View
B.The Query Editor
C.The Canvas
D.The Ribbon
Correct Answer: The Canvas
Explanation:
The report canvas is the blank area where visuals are placed and arranged.
Incorrect! Try again.
30Which 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
Correct Answer: Data Category
Explanation:
Setting the Data Category (e.g., Address, City, Country) helps Bing Maps correctly identify locations.
Incorrect! Try again.
31Which visual is effectively a speedometer used to show progress toward a goal?
A.Slicer
B.KPI Visual
C.Card
D.Gauge Chart
Correct Answer: Gauge Chart
Explanation:
Gauge charts use a circular arc to display a single value within the context of a goal or target.
Incorrect! Try again.
32When 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
Correct Answer: Empty space between visuals to reduce clutter and improve readability
Explanation:
White space is a crucial design element that prevents the report from looking crowded and helps the user focus.
Incorrect! Try again.
33In 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
Correct Answer: Line and Column
Explanation:
Combo charts (Line and Stacked/Clustered Column) allow you to view two different measures with different scales on the same visual.
Incorrect! Try again.
34What 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
Correct Answer: It adds a bar chart inside the cell to visualize the magnitude of the value
Explanation:
Data bars provide a quick visual comparison of values directly within the table grid without needing a separate chart.
Incorrect! Try again.
35Which 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
Correct Answer: Report level filters
Explanation:
Report level filters (Filters on all pages) restrict data across the entire .pbix file.
Incorrect! Try again.
36How 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
Correct Answer: Use the 'Align' options in the Format tab
Explanation:
The Format tab offers Align (Left, Center, Top, Distribute) tools to organize visuals precisely.
Incorrect! Try again.
37What 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
Correct Answer: Showing rank changes between categories over time
Explanation:
Ribbon charts connect categories across time periods, highlighting which category has the highest rank (value) at any given time.
Incorrect! Try again.
38If 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
Correct Answer: Advanced Filtering
Explanation:
Advanced filtering provides logical operators like 'Contains', 'Starts with', and 'Is not blank'.
Incorrect! Try again.
39In 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
Correct Answer: A box that appears with details when you hover over a data point
Explanation:
Tooltips provide additional context or granular data when a user hovers their mouse over a specific part of a visual.
Incorrect! Try again.
40Which analytics line indicates the arithmetic mean of the data displayed?
A.Max Line
B.Average Line
C.Constant Line
D.Min Line
Correct Answer: Average Line
Explanation:
The Average Line calculates the mean of the data points currently visible in the chart.
Incorrect! Try again.
41What 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
Correct Answer: Value, Goal, and Trend status
Explanation:
The KPI visual shows a current value, a target goal, and a trend indicator (often colored red/green) to show performance history.
Incorrect! Try again.
42You 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
Correct Answer: Display symbols (arrows, flags) indicating if data is above or below a threshold
Explanation:
Icon sets allow for quick visual cues (like up/down arrows) to indicate status directly in tables or matrices.
Incorrect! Try again.
43Which 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
Correct Answer: Decomposition Tree
Explanation:
The Decomposition Tree allows users to visualize data across multiple dimensions, aggregating data and drilling down into it in any order.
Incorrect! Try again.
44What 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
Correct Answer: Format Pane > Slicer settings > Orientation
Explanation:
Changing a slicer's orientation to Horizontal creates a button-like interface often used for headers or touch-friendly reports.
Incorrect! Try again.
45What 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
Correct Answer: The set of icons (filters, focus mode, drill) that appear above a visual when hovered
Explanation:
The Visual Header contains utility icons for the end-user, such as drill down, focus mode, and viewing underlying data.
Incorrect! Try again.
46Why 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
Correct Answer: To provide subtle branding or texturing without distracting from visuals
Explanation:
Using high transparency allows the background to add aesthetic value (branding/structure) without making the data hard to read.
Incorrect! Try again.
47Which chart type requires a 'Location' field or 'Latitude/Longitude' fields?
A.Heat Map Matrix
B.Map Visual
C.Scatter Plot
D.Tree Map
Correct Answer: Map Visual
Explanation:
Map visuals rely on geospatial data points to plot information correctly on the earth's surface.
Incorrect! Try again.
48What 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
Correct Answer: It copies formatting settings from one visual to another
Explanation:
Similar to Excel or Word, Format Painter copies style attributes (colors, fonts, borders) to maintain consistency.
Incorrect! Try again.
49When 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
Correct Answer: It creates a separate line for each category in the legend field
Explanation:
Adding a field to the Legend bucket splits the single line into multiple lines, one for each unique value in that field.
Incorrect! Try again.
50Can 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
Correct Answer: Yes, using the 'fx' (function) button in formatting options
Explanation:
The 'fx' button allows dynamic styling where the color changes programmatically based on data values (conditional formatting).