Scribd Logo
Upload

Welcome to Scribd!

  • 696 views

    Module 2 Assignment

    Uploaded by

    makhan2227
    1. The document provides instructions to format a spreadsheet inventory of furniture, hardware, and supplies for a new office by standardizing fonts, aligning cells, adding categories and formatting prices. 2. Steps include adding category columns, merging category cells, formatting prices as currency, and protecting the sheet with a password. 3. Conditional formatting is applied to indicate member discounts, out of stock items, and page breaks are added to print categories separately.

    Copyright:

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

    Module 2 Assignment

    Uploaded by

    makhan2227
    696 views6 pages
    1. The document provides instructions to format a spreadsheet inventory of furniture, hardware, and supplies for a new office by standardizing fonts, aligning cells, adding categories and formatting prices. 2. Steps include adding category columns, merging category cells, formatting prices as currency, and protecting the sheet with a password. 3. Conditional formatting is applied to indicate member discounts, out of stock items, and page breaks are added to print categories separately.

    Original Description:

    Module of assignments for excel learning

    Original Title

    Module 2_Assignment-1

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. The document provides instructions to format a spreadsheet inventory of furniture, hardware, and supplies for a new office by standardizing fonts, aligning cells, adding categories and formatting prices. 2. Steps include adding category columns, merging category cells, formatting prices as currency, and protecting the sheet with a password. 3. Conditional formatting is applied to indicate member discounts, out of stock items, and page breaks are added to print categories separately.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    696 views6 pages

    Module 2 Assignment

    Uploaded by

    makhan2227
    1. The document provides instructions to format a spreadsheet inventory of furniture, hardware, and supplies for a new office by standardizing fonts, aligning cells, adding categories and formatting prices. 2. Steps include adding category columns, merging category cells, formatting prices as currency, and protecting the sheet with a password. 3. Conditional formatting is applied to indicate member discounts, out of stock items, and page breaks are added to print categories separately.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 6
    At a glance
    Powered by AI
    The document provides instructions to organize an inventory worksheet for Food2Go's new office by applying various formatting changes such as standardizing fonts, adding categories, and calculating totals.

    The instructions aim to organize the worksheet in a visually appealing manner by standardizing fonts, adding categories to group similar items, calculating totals, and setting page breaks to print categories separately.

    Formatting changes include standardizing fonts, adding categories, calculating totals, setting page breaks, landscape orientation, repeating headers, and formatting cells for member discounts and out of stock items.

    Module 2 Assignment

    Overview
    One of the exciting things about working in a startup is the flexibility to do things your way! Ishan
    a new office of their own. Food2Go has received quotes from various suppliers for furniture, hard
    copied them into a spreadsheet. As a result the formatting is all over the place!

    Follow the instructions below to organize the worksheet and make it visually appealing by applyin

    Instructions
    1. Duplicate the worksheet "Module 2 Assignment".
    2. Rename the worksheet as "Inventory".
    3. Highlight Rows 2 to 31 and standardize the text - Font size - 14, Font stye - Calibri, Font colour
    4. Select entire worksheet - Use Auto-Fit to adjust column width and row height.
    5. With the entire worksheet selected - Align Text Left (Horizontal) and Align Text Middle (Vertica
    6. Highlight rows 13-16 and 20-26 (use the Ctrl key to select non-adjacent rows)
    7. Insert a new Column to the left of Column A. In the new cell A2 enter "Category".
    8. In cell A3 enter "Furniture". Use the fill-handle to replicate this value into cells A4:A10.
    9. In cell A13 enter "Hardware". Use the fill-handle to replicate this value into cells A14:A17.
    10. In cell A20 enter "Supplies". Use the fill-handle to replicate this value into cells A20:A31.
    11. Auto-Fit the column width for Column A.
    12. Edit Cell B2 to "Item".
    13. Select non-adjacent rows 11,12,18,19 and delete them.
    14. Highlight Cells A2:F2 and apply bold text formatting and yellow fill colour.
    15. Insert a new row above row 1.
    16. In the new cell A1, type in the title "Planned Inventory (new offfice)" - font style
    17. Merge cells A1:F1 and align text left and align text middle. (The grey title cell shoud span the w
    within the cell.)
    18. Change the cell fill colour of the title cell to dark grey. Change the font colour to white.
    19. Highlight rows 1 and 2, increase the row height of row 1 slightly. (Since they are highlighted, b
    20. Insert a new column to the right of Column D. Name it "Total Price". Auto-fit the column width
    21. Refer to Column A. Merge the cells for each category. (For example, merge cells A4:A11 for "F
    22. Bold the Category names and give each cell a different fill colour. (Furniture
    to select a colour shade.
    23. Highlight cell range D4:E28. Change the cell range number format to "Currency". Remove deci
    cells.
    24. Edit the cells in column C to standardise them so that they are all numerical values only. (e.g.
    25. Highlight Column C and align text centre.
    24. Edit the cells in column C to standardise them so that they are all numerical values only. (e.g.
    25. Highlight Column C and align text centre.
    26. Highlight the cells in the Remarks column (G4:G28) and apply italics.
    27. Refer to the bottom of the worksheet. The legend shows you the cell format for items which a
    Painter to copy the cell format for these items and apply it to the following items:
    *Hint - double-click so that format painter remains active.
    Member Discount:
    Whiteboards
    Clock
    Photocopier
    Notebooks
    Ring Binders
    Stapler
    Out of Stock Items:
    Reception Desk
    Filing Cabinets
    Printer

    28. Set page breaks in this current worksheet, such that every separate category (Furniture, Hard
    29. Set page orientation to Landscape.
    30. Set to print titles such that the Rows 1-3 "Planned Inventory (new office)" and the column he
    preview, the first 2 pages should display the title cell, column headers and the three categories in
    are cut off.
    31. Protect this current worksheet, by setting a password "food2go", such that u
    to do things your way! Ishan is proud that Food2Go has grown so quickly and they are soon moving to
    s suppliers for furniture, hardware and office supplies. Ishan has shortlisted some items and just
    the place!

    t visually appealing by applying the skills learned in Modu le 2.

    Calibri, Font colour - black, remove bold, remove italics.


    row height.
    nd Align Text Middle (Vertical).
    acent rows) - remove cell fill colour.
    ter "Category".
    ue into cells A4:A10.
    alue into cells A14:A17.
    alue into cells A20:A31.

    ll colour.

    font style - Calibri, bold text, font size - 20.


    rey title cell shoud span the width of the table, and the title should on the left but centred vertically

    e font colour to white.


    (Since they are highlighted, both will change to the same row height.)
    ce". Auto-fit the column width for this new column, and centre text.
    ple, merge cells A4:A11 for "Furniture".)
    (Furniture - light green, Hardware - light blue, Supplies - light purple) Use the "more colours" option

    t to "Currency". Remove decimal places, include comma separator for thousands, centre align the

    numerical values only. (e.g. change "one" to "1" and "10 packs" to "10")
    numerical values only. (e.g. change "one" to "1" and "10 packs" to "10")

    cell format for items which are eligible for member discounts and out of stock items. Use Format
    lowing items:

    category (Furniture, Hardware, Supplies) are printed on an individual page.

    w office)" and the column headers are repeated at the top of all pages when printed. When you print
    rs and the three categories individually. The last three pages will display the remarks columns which

    , such that users are only allowed to select locked and unlocked cells.
    hey are soon moving to
    me items and just

    but centred vertically

    more colours" option

    ds, centre align the


    items. Use Format

    nted. When you print


    marks columns which

    You might also like