View the step-by-step solution to:

Create an Excel worksheet and chart as shown below. Save the worksheet with the name: Budget - your own name. The final product should contain the...

Create an Excel worksheet and chart as shown below.  Save the worksheet with the name: Budget – your own name.  The final product should contain the appropriate functions and formulas.   In addition, use absolute addressing where appropriate.  Format as follows:

  • Enter the worksheet title in cell A1 and merge and center it using cells A1-I1.
  • You can use any font but increase the font size of the worksheet title; any size just bigger.
  • Boldface column headings, row headings and totals.
  • Cells A1-I1 should be formatted with a thick box border.
  • Cells A1-I1 should be formatted with a background color (you can use any color).
  • The row headings should be left-aligned.
  • The column headings should be centered.
  • The column heading in cell I3 should be wrapped to two lines.
  • Cells A12-I12 should include a top and bottom border.
  • Cells A17-H18 should be formatted with a background color (use the same color as above).
  • The numbers in columns B-H should be formatted with a floating $ and two decimal places.
  • Increase the height of row 13.
  • The percentages should be formatted with one decimal place.
  • The chart type should be “Pie” using style 12 and be positioned and sized as shown.
  • No chart title should be included.
  • The data labels on the chart should include only the percentages and be positioned outside each slice showing the leader lines.
  • Boldface the data labels and the legend and position the legend to the right of the chart as shown.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question