Home > Business Analyst > Quizzes > Microsoft Power BI Quiz
Microsoft Power BI Quiz
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 4% • Most missed: “What should you use to highlight a specific visualization in a report?”

Microsoft Power BI MCQs For LinkedIn Skill Assessments.

Power BI is an interactive data visualization software product developed by Microsoft.

Microsoft Power BI Quiz
Time left 00:00
25 Questions

1. You have two Excel spreadsheets with data from separate reporting units. Both spreadsheets have the same column names. What Power Query Editor feature can you use to create a unified dataset?
2. Which data type can be uploaded directly to powerbi.com?
3. What daily sales number does this DAX measure formula calculate?
'CALCULATE(SUM([Sales]) ,DATESMTD([Date] ))'
4. The iterator functions SUMX and AVERAGEX are used to perform calculations '\_'.
5. In Power BI Desktop Model view, what type of join will yield all results from Table 1 and any matching results from Table 2?
6. Which feature is 'not' in the Power BI Admin portal?
7. Which feature in the Power BI service is most useful when you need to create pages that present the same visualizations for different territories, salespeople, or teams?
8. Power BI works best with tables that are '\_',
9. You have two columns of numerical data and want to create a visual to help determine if there is a relationship between them. What kind of chart is designed to do this?
10. What can you do within the Power BI Desktop uery Settings pane? (Select all that apply.)
A. Rename a query step.
B. Delete a query step.
C. Delete from one query step to the end.
D. Reorder the steps.
11. Your computer rental dataset includes columns for StartTime, EndTime, and PerHourRate. What two DAX functions could you use to calculate the total earned for rentals?
12. You want to combine several CSV files into a single data file after you connect a folder. What must be true about these CSV data files? (Select all that apply.)
A. They must be stored in the same folder.
B. They must have the same schema.
C. They must have the same file type.
D. They must have no duplicate data rows.
13. You have a report in Power BI service and want to save the state of a report page for easy access. What feature helps you do this?
14. In the Power BI service, accessing a dataset for an uploaded Power BI file allows you what capabilities?
15. You want to count the number of products in the Products data table. Which DAX function works best?
16. What are benefits of modifying your Excel data source in the Power Query Editor rather than in Excel?
A. You can track the changes you make.
B. It is less error prone than manual editing.
C. It will not affect other users of the spreadsheet.
D. It 'locks down' the spreadsheet columns in Excel.
17. In general, what is the best way to shape your data for Power BI?
18. In the report editor, which task can you NOT accomplish using drag and drop?
19. You can create a live connection to \_ .
20. Which DAX function compares a column of values in Table A with a similar column in Table B, and returns the values the are not found in Table B?
21. Power BI's Publish to Web option allows you to embed visualizations within '\_'. (Select all that apply.)
A. blog posts
B. email messages
C. web sites
D. text messages
22. When you are creating a formula in the Power Query Editor, what does IntelliSense provide a list of? (Select all that apply.)
A. columns
B. tables
C. functions
D. data sources
23. [proof link1](https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting)
2. [link2](https://www.edureka.co/community/26060/how-do-i-undo-something-in-power-bi) You have a sales data source and want to relate the tables. The table that contains sales transactions is a '\_' table that contains product information is a \_ table ."
24. In Power BI, what is the most important difference between tables related in a star schema and in a snowflake schema?
25. Which type of visualization is best when you want to compare proportions in a large volume of data with multiple categories and subcategories?

⚡ Recently practiced quizzes in this topic
Live quiz activity
BCS Foundation Certificate in Business Analysis Practice Test CBAP+ Master Certified Business Analysis Professional: BABOK Knowledge Test CBAP+ Master Certified Business Analysis Professional Practice Test Microsoft Power BI Basics Business Analysis Practice Test: Business Analysis Techniques, Planning and Monitoring IBM Certified Business Process Analyst C9550-606 Exam Business Analysis
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.