Introduction to Information Systems

Nov 24th, 2014
Price: $15 USD

Question description


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

Tutor Answer

(Top Tutor) Collin P
School: UCLA

Studypool has helped 1,244,100 students

Review from student
" The best tutor out there!!!! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1826 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors