Online Access Free 77-728 Exam Questions

You have been a manager of a band for the past year. You are reviewing the data you have about the merchandise that was sold at all of the concerts.
Task5:
Exhibit:

On the"Cost Pivot Chart" worksheet add a 3D Stacked Bar Chart that shows the data in the PivotTable.

Correct Answer:

See the explanation below.
Explanation
Select the PivotTable and from the Analyze tab select the chart as mentioned below

Exhibit:

Task6:
On the "Quality Control" worksheet add a linear trendline to the chart that forecast the quality of batch C1005 through week 12.

Correct Answer:

See the explanation below.
Explanation
Select the chart and then go to chart elements - trendline - linear

You have been a manager of a band for the past year. You are reviewing the data you have about the merchandise that was sold at all of the concerts.
Task3:
Exhibit:

In Cell B19 on the "Merchandise-Sales" worksheet, calculate the total number of T-shirts that were sold for less than $18 at all concerts at which more than 1500 t-shirts were sold.

You have been a manager of a band for the past year. You are reviewing the data you have about the merchandise that was sold at all of the concerts.
Task4:
Exhibit:

Remove the name "Sales" that refers to the range "Merchandise-Sales'ISAS1 SHS17".