최신 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.
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.
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.
Task2:
Create a PivotTable in Cell A2 of the "Vendor Costs" worksheet based on cells C3 K19 on the "Purchases" worksheet to show the average of the total cost for each vendor. Display each vendor on a row.
Task2:
Create a PivotTable in Cell A2 of the "Vendor Costs" worksheet based on cells C3 K19 on the "Purchases" worksheet to show the average of the total cost for each vendor. Display each vendor on a row.
정답:
See the explanation below.
* Select the rangeC3:K19 on the Purchases worksheet
* Go to Insert - Pivot table
* Put Vendor in Row area andtotal cost for each vendorin values
* Change the sum oftotal cost for each vendorto Averagetotal cost for each vendorby going to value field settings
* Select the rangeC3:K19 on the Purchases worksheet
* Go to Insert - Pivot table
* Put Vendor in Row area andtotal cost for each vendorin values
* Change the sum oftotal cost for each vendorto Averagetotal cost for each vendorby going to value field settings
Exhibit:
You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task2:
Prevent users from adding, deleting or modifying worksheets unless they enter the password "12345".
You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task2:
Prevent users from adding, deleting or modifying worksheets unless they enter the password "12345".
정답:
See the explanation below.
Explanation
Go to Review - Protect workbook -and enter the password 12345 and click 'Ok'
Explanation
Go to Review - Protect workbook -and enter the password 12345 and click 'Ok'