最新的Microsoft Excel 2016 Expert: Interpreting Data for Insights - 77-728免費考試真題
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
Exhibit:
You are an accountant for an event stadium. You have created a workbook to keep track of the four vendors that are available at the stadium.
Task 1:
Modify Excel options to Prevent formulas from being automatically evaluated when data changes. Formulas should not be evaluated when a workbook is saved.
You are an accountant for an event stadium. You have created a workbook to keep track of the four vendors that are available at the stadium.
Task 1:
Modify Excel options to Prevent formulas from being automatically evaluated when data changes. Formulas should not be evaluated when a workbook is saved.
正確答案:
See the explanation below.
Explanation
Go to file - options - formulas and check manual in calculation options. Uncheck recalculate workbook before saving option.
Explanation
Go to file - options - formulas and check manual in calculation options. Uncheck recalculate workbook before saving option.
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.
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.
正確答案:
Pending. Send us the suggestion for this task.