Analyzing and Visualizing Data with Microsoft Excel Free Practice Exam Questions

29 real Analyzing and Visualizing Data with Microsoft Excel exam questions with answers and AI explanations. Microsoft certification prep — page 2 of 3.

  1. Question 41: You have a Power Pivot data model that contains a table named DimProduct. DimProduct has seven columns named ProductKey, ProductLabel, ProductName, ProductDesc…
  2. Question 49: Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the…
  3. Question 54: You are building a KPI. You need to configure the KPI to display a red icon when the sales from a month is less than nine percent of the sales from the last 12…
  4. Question 57: You have a table that contains data relating to exam candidates and their associated exam scores. You need to visualize the exam data by separating the data in…
  5. Question 63: You have an Excel workbook that contains two tables named User and Activity. You plan to publish the workbook to the Power BI service. Users will use Q&A in th…
  6. Question 64: You have 20 workbook queries that load 20 CSV files to a local computer. You plan to send the workbook and the 20 CSV files to several users. The users will st…
  7. Question 69: You have a data model in Excel. You export the data and the data model into a dataset in the Microsoft Power BI service. What can you use to modify the data mo…
  8. Question 70: You have a PivotChart template named Template1. You add a PivotChart to a worksheet. You need to apply the template to the PivotChart. What should you do?
  9. Question 79: You open C:\Data\Data.xlsx in Excel. When you attempt to publish the file to Microsoft Power BI, you receive the following error message: "We couldn't publish…
  10. Question 81: You install Microsoft Power BI Publisher for Excel. You need to use Excel to connect and analyze Power BI data. To which two types of Power BI data can you con…