1. Business
  2. Operations Management
  3. yo excel16ch01 ps2 v2 project description darn lean recentiy open...

Question: yo excel16ch01 ps2 v2 project description darn lean recentiy open...

Question details

YO Excel16_Ch01 PS2 v2 Project Description: Darn Lean recentiy open a smal sporting goods store next to the local commuity coege. He wants to use Excel to track supply inventory, the total cast of inventory, as wel as items on back order. Dann has crested a workbook containing a ist of the products in inventory, a ist of tems on back order, and a documentaton worksheet You have been asked enhance the appearance of the worksheets, edit content, insert comments, and improve overal formatting, making the informaton easier to rewew and anayze. Delate row 3 Change the color of the Inventory worksheet tab to Red Change to the width of the workshest columns as followE Columns A. F and K to 17 Columns B,C, D, G, H, I, L, M, N to 8 12 13 On the BadkOrdars worksheet tab, apply Conter Acroas Salaction to range Al:D2 For the purpose of grading the project you are required to perform the following tasks: Step In cell C6, enter Dste Ordered as 12/15/18. In cell D6, nter the Date to be Received as 12/29/18. Use the AutoFil handle to copy call range C6:DS through CS:D8. 14 Save the file with the Start Excel. Open the file named e0ich0L grader name c01ch01 gradora using your lst and first name 15 Delete Sheet3. Rename Sheet1 as Inventory. Rename Sheet2 as BackOrders On the Inventory worksheet, inserta page header into the middla section. Type All Sports Athletics. Incert the fila nama coda into the laft footer of all workchests in the workbook. Return al worksheets to Normal view. 3 On the Invenbory worksheet, in cell A27, insert the comment Unisex. On the Documentation workshast, in coll AB, type todays dato. In B8, type your name in Firstname Lastname format. Ln cell CB, type Formatted Inventory worksheet in coll C9, 17 In cell A17, edit the contents to reed Inventory, the BackOrders worksheet For the Inventory and Documentation worlchees, set Orientation to Landaope, and at the scaling to Fit All Columns on One Page 18 10 Center align and wrap the text in the following cel ranges: BALA, B10:L10. B17:D17, and 19 Save the workbook, exit Excel, and then submit your fles as directed by your instructor. In call A25, using the ALT and ENTER kays, insert a hard return behveen Miscelaneous tes Be sure to remove the space Total Points 100 Insert a column to the left of column E. Insert a colummn to the let of column Change the width of columns E and to 5. Copy the contents of cell D18 down through D23 Copy the contents of cl D26 down through D28 Move the infarmaton in the cel range A2S:D28 to F17:120. 10 Merge and center the contents in cel Al through the range AliN1.AutoSave (Off File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be carefuk-files from the Internet can contain viruses. Unless you need to edit, its safer to stay in Protected View. Enable Editing alani _e01ch01 grader a1 Athletics Protected View - Excel Sign in A1 .fi All Sports Athletics 1All Sports Athletics 4 Mens Clothing Price per UrQuantity in Total Cost of Inventory S T-shirts (s) 6 T-shirts (m) 7 T-shirts (I) 8 T-shirts (xl) Price per UQuantity in Total Cost of Inventory Price per UQuantity in Total Cost of Invent 15.99 15.99 15.99 15.99 26 20 25 12 415.74 Athletic shorts (s) 319.80 Athletic shorts (m) 399.75 Athletic shorts (I) 191.88 Athletic shorts (xl) 16.99 16.99 16.99 16.99 27 $ 458.73 Calf-high socks 22 $ 373.78 Ankle socks 19 322.81 Compression socks 24 $ 407.76 8.99 8.99 15.99 25 224.75 24 $ 215.76 10 159.90 10 Womens Clothi Price per UiQuantity in Total Cost of Inventory 11 T-shirts (xs) 12 T-shirts (s) 13 T-shirts (m 14 T-shirts (1) 15 T-shirts (xl) Price per UQuantity in Total Cost of Inventory Price per UQuantity in Total Cost of Invent 14.99 14.99 14.99 14.99 14.99 18 269.82 Athletic shorts (xs16.99 20 $ 299.80 Athletic shorts (s) 25 374.75 Athletic shorts (m) 10 $ 149.90 Athletic shorts (I) 25 $ 374.75 Athletic shorts (xl) 16.99 16.99 16.99 16.99 16 271.84 Calf-high socks 22 $ 373.78 Ankle socks 25 $ 424.75 Compression socks 20 $ 339.80 27 $ 458.73 8.99 8.99 15.99 29 260.71 18 161.82 5 79.95 17 Other Items 18 Basketballs 19 Soccer balls 20 Vollevballs Price per UiQuantity in Total Cost of Inventory 25.99 22.99 17.99 10 $ 259.90 Sheet Sheet2 Documentation Sheet3

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution