Back to Subject

Unit 5: Designing and Enhancing Visual Reports - Practice Quiz

INT374 — Data Analytics With Power Bi 50 Questions
0 Correct 0 Wrong 50 Left
0/50

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

A. The eye reads data tables vertically first
B. The eye scans from the top-left to top-right, then diagonally down, then across the bottom
C. The eye scans from the bottom-left to top-right
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 prototype the user journey and arrangement of visuals without software distractions
B. To generate the data model automatically
C. To write DAX code manually
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. Pie Chart
B. Card Visual
C. Scatter Plot
D. Table

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

A. Formatting axis titles
B. Managing the layering order (z-order) and visibility of objects
C. Importing data from SQL
D. Writing complex measures

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

A. Pie Chart
B. Line Chart
C. Clustered Column Chart
D. Donut Chart

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

A. Showing proportions of a whole
B. Comparing geographical density
C. Visualizing trends over time
D. Displaying a single number

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

A. Insert > Image
B. Visualizations Pane > Image Chart
C. Modeling > New Parameter
D. Get Data > Image

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. Drill down into the matrix
C. Change the colors of the dots
D. Animate the data changes over time

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

A. Area Chart
B. Tree Map
C. Funnel 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. Waterfall Chart
B. Scatter Chart
C. Pie Chart
D. Ribbon Chart

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

A. The Filters pane
B. The Fields 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 x-axis must contain a continuous date/time field
B. The visual must be a Pie Chart
C. The data must contain negative values
D. The data must be categorical

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

A. Tables are only for text
B. Tables can show pictures
C. Matrices support row and column grouping (hierarchies) similar to PivotTables
D. Matrices cannot display totals

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

A. A quantitative measure (e.g., Sales Amount)
B. The population density
C. The latitude
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. Shape Map
C. Scatter Chart
D. Dot Map

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

A. To allow users to filter the data displayed on the report page interactively
B. To sort the data alphabetically
C. To permanently delete data
D. To change the background color

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

A. Drillthrough
B. Selection Pane
C. Sync Slicers
D. Bookmarks

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

A. Advanced Filtering
B. Basic 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 column width
B. The query dependencies
C. Only the font style
D. Background color, font color, data bars, and icons

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

A. Making the text invisible
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. Using random colors

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

A. Scatter Plot
B. KPI Visual
C. Line Chart
D. Donut Chart

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

A. Hide the visual
B. Edit Interactions
C. Group the visuals
D. Lock the visual

23 What is a 'Tree Map' used for?

A. Displaying hierarchical data using nested rectangles
B. Forecasting future trends
C. Showing routes on a map
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. Slicer
B. Forecast
C. Constant Line
D. Trend Line

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

A. Text Search
B. Relative Date (e.g., Last 30 Days)
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 colors change to a gradient
C. All data is shown in one column
D. The matrix becomes a chart

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

A. Pie Chart
B. Scatter Plot
C. Card
D. Gauge

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

A. To hold all the visual elements
B. To write SQL queries
C. To publish the report
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 Canvas
B. The Query Editor
C. The Ribbon
D. The Model View

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. Group Data
C. Edit Interactions
D. Data Category

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

A. Card
B. Slicer
C. Gauge Chart
D. KPI Visual

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

A. The background color of the slicer
B. The area where data is missing
C. A formatting error
D. Empty space between visuals to reduce clutter and improve readability

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

A. Line and Column
B. Pie and Donut
C. Scatter and Bubble
D. Map and Table

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

A. It deletes the text
B. It adds a bar chart inside the cell to visualize the magnitude of the value
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. Report level filters
B. Drillthrough filters
C. Page level filters
D. Visual level filters

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

A. Write a measure
B. Drag them roughly into place
C. Change the page size
D. Use the 'Align' options in the Format tab

37 What is a 'Ribbon Chart' useful for?

A. Filtering data
B. Showing rank changes between categories over time
C. Showing exact values in a grid
D. Displaying a single percentage

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

A. Top N
B. Slicer
C. Basic Filtering
D. Advanced Filtering

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

A. A tool to edit the data model
B. A box that appears with details when you hover over a data point
C. The title of the chart
D. The axis label

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

A. Average Line
B. Max Line
C. Min Line
D. Constant Line

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

A. A scatter plot correlation
B. A large table of data
C. A map of locations
D. Value, Goal, and Trend status

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

A. Change the font to Wingdings
B. Insert a video
C. Play a sound
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. Decomposition Tree
B. Card
C. Line Chart
D. Pie Chart

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

A. Changing the data type
B. Format Pane > Slicer settings > Orientation
C. It is not possible
D. The Filters Pane

45 What is the 'Visual Header'?

A. The data source name
B. The set of icons (filters, focus mode, drill) that appear above a visual when hovered
C. The page footer
D. The main title text inside the chart

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

A. To act as a slicer
B. To provide subtle branding or texturing without distracting from visuals
C. To increase file size
D. To hide the data

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

A. Heat Map Matrix
B. Tree Map
C. Map Visual
D. Scatter Plot

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 adds a title
B. It creates a separate line for each category in the legend field
C. It filters the data
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 in Excel, not Power BI
B. Only if the visual is a Card
C. Yes, using the 'fx' (function) button in formatting options
D. No, backgrounds must be static colors
Previous MCQ
Unit 4
Next MCQ
Unit 6