Microsoft Excel 2010

May 12th, 2014
DotaCN
Category:
Computer Science
Price: $15 USD

Question description

Start Excel. Open the downloaded Excel workbook named Exploring_e03_Grader_IR.xlsx.
Select cells A4:E10. Insert a 2-D Clustered Colum chart based on the selected data.
Move the chart so that its top left corner is in the upper left corner of cell A13. Change the width of the chart to 6" and the height to 4".
Select the nonadjacent ranges A4:A10 and F4:F10. Insert a 2-D Pie chart based on the selected data.
Move the pie chart to a new worksheet named Pie Chart. Apply the Chart Style 26 and the Chart Layout 6 to the pie chart.
Edit the data in the pie chart so that it includes the ranges A4:A10 and D4:D10 (ticket sales for November only). Change the chart type to Pie in 3-D.
Set the Homecoming Dinner-Dance data point explosion to 50%. Format the data labels to show values (in addition to the existing percentages) but not leader lines.
Modify the chart title of the pie chart to be November Ticket Sales.
On Sheet 1, add the title Event Tickets by Month above the chart. Insert data labels at the outside end of the November data points.
In the 2-D Column chart, add a rotated primary vertical axis title as Tickets Sold. Change the fill color of the November data series to Light Blue (under Standard Colors).
Add a linear trendline to the November data series.
Insert column sparklines in cells G5:G11. Include the data range B5:E11 (September through December data) in the charts. Show the high point in each of the sparklines. Set the marker color of each high point to Green (under Standard Colors).
Enter Trends in cell G4.
Prepare Sheet1 for printing by changing the orientation to Landscape. Ensure that the worksheets are correctly named and placed in the following order in the workbook: Pie Chart; Sheet1.
Exploring_e03_Grader_IR.xlsx 

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Purdue University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
kevin12622
Dec 3rd, 2016
" Goes above and beyond expectations ! "
kiln82
Nov 24th, 2016
" awesome work thanks "
ashleyisgod
Nov 19th, 2016
" Top quality work from this guy! I'll be back! "
likeplum4
Nov 10th, 2016
" Excellent work as usual "
Molly_Moon
Oct 28th, 2016
" AMAZING as always! "
kpcutie
Oct 19th, 2016
" Excellent job "
Hemapathy
Oct 5th, 2016
" all I can say is wow very fast work, great work thanks "
pmallory
Sep 26th, 2016
" Totally impressed with results!! :-) "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1827 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