77-728 無料問題集「Microsoft Excel 2016 Expert: Interpreting Data for Insights」
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.
Task5:
Exhibit:
On the"Cost Pivot Chart" worksheet add a 3D Stacked Bar Chart that shows the data in the PivotTable.
正解：
See the explanation below.
Explanation
Select the PivotTable and from the Analyze tab select the chart as mentioned below
Explanation
Select the PivotTable and from the Analyze tab select the chart as mentioned below
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.
Task2:
Exhibit:
On the "Merchandise-Costs" worksheet, change the dates in column A to Spanish (Mexico) using the format 14 de marzo de 2012. Change the currency C, E, G and H to $ Spanish (Mexico)
Task2:
Exhibit:
On the "Merchandise-Costs" worksheet, change the dates in column A to Spanish (Mexico) using the format 14 de marzo de 2012. Change the currency C, E, G and H to $ Spanish (Mexico)
正解：
See the explanation below.
Explanation
* Select column A - press Ctrl+1 and go to date in Number tab Select the desired format as given below and apply
* Selectcolumns C, E, G and H, press Ctrl+1 and go to currency in Number tab. Select the desired format as given below and apply
Explanation
* Select column A - press Ctrl+1 and go to date in Number tab Select the desired format as given below and apply
* Selectcolumns C, E, G and H, press Ctrl+1 and go to currency in Number tab. Select the desired format as given below and apply
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".
Task4:
Exhibit:
Remove the name "Sales" that refers to the range "Merchandise-Sales'ISAS1 SHS17".
正解：
See the explanation below.
Explanation
Go to Formulas - name Manager - select the above mentioned name from the list and hit 'Delete'
Explanation
Go to Formulas - name Manager - select the above mentioned name from the list and hit 'Delete'