logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Hiamnshu BholaData mining
(5/5)

910 Answers

Hire Me
expert
Bryan CoxComputer science
(5/5)

615 Answers

Hire Me
expert
Mette BabstockScience
(5/5)

988 Answers

Hire Me
expert
Manning DaleResume writing
(5/5)

672 Answers

Hire Me
Excel
(5/5)

One of the exciting things about working in a startup is the flexibility to do things your way!

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Module 2 Assignment

Overview

One of the exciting things about working in a startup is the flexibility to do things your way! Ishan is proud that Food2Go has grown so quickly and they are soon moving to a new office of their own. Food2Go has received quotes from various suppliers for furniture, hardware and office supplies. Ishan has shortlisted some items and just 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 applying the skills learned in Module 2.

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 - black, remove bold, remove italics.

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 (Vertical).

6. Highlight rows 13-16 and 20-26 (use the Ctrl key to select non-adjacent rows) - remove cell fill colour.

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 - Calibri, bold text, font size - 20.

17. Merge cells A1:F1 and align text left and align text middle. (The grey title cell shoud span the width of the table, and the title should on the left but centred vertically 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, both will change to the same row height.)

20. Insert a new column to the right of Column D. Name it "Total Price". Auto-fit the column width for this new column, and centre text.

21. Refer to Column A. Merge the cells for each category. (For example, merge cells A4:A11 for "Furniture".)

22. Bold the Category names and give each cell a different fill colour. (Furniture - light green, Hardware - light blue, Supplies - light purple) Use the "more colours" option to select a colour shade.

23. Highlight cell range D4:E28. Change the cell range number format to "Currency". Remove decimal places, include comma separator for thousands, centre align the cells.

24. Edit the cells in column C to standardise them so that they are all numerical values only. (e.g. change "one" to "1" and "10 packs" to "10")

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 are eligible for member discounts and out of stock items. Use Format Painter to copy the cell format for these items and apply it to the following items:

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

273 Experts Online