Introduction to Information Systems

Nov 24th, 2014
Sigchi4life
Category:
Writing
Price: $15 USD

Question description

Porttlandia.xlsx 

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) Daniel C.
(997)
School: UT Austin
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
darnay
Dec 1st, 2016
" The best tutor out there!!!! "
dontuwannaknow
Nov 22nd, 2016
" Excellent work as always thanks so much "
SjSurvivor143
Nov 8th, 2016
" Thanks for the help. "
ddg82
Oct 30th, 2016
" Thanks, good work "
tinytim47
Oct 17th, 2016
" Wow this is really good.... didn't expect it. Sweet!!!! "
jestin7
Oct 8th, 2016
" This tutor is great! "
mixedballz
Oct 3rd, 2016
" excellent work as always thanks for the help "
lilmoe415
Sep 24th, 2016
" Thank you, Thank you, for top quality work, this is your guy!! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1825 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