Scribd Logo
Upload

Welcome to Scribd!

  • 40 views

    Excel Exercise 3.3

    Uploaded by

    andre
    This document provides instructions for formatting an Excel spreadsheet with supplier data for the company SPANX. The instructions include renaming sheets and files, inserting headings and borders, sorting data alphabetically, adjusting column widths, changing page orientation and margins, and saving the formatted workbook. The expected formatted output is also shown.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Excel Exercise 3.3

    Uploaded by

    andre
    40 views2 pages
    This document provides instructions for formatting an Excel spreadsheet with supplier data for the company SPANX. The instructions include renaming sheets and files, inserting headings and borders, sorting data alphabetically, adjusting column widths, changing page orientation and margins, and saving the formatted workbook. The expected formatted output is also shown.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions for formatting an Excel spreadsheet with supplier data for the company SPANX. The instructions include renaming sheets and files, inserting headings and borders, sorting data alphabetically, adjusting column widths, changing page orientation and margins, and saving the formatted workbook. The expected formatted output is also shown.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    40 views2 pages

    Excel Exercise 3.3

    Uploaded by

    andre
    This document provides instructions for formatting an Excel spreadsheet with supplier data for the company SPANX. The instructions include renaming sheets and files, inserting headings and borders, sorting data alphabetically, adjusting column widths, changing page orientation and margins, and saving the formatted workbook. The expected formatted output is also shown.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    Ms Excel Basic Formatting

     
    Chapter Learning Outcomes:
     Renaming the Excel File
     Renaming a Sheet and Deleting a Sheet
     Inserting a New Row or Column
     Inserting a Heading
     Formatting Headings: Bold, Centre, Underline, Merge Centre, Changing Font, Changing Font Size, Fill with
    Colour/Highlight
     Inserting/Typing/Formatting Subheadings: Apply Format Painter, Auto Fit Columns, Changing Column Width or
    Row Height and Wrap Text
     Inserting Borders
     Sorting Data Ascending (A-Z) or Descending (Z-A)
     Moving Sheets
     Changing Page Orientations, Page Size or/and Page Margins
     Page Views: Layout & Normal-Headers and Footers
     Auto Fill

    Exercise 3.3_SPANX Suppliers_Instructions:

    1. Rename the Excel File to: YourSurname_YourStudent Number_Your Group_EW5


    2. Open your above-named Spreadsheet and Rename Sheet1 to Spanx
    3. Insert a New Row at the Top and Insert/Type in the Heading: SPANX SUPPLIERS
    4. Merge and Center the Main Heading. Apply Font Size: 14 and Font: Abadi
    5. Apply Bold to the Main Heading and Fill with Colour Yellow
    6. Adjust the Column Width (From Column A to G) to 12
    7. Insert “All Borders” From Cell: A1 to G14
    8. Highlight (With mouse) Cell: A4 to Cell: G12 and Sort the Data in Alphabetical Order (A to Z)
    9. Insert a New Sheet and Copy-Paste All the Data from Spanx Sheet to Sheet 2
    10. Auto Fit All the Columns and Resize Column C & D to 15
    11. Change the Page Orientation to Landscape and Page Margins to “Wide”
    12. Change your Workbook Sheet View from “Normal View” to “Page Layout View
    13. Save your Work

    Your Solution Should look like this Below:

    SPANX SUPPLIERS
    VARIABLE COSTS NUMBER OF COST PER
    PRODUCT FIXED COSTS TOTAL COST
    WAGES WATER UNITS UNIT
    488.052173
    BEM111 4207.2 7000 18 23 11225.2 9
    174.850909
    CDS455 3604.8 6000 12 55 9616.8 1
    PMT258 3917.6 6500 44 40 10461.6 261.54
    380.461111
    SAR555 5127.6 8500 69 36 13696.6 1
    STA258 1754 2900 35 20 4689 234.45
    135.277777
    VEN125 910 1500 25 18 2435 8
    VWB777 1600 2500 250 50 4350 87
    XUI558 1824 3000 60 60 4884 81.4
    ZTR630 2748 4500 120 60 7368 122.8
    1965.83197
    TOTAL 25693.2 42400 633 362 68726.2 2
    AVERAGE         7636.24444  
    4

    You might also like