Test Bank for Your Office Microsoft 365: Excel 2025, 1st Edition by Amy S. Kinser

Your Office: Microsoft 365® Excel (Kinser)
Appendix A: Leveraging Microsoft's Power Business Intelligence ("BI") Desktop
Suite

1) Which of the following is FALSE?
A) The Power BI suite allows businesses to easily leverage both analytics and
intelligence into day-to-day operations.
B) Both content creation and publishing are free in the Power BI suite.
C) The Power BI suite has two specific advantages–content creation is free and the
interface is comfortable for Excel users.
D) The Power BI suite is composed of two pieces–the Power BI Desktop and the
Power BI service.
Answer: B
Diff: 2
Objective: 1. Install and connect the Power BI Desktop


2) Which two pieces make up the Power BI suite?
A) Power BI Desktop and Power BI service
B) Power BI Suite and Power BI Add-in
C) Power BI Report Builder and Power BI Add-in
D) Microsoft Office 365 and Power BI service
Answer: A
Diff: 2
Objective: 1. Install and connect the Power BI Desktop


3) The Power BI is a free tool for analysts to develop powerful
visualizations, models, reports, and analytics.
A) suite
B) service
C) Desktop
D) add-in
Answer: C
Diff: 2
Objective: 1. Install and connect the Power BI Desktop


4) Which of the following best describes the Power BI Desktop?
A) A paid tool for viewing and interacting with Power BI reports
B) A free tool for analysts to develop visualizations, models, and analytics
C) A feature in Microsoft Excel for creating advanced charts and reports
1
Copyright © 2026

, D) An online service for sharing Power BI reports with content consumers
Answer: B
Diff: 2
Objective: 1. Install and connect the Power BI Desktop


5) The Power BI is a paid service that allows the analyst to share reports
in an interactive form.
A) suite
B) service
C) Desktop
D) add-in
Answer: B
Diff: 2
Objective: 1. Install and connect the Power BI Desktop


6) Which of the following is NOT true about the Power BI suite?
A) Sharing files created in the Power BI Desktop as a .pbix file is free but publishing
to content consumers is not free.
B) Analysts can develop reports in the Power BI Desktop for free.
C) The Power BI service is made for content consumers.
D) The Power BI suite is composed of three pieces—the Power BI Desktop, the
Power BI service, and Microsoft Office 365.
Answer: D
Diff: 3
Objective: 1. Install and connect the Power BI Desktop


7) Local connections to your data are called a(n) connection.
A) absolute
B) relative
C) static
D) cloud
Answer: A
Diff: 3
Objective: 1. Install and connect the Power BI Desktop


8) In the Power BI Desktop, which view allows users to create additional calculations
and view raw data similar to Excel’s Power Pivot?
2
Copyright © 2026

, A) Table view
B) Model view
C) Report view
D) Visualizations pane
Answer: A
Diff: 1
Objective: 2. Understand the Power BI Desktop, relationships, and filled maps


9) In the Power BI Desktop, which view is the default starting view where visual content
is created?
A) Table view
B) Model view
C) Report view
D) Visualizations pane
Answer: C
Diff: 1
Objective: 2. Understand the Power BI Desktop, relationships, and filled maps


10) Which of the following is NOT a type of visual content in the Power BI Desktop?
A) Maps
B) Calculations
C) Tables
D) Waterfalls
Answer: B
Diff: 3
Objective: 2. Understand the Power BI Desktop, relationships, and filled maps


11) You need to access a list of available tables in the Power BI Desktop. Where can
you find them?
A) Visualizations pane
B) Model view
C) Table view
D) Data pane
Answer: D
Diff: 2
Objective: 2. Understand the Power BI Desktop, relationships, and filled maps



3
Copyright © 2026

, 12) Maps can be created, configured, and formatted in the .
A) Visualizations pane
B) Model view
C) Table view
D) Data pane
Answer: A
Diff: 2
Objective: 2. Understand the Power BI Desktop, relationships, and filled maps


13) A key uniquely identifies the record and can only occur once.
A) foreign
B) visualization
C) primary
D) transaction
Answer: C
Diff: 2
Objective: 2. Understand the Power BI Desktop, relationships, and filled maps


14) A key identifies a record in another data set.
A) foreign
B) visualization
C) primary
D) transaction
Answer: A
Diff: 2
Objective: 2. Understand the Power BI Desktop, relationships, and filled maps


15) The way in which the data in one data set connects to another data set through
common fields known as keys is called a .
A) visualization
B) connection
C) property
D) relationship
Answer: D
Diff: 1
Objective: 2. Understand the Power BI Desktop, relationships, and filled maps


4
Copyright © 2026