최신 77-728 무료덤프 - Microsoft Excel 2016 Expert: Interpreting Data for Insights
Exhibit:
You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task3:
Create new customized colors with the Accent 1 option to RGB "255", "153", "51".
Name the customized colors "Orange Table".
You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task3:
Create new customized colors with the Accent 1 option to RGB "255", "153", "51".
Name the customized colors "Orange Table".
정답:
See the explanation below.
Explanation
* Go to Page layout - colors - customize colors
* In Accent 1 go to more colors and enter the required RGB valuesand give it the nameorange Table
Explanation
* Go to Page layout - colors - customize colors
* In Accent 1 go to more colors and enter the required RGB valuesand give it the nameorange Table
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.
Exhibit:
Task6:
On the "Quality Control" worksheet add a linear trendline to the chart that forecast the quality of batch C1005 through week 12.
Task6:
On the "Quality Control" worksheet add a linear trendline to the chart that forecast the quality of batch C1005 through week 12.
정답:
See the explanation below.
Explanation
Select the chart and then go to chart elements - trendline - linear
Explanation
Select the chart and then go to chart elements - trendline - linear