Moore Computer 5

Step

Instructions

Points Possible

1

Start Excel. Open TIA_Ch5_Start.xlsx.

0

2

Create a 2-D Area chart using the range A3:G7. Add a Chart Title: Change in Mobile OS Market Share 2013-2018. Place 2013-2018 on a separate line. Modify the font size of 2013-2018 to 10. Position the chart to fill cells J2:S19.

20

3

Filter the Area chart by removing Others and Windows data so only Android and iOS data displays. If necessary, resize the chart to ensure that it fill cells J2:S19. Mac users, use the Select Data Source dialog box to filter the data.

10

4

Add a Callout: Line Shape to the Area chart with the line pointing to the top of the orange area between 2014 and 2015. Add text to the callout: Android Market Share Takes Off!. Format the callout with Subtle Effect - Gold, Accent 4 Shape Style. Adjust the size of the shape, as necessary, so that all the text in the callout is visible. Note, depending on the version of Office used, the shape name may be Line Callout 1.

10

5

Create a 2-D Pie chart using the ranges A15:A21 and G15:G21. Move the chart so it is on its own worksheet. Rename the worksheet Global OS.

15

6

Modify the chart as follows: Add a title: Operating System 2018 Global Market Share Use Quick Layout 1 to add data % and Series data labels to each data point.

15

7

On the Data worksheet, create a Clustered Column chart using cells A26:A39 and D26:D39 to show only Android data. Place the chart to fill the range I26:S45. Add a title: 2018 Android Market Share by Country.

20

8

Add a Column Sparkline to cells H16:H21 using the data in range B16:G21. Increase the width of column H to 15.

10

9

Create a Filled Map Chart from the data in ranges A26:A39 and D26:D39. Place the chart to fill the range A42:G56. Add a title: 2018 Android Market Share by Country.

0

10

Save and submit the workbook for grading.

0

Total Points

100