Introduction to Information Systems


On Your Own 16-1

1. Open the data file Portlandia. Save the workbook as Portlandia Skies.

2. In the Documentation worksheet, enter your name in cell B3 and the date in cell B4. My name is Timothy J. Carlton.

3. In the Weather worksheet, based on the data in the range A4:M8, insert an appropriate chart (such as a column chart, line chart, or bar chart). Move the embedded chart to a chart sheet name Average Day Chart.

4. Format the chart using an appropriate chart layout and chart style.

5. Insert an appropriate chart title for the chart, and then change the font size as needed.

6. Add appropriate axis titles, and change the font sizes as needed.

7. Position the legend appropriately, and change its font size border color, fill color, and so forth as desired.

8. Change the axis scale as needed to eliminate blank areas of the chart.

9. Add vertical gridlines to the major trick marks in the chart.

10. Format the plot area to use an attractive fil.

11. Change the data series as needed so that each data series uses a distinct data marker fill and line color.

12. In the Weather worksheet, edit the text in cell A6 to Party Cloudy.

13. In the Weather worksheet, based on the data in the range A5:A8; N5:N8, insert a pie chart. Reposition and resize the chart attractively on the Weather worksheet.

14. Format the pie chart attractively, using the chart layout, chart style, chart title, legend, and data labels of your choice.

15. In the Weather worksheet, in the cells of your choice inset a line or column sparkline for each of the following data: Clear (range B5;M5), Partly cloudy (range B6;M6), Cloudy (range B7;M7), and Rainy (range B8;M8),. Format the sparklines appropriately and enter labels to identify each sparkline.

16. In the Weather worksheet, insert data bars in the range N5;N8.

17. Save the workbook, and then close it.

I need a title page with my name Timothy J. Carlton, Course Section 056, Professor Name Dr. Elizabeth B Weidman, Assignment Title Own Your Own 16-1

“Get 15% discount on your first 3 orders with us”
Use the following coupon

Order Now