Microsoft-Analyzing and Visualizing Data with Microsoft Excel

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 into quartiles. The visualization must display the mean score and must identify any outliers. Which type of chart should you use?

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 the previous year by 1.15. What should you do?

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 Power BI dashboard. What should you do?

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 the Power BI service to perform natural language queries. You need to ensure that the users can query the term employee and receive results from the User table. What should you do before you publish to Power BI?

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 to Power BI. Make sure your workbook is saved as an Excel file (.xlsx or .xlsm) and is not password protected." You need to ensure that you can publish the file to Power BI. What should you do first?

You have an Excel workbook that has the following two workbook queries: A query named Consultants that retrieves a table named Consultants_Contact from a Microsoft SQL Server database A query named Employees that retrieves a table named Employee_Contact from a Microsoft Azure SQL database Both tables have the same columns. You need to combine all the data from Consultants and Employees into one table. Which command should you use?

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 store the files in various locations. You need to ensure that the users can change the path to the CSV files in the queries as quickly as possible. What should you do from Query Editor?

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 model. You create a PivotTable and a PivotChart. You plan to share SalesResult.xlsx to several users outside of your organization. You need to ensure that the users can see the PivotTable and the PivotChart when they open the file. The data in the model must be removed. What should you do?

You have an Excel workbook query that loads data to a worksheet and the data model. You need to ensure that the data is refreshed whenever you open the workbook. What should you do?

You have two queries named Client and Invoices. A sample of Client is shown in the following table. A sample of Invoices is shown in the following table. You need to create a new table that has the following information. Which join kind should you use?