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 1 of 3.

  1. Question 1: You have an Excel spreadsheet that contains a PivotChart. You install Microsoft Power BI Publisher for Excel. You need to add a tile for the PivotChart to a Po…
  2. Question 2: You have multiple workbook queries that load data from tables in Microsoft Azure SQL Database to a Power Pivot data model. You discover that new rows were adde…
  3. Question 3: You have a table in a Power Pivot model that is loaded from a Microsoft SQL Server database. The source table has four columns named ID, Price, Quantity, and T…
  4. Question 4: You have a KPI named Goal that calculates the sales from the previous year and multiplies the sales by 1.1. You need to modify Goal to multiply the sales from…
  5. Question 5: You create an Excel workbook named SalesResults.xlsx. You create a workbook query that connects to a Microsoft SQL Server database and loads data to the data m…
  6. Question 9: You have a workbook query that loads data from a table named Products. Products contains a column named InternalPrice that has a Data Type of Decimal. From Que…
  7. Question 25: You have a workbook query that loads data from C:\Data\Users.xlsx. You move Users.xlsx to a shared folder on the network. You need to ensure that you can refre…
  8. Question 28: Your network contains a folder that has data files in various formats. You need to identify how many files of each extension type are in the folder by using Qu…
  9. Question 33: You have an Excel workbook that contains a table named Sales. You add Sales to the Power Pivot model. You need to set a column named TransactionID as the row i…
  10. Question 34: You have a measure named SalesGrowth that calculates the percent of sales growth. The measure uses the following formula. ([Total Sales Current Year] "" [Total…