assignment 8 comp.docx - ASSIGNMENT 08 K02 MS Office...

This preview shows page 1 - 2 out of 3 pages.

ASSIGNMENT 08K02 MS Office Applications I1.Start Excel and open e01_Regional_Sales. Save the presentation using your own name asLastname_Firstname_Regional_Sales2.Change the Theme to Circuit. Set the width of column A to 95 Pixels and the widths ofcolumns B:H to 110 pixels.3.Merge and center the title across columns A:H. Apply the Title style. Merge and center thesubtitle 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 remainingquarters.6.Use the Quick Analysis tool to Sum the Northeast Sales for the four quarters. Use the secondsum option which willdisplay the column selection in yellow. Copy the formula down to cellF7.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 theTotal Cell Style.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 3 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture