You have a workbook query that loads data from C:DataUsers.xlsx. You move Users.xlsx to a shared folder on the network. You need to ensure that you can refresh the data from Users.xlsx. What should you do? A. From Query Editor,…

From a workbook query, you import a table that has the following data. You need to configure the table to appear as shown in the following table. What should you do? A. From the Format menu, click Trim B. From…

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 Query Editor, you create a custom column named ResellerPrice that uses a formula…

You have a workbook query that loads data from a table in a Microsoft Azure SQL database. The table has a column named LineTotal. The following is a sample of the data in LineTotal: 40 1 999 7658 883432 You…

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 stated goals. Some question sets might have more than one correct solution,…

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 stated goals. Some question sets might have more than one correct solution,…

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 stated goals. Some question sets might have more than one correct solution,…

You have the data model shown in the Data Model exhibit. (Click the Exhibit button.) Data Model exhibit: You have the PivotChart shown in the Pivot Chart exhibit. (Click the Exhibit button.) Pivot Chart exhibit: You need to change the…

DRAG DROP You merge several CSV files by using Query Editor. You need to remove all the leading whitespaces and all the non-printable characters from a column. What should you do to achieve each task? To answer, drag the appropriate…

HOTSPOT You have a table named Date that contains the following data You have a table named Sales that contains the following data You plan to create a PivotCharts that will be sliced by MonthName. You need to create a…