Assignment 8

Anonymous
timer Asked: Oct 16th, 2018
account_balance_wallet $5

Question Description

Assignment 08

K02 MS Office Applications I

  • Start Excel and open e01_Regional_Sales. Save the presentation using your own name as Lastname_Firstname_Regional_Sales
  • Change the Theme to Circuit. Set the width of column A to 95 Pixels and the widths of columns B:H to 110 pixels.
  • Merge and center the title across columns A:H. Apply the Title style. Merge and center the subtitle across columns A:H and apply the Heading 1 Style.
  • Apply Center formatting to all seven column titles. Apply the Heading 4 Cell Style.
  • Use the Quick Analysis tool to Sum the Quarter 1 Sales. Copy across to the remaining quarters.
  • Use the Quick Analysis tool to Sum the Northeast Sales for the four quarters. Use the second sum option which will display the column selection in yellow. Copy the formula down to cell F7.
  • Apply the Accounting Number format to the first row of sales figures and to the total row.Apply the comma style to the remaining sales figures. Format the totals in row 7 with the Total Cell Style.
  • Insert a new row 6 with the row title Midwest Add the following figures for each quarter: 110975.45, 119764.92, 101549.40, and 120598.14 Copy the formula from cell F5 to cell F6.
  • In cell G4, construct a formula to calculate the Percent of Total Sales for the first region. Copy the formula down to the remaining regions. To the completed percentages, apply percent style with two decimal places. Center the percentages.
  • In the range H4:H7 insert line Sparklines. Do not include the totals. Show the Sparkline markers. Apply the Sparkline style Colorful 1.
  • Insert a Clustered Column Chart that represents the sales figures for the four quarters. The regions should be the x category and quarters the legend.
  • Apply Chart Style 7 and Color 2 under Colorful. Position the chart so that the upper right corner of the chart aligns with cell F10. Change the chart title to 2018 Regional Sales to Health Clubs
  • Deselect the chart. Change the page orientation to landscape. Center the worksheet horizontally on the page. Insert a footer with the file name in the left section.
  • Enter the tags of health club, sales. For the subject, type your course name and section number. Your name should display as the author.
  • Save the workbook. Print a PDF electronic image. Close the file and Excel.

Grading Rubric

Please refer to the rubric on the next page for the grading criteria for this assignment.

Unformatted Attachment Preview

Pro Fit Marietta 2019 Regional Sales to Fitness Clubs Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Northeast 225684.5 210760.5 181555.3 228634.9 Southeast 128698.1 144465.3 132106.8 155874.8 West 292416.7 247941.5 262774.1 291699 Total Sales % of Total Sales Trend ASSIGNMENT 08 K02 MS Office Applications I 1. Start Excel and open e01_Regional_Sales. Save the presentation using your own name as Lastname_Firstname_Regional_Sales 2. Change the Theme to Circuit. Set the width of column A to 95 Pixels and the widths of columns B:H to 110 pixels. 3. Merge and center the title across columns A:H. Apply the Title style. Merge and center the subtitle across columns A:H and apply the Heading 1 Style. 4. Apply Center formatting to all seven column titles. Apply the Heading 4 Cell Style. 5. Use the Quick Analysis tool to Sum the Quarter 1 Sales. Copy across to the remaining quarters. 6. Use the Quick Analysis tool to Sum the Northeast Sales for the four quarters. Use the second sum option which will display the column selection in yellow. Copy the formula down to cell F7. 7. Apply the Accounting Number format to the first row of sales figures and to the total row. Apply the comma style to the remaining sales figures. Format the totals in row 7 with the Total Cell Style. 8. Insert a new row 6 with the row title Midwest Add the following figures for each quarter: 110975.45, 119764.92, 101549.40, and 120598.14 Copy the formula from cell F5 to cell F6. 9. In cell G4, construct a formula to calculate the Percent of Total Sales for the first region. Copy the formula down to the remaining regions. To the completed percentages, apply percent style with two decimal places. Center the percentages. 10. In the range H4:H7 insert line Sparklines. Do not include the totals. Show the Sparkline markers. Apply the Sparkline style Colorful 1. 11. Insert a Clustered Column Chart that represents the sales figures for the four quarters. The regions should be the x category and quarters the legend. 12. Apply Chart Style 7 and Color 2 under Colorful. Position the chart so that the upper right corner of the chart aligns with cell F10. Change the chart title to 2018 Regional Sales to Health Clubs 13. Deselect the chart. Change the page orientation to landscape. Center the worksheet horizontally on the page. Insert a footer with the file name in the left section. 14. Enter the tags of health club, sales. For the subject, type your course name and section number. Your name should display as the author. 15. Save the workbook. Print a PDF electronic image. Close the file and Excel. Grading Rubric Please refer to the rubric on the next page for the grading criteria for this assignment. TASK Exemplary Start Excel and open e01_Regional_Sales. Save the presentation using 5 points your own name as Lastname_Firstname_Regional_Sales Student provides a correct result. Change the Theme to Circuit. Set the width of column A to 95 Pixels 5 points and the widths of columns B:H to 110 pixels. Student provides a correct result. Merge and center the title across columns A:H. Apply the Title style. 5 points Merge and center the subtitle across columns A:H and apply the Student provides a correct Heading 1 Style. result. Apply Center formatting to all seven column titles. Apply the Heading 5 points 4 Cell Style. Student provides a correct result. Use the Quick Analysis tool to Sum the Quarter 1 Sales. Copy across to 10 points the remaining quarters. Use the Quick Analysis tool to Sum the Student provides a correct Northeast Sales for the four quarters. Use the second sum option result. which will display the column selection in yellow. Copy the formula down to cell F7. Satisfactory 4 points Student provides a mostly correct result. 4 points Student provides a mostly correct result. 4 points Student provides a mostly correct result. 4 points Student provides a mostly correct result. 8 points Student provides a mostly correct result. Unsatisfactory 3 points Student provides a weak or unclear result. 3 points Student provides a weak or unclear result. 3 points Student provides a weak or unclear result. 3 points Student provides a weak or unclear result. 5 points Student provides a weak or unclear result. Unacceptable 2 points Student provides a poor result. 2 points Student provides a poor result. 2 points Student provides a poor result. 2 points Student provides a poor result. 2 points Student provides a poor result. Apply the Accounting Number format to the first row of sales figures and to the total row. Apply the comma style to the remaining sales figures. Format the totals in row 7 with the Total Cell Style. 10 points Student provides a correct result. 8 points Student provides a mostly correct result. 5 points Student provides a weak or unclear result. 2 points Student provides a poor result. Insert a new row 6 with the row title Midwest Add the following figures for each quarter: 110975.45, 119764.92, 101549.40, and 120598.14 Copy the formula from cell F5 to cell F6. 10 points Student provides a correct result. 8 points Student provides a mostly correct result. 5 points Student provides a weak or unclear result. 2 points Student provides a poor result. In cell G4, construct a formula to calculate the Percent of Total Sales for the first region. Copy the formula down to the remaining regions. To the completed percentages, apply percent style with two decimal places. Center the percentages. 10 points Student provides a correct result. 8 points Student provides a mostly correct result. 5 points Student provides a weak or unclear result. 2 points Student provides a poor result. In the range H4:H7 insert line Sparklines. Do not include the totals. Show the Sparkline markers. Apply the Sparkline style Colorful 1. 10 points Student provides a correct result. 8 points Student provides a mostly correct result. 5 points Student provides a weak or unclear result. 2 points Student provides a poor result. Insert a Clustered Column Chart that represents the sales figures for the four quarters. The regions should be the x category and quarters the legend. Apply Chart Style 7 and Color 2 under Colorful. Position the chart so that the upper right corner of the chart aligns with cell F10. Change the chart title to 2018 Regional Sales to Health Clubs 10 points Student provides a correct result. 8 points Student provides a mostly correct result. 5 points Student provides a weak or unclear result. 2 points Student provides a poor result. Deselect the charge. Change the page orientation to landscape. Center the worksheet horizontally on the page. Insert a footer with the file name in the left section. 10 points Student provides a correct result. 8 points Student provides a mostly correct result. 5 points Student provides a weak or unclear result. 2 points Student provides a poor result. Enter the tags of health club, sales For the subject, type your course name and section number. Your name should display as the author. 5 points Student provides a correct result. 4 points Student provides a mostly correct result. 3 points Student provides a weak or unclear result. 2 points Student provides a poor result. Save the workbook. Print a PDF Electronic image. Close the file and Excel. 5 points Student provides a correct result. 4 points Student provides a mostly correct result. 3 points Student provides a weak or unclear result. 2 points Student provides a poor result. ...
Purchase answer to see full attachment

Tutor Answer

JamelF
School: Cornell University

Hello bro,he...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Similar Questions
Hot Questions
Related Tags
Study Guides

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