Back to lesson
1. If cell B1 contains the text “Acme Company” and you were to refer to the following formula in your chart title, how would the chart title display? =B1&Char(12)&”Monthly Sales”
The title would show Acme Company with Monthly Sales on a new line
The title would show Monthly Sales with Acme Company on a new line
The title would show “Acme Company – Monthly Sales”
2. How do you change the following chart to group the data by product category instead of month?
In the Chart Tools menu, select the Design tab, and click on Switch Row/Column
In the Chart Tools menu, select the Design tab, and click on Change Chart Type
Right click the chart, select Format Data Series, and toggle Plot Series On to Secondary Axis
3. Does changing the format of Data Labels on one series change the format of Data Labels applied to a different series on the chart?
No, Data Labels for a series are independent of other series
Yes, as long as both series of Data Labels have been selected
Yes, all Data Labels on the chart are formatted to match the new format
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement