Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Microsoft Excel Assignment 2 1 . Open e 0 3 plUtilities.xlsxandsavease 0 3 plUtilities _ LastFirst.xlsx . 2 . Insert a Clustered Column chart based

Microsoft Excel Assignment 21. Open e03plUtilities.xlsxandsavease03plUtilities_LastFirst.xlsx.2. Insert a Clustered Column chart based on the rangeA4:E17.3. Filter the chart so the Monthly and Yearly Totals do not show.4. Reposition the chart so that the top-left corner of the chart is in cell A21.5. Change the width and the height of the chart to 6" and3.5" respectively.6. Apply the Layout 3 chart layout to the chart. Title the chart Monthly Utility Expenses for 2018. Apply the any chart style to the chart; copy the chart and paste it in cell A39.7. Change the copied Chart Type to Line with Markers; add a data label to the highest markers for Electric, Gas, and Water.8. On the Line Chart sheet: Change the font size to 12 for the value axis, category axis, data labels, and legend Format the vertical axis with zero decimal places Fill the Chart Area with a different color other than white9. On the first Chart sheet: Change Chart Type to Stacked Area Change the font size to 12 for the value axis, change the format to Number, and change the Decimal places to 0Change the font size to 12 for the category axis and the legend10. On the Expenses sheet, insert Line Sparklines, with B5:D16 for the Data Range and B18:D18 for the Location Range box; show the High Point and Low Points.11. Save the document and submit based on your instructor's direction.Sample Page:Note: Colors may vary
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions