what is the correct cell formatting?

Best Computer Company Premium Desktop Gaming Compter Product Cost Part Number 00100 00600 00800 00300 00500 00400 00700 00900 Description Coursair Obsidian 7500 CC ATX Full Tower Computer Case ASUS AMD AM4 ROG Strix Gaming ATX Motherboard AMD Ryzen 9 3900X 12 Core 3.8 GHz Processor Corsair Hydro Series H150i PRO 240mm Water/liquid CPU Cooler G. SKILL TridentZ RGB Series 32GB SDRAM DDR4 3600 Nvidia GeForce RTC 2080 Ti Graph Card 11GB Corsair RMx Series RM850x 850 Watt Power Source Crucial MX500 2TB SATA III Internal Solid State Drive Total Materials Direct Labor Overhead Total Cost per Unit Total Unit of Units Cost per Product Measure Required Component Cost ea 1.00 152 152 ea 1.00 272 272 ea 1.00 424 424 ea 1.00 152 152 ea 1.00 157 157 ea 1.00 1000 1000 ea 1.00 120 120 ea 1.00 408 408 3.00 10100 10200 00200 hr hr 3.00 20 60 11 33 2778 Best Computer Company Premium Descktop Computer - Power Users Cost per Part Number 00100 00610 00820 00510 00410 00700 00910 Description Coursair Obsidian 7500 CC ATX Full Tower Computer Case ASUS AM4 TUF Gaming X57--Plus ATX Motherboard with PCIe 4.0 AMD Ryzen 7 3800X 8- Core 3.9 GHZ Processor w/Corsair Hydro water cooler G. SKILL Tridentz RGB Series 16GB SDRAM DDR4 3200 Nvidia GeForce GTX 970 Graphic Card 4 GB Corsair RMx Series RM850x 850 Watt Power Source Crucial MX500 2TB SATA III Solid State Drive Total Materials Direct Labor Overhead Total Cost per Unit Unit of Units Measure Required Component ea 1.00 152 ea 1.00 180 ea 1.00 408 ea 1.00 80 ea 1.00 400 ea 2.00 120 ea 1.00 192 152 180 408 80 400 240 192 10100 10200 00210 hr hr 2.00 2.00 20 11 40 22 1714 Product Costs Worksheet: Step 1: Use the V look-up function and the part number given, complete "costs per unit for the respective types of computers. For reference on how to write Vlookup function, please see link at "Vlookup Function from MS Excel" (Hint: you may also want to use an absolute reference to lock the range referenced in the vlook up function). Step 2: Calculate the overhead cost per direct labor hour based on the overhead cost shown in the "Inventory Master File". The estimated direct labor hours for the year will be provided. Use that information and the direct labor rate per hour to finish calculating the total cost each of the products. Feel free to add column as needed (for example, you should add a column called "Total cost") Step 3: Calculate the total material cost and total cost per a computer unit. Best Computer Company Premium Desktop Gaming Compter Product Cost Part Number 00100 00600 00800 00300 00500 00400 00700 00900 Description Coursair Obsidian 7500 CC ATX Full Tower Computer Case ASUS AMD AM4 ROG Strix Gaming ATX Motherboard AMD Ryzen 9 3900X 12 Core 3.8 GHz Processor Corsair Hydro Series H150i PRO 240mm Water/liquid CPU Cooler G. SKILL TridentZ RGB Series 32GB SDRAM DDR4 3600 Nvidia GeForce RTC 2080 Ti Graph Card 11GB Corsair RMx Series RM850x 850 Watt Power Source Crucial MX500 2TB SATA III Internal Solid State Drive Total Materials Direct Labor Overhead Total Cost per Unit Total Unit of Units Cost per Product Measure Required Component Cost ea 1.00 152 152 ea 1.00 272 272 ea 1.00 424 424 ea 1.00 152 152 ea 1.00 157 157 ea 1.00 1000 1000 ea 1.00 120 120 ea 1.00 408 408 3.00 10100 10200 00200 hr hr 3.00 20 60 11 33 2778 Best Computer Company Premium Descktop Computer - Power Users Cost per Part Number 00100 00610 00820 00510 00410 00700 00910 Description Coursair Obsidian 7500 CC ATX Full Tower Computer Case ASUS AM4 TUF Gaming X57--Plus ATX Motherboard with PCIe 4.0 AMD Ryzen 7 3800X 8- Core 3.9 GHZ Processor w/Corsair Hydro water cooler G. SKILL Tridentz RGB Series 16GB SDRAM DDR4 3200 Nvidia GeForce GTX 970 Graphic Card 4 GB Corsair RMx Series RM850x 850 Watt Power Source Crucial MX500 2TB SATA III Solid State Drive Total Materials Direct Labor Overhead Total Cost per Unit Unit of Units Measure Required Component ea 1.00 152 ea 1.00 180 ea 1.00 408 ea 1.00 80 ea 1.00 400 ea 2.00 120 ea 1.00 192 152 180 408 80 400 240 192 10100 10200 00210 hr hr 2.00 2.00 20 11 40 22 1714 Product Costs Worksheet: Step 1: Use the V look-up function and the part number given, complete "costs per unit for the respective types of computers. For reference on how to write Vlookup function, please see link at "Vlookup Function from MS Excel" (Hint: you may also want to use an absolute reference to lock the range referenced in the vlook up function). Step 2: Calculate the overhead cost per direct labor hour based on the overhead cost shown in the "Inventory Master File". The estimated direct labor hours for the year will be provided. Use that information and the direct labor rate per hour to finish calculating the total cost each of the products. Feel free to add column as needed (for example, you should add a column called "Total cost") Step 3: Calculate the total material cost and total cost per a computer unit