Online Access Free 070-779 Exam Questions

You have the following data sample.

You need to create a PivotTable that presents the data as shown in the following table.

• A.Create a PivotTable. Add SalesAmount to the Rows area and add UnitPrice to the Values area.
  Right-click a cell value for SalesAmount and modify the Group settings.
• B.Create a PivotTable. Add UnitPrice to the Rows area and add SalesAmount to the Values area.
  Right-click a cell value for UnitPrice and modify the Group settings.
• C.Create a PivotTable. Add UnitPrice to the Rows area and add SalesAmount to the Values area.
  Right-click a cell value for SalesAmount and modify the Field Settings.
• D.Create a PivotTable. Add SalesAmount to the Rows area and add UnitPrice to the Values area.
  Right-click a cell value for UnitPrice and modify the Field Settings.

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 location.
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?

• A.For each query, create a new query that uses a reference. Modify the source of each new query.
• B.Merge all the queries. Edit the source of the first query.
• C.Append all the queries. Edit the source of the first query.
• D.Create a parameter. Modify the source of each query to use the parameter.

You need to configure a PivotChart as shown in the following exhibit.

Witch chart element should you enable?

• A.Error Bars
• B.Data Labels
• C.Axis Titles
• D.Data Table

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 months.
What should you use to define the target value?

• A.a calculated field
• B.a calculated column
• C.an absolute value
• D.a measure

You have a table that contains data relating to exam candidates and their associated 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?

• A.line
• B.box and whisker
• C.histogram
• D.pie