please help me do it and explain using the excel shee i provided.

do not answer this

A. % o v 4 Conditional Formatting Format as Table Cell Styles Cells Editing Ideas Clipboard Font Number Alignment D30 fx F G H E D B 2 Total Precision Design and Packaging 1 Bulk Container 2015 Manufacturing Units 2 (in thousands) Model Description East West North South 3 Sumber 4 D-1140 Gaylord with lid 2,531 3,251 4,215 3,845 5 D-2185 Premium Gaylord with lid 2,251 3,157 4,185 3,214 6D-1150 Gaylord bottom 5,234 5,584 6,145 4,832 7 D-1155 Gaylord lid 5,234 5,584 6,145 4,832 8 D-3695 Telescoping top and bottom 10,253 12,458 11,254 14,853 9 D-3698 Telescoping bottom 8,532 8,863 9,145 7,745 10 D-3699 Telescoping top 7,541 8,651 8,842 7,652 11 D-4100 Additional lids for telescoping containers 4,352 3,487 2,214 4,832 12 D-4200 "D" 4-piece container 3,475 4,278 5,513 4,862 13 D-4415 "EU" container 3,251 4,577 5,914 5,142 14 D-5367 "EH"container 2,534 3,014 4,437 5,684 15 D-6418 "E" container 6,523 6,988 7,214 6,348 16 D-7459 Economy R.S.C. 6,325 6,942 6,845 6,512 17 D-8854 Premium R.S.C. 5,214 5,748 6,145 6,327 18 D-9101 Corrugated pads 15 x 15 15,241 18,241 16,854 17,458 19 D-9105 Corrugated pads 20 x 12 16,325 19,652 22,418 20,463 20 D-9110 Corrugated pads 24 x 18 12,453 15,874 17,698 18,496 21 D-9115 Corrugated pads 30 x 30 8,653 8,846 9,154 7,763 22 Total 125,922 145,195 154,337 150,860 23 24 Proof of Total 25 26 13,842 12,807 21,795 21,795 48,818 34,285 32,686 14,885 18,128 18,884 15,669 27,073 26,624 23,434 67,794 78,858 64,521 34,416 576,314 576,314 1. Open PreMfg Targets.xlsx, 2. Save the workbook and name it EL2-C6-A2-PreMfg Targets. 3. Share the workbook. 4. Change the user name to Lorne Moir and then edit the following cells: Cil: from 4,352 5520 C18: from 15,241 15960 5. Save the workbook. 6. Open a new instance of Excel. Note: Refer to Project 2c to open a new instance of Excel to to to 7. Change the user name to Gerri Gonzales, open EL2-C6-A2-PreMfg Targets.is and then edit the following cells: F4: from 3,845 to 5126 F9: from 7,745 9320 8. Save the workbook. 9. Create a history sheet with a record of the changes made to the data by all of the users. 10. Print the history sheet. Note: If you submit your assignment work electronically, create a copy of the history sheet in a new workbook, since the history sheet is automatically deleted when the file is saved. 11. Save and then close both instances of EL2-C6-A2-PreMfg Targets.xlsx 12. Change the user name back to the original user name for the computer you are using A. % o v 4 Conditional Formatting Format as Table Cell Styles Cells Editing Ideas Clipboard Font Number Alignment D30 fx F G H E D B 2 Total Precision Design and Packaging 1 Bulk Container 2015 Manufacturing Units 2 (in thousands) Model Description East West North South 3 Sumber 4 D-1140 Gaylord with lid 2,531 3,251 4,215 3,845 5 D-2185 Premium Gaylord with lid 2,251 3,157 4,185 3,214 6D-1150 Gaylord bottom 5,234 5,584 6,145 4,832 7 D-1155 Gaylord lid 5,234 5,584 6,145 4,832 8 D-3695 Telescoping top and bottom 10,253 12,458 11,254 14,853 9 D-3698 Telescoping bottom 8,532 8,863 9,145 7,745 10 D-3699 Telescoping top 7,541 8,651 8,842 7,652 11 D-4100 Additional lids for telescoping containers 4,352 3,487 2,214 4,832 12 D-4200 "D" 4-piece container 3,475 4,278 5,513 4,862 13 D-4415 "EU" container 3,251 4,577 5,914 5,142 14 D-5367 "EH"container 2,534 3,014 4,437 5,684 15 D-6418 "E" container 6,523 6,988 7,214 6,348 16 D-7459 Economy R.S.C. 6,325 6,942 6,845 6,512 17 D-8854 Premium R.S.C. 5,214 5,748 6,145 6,327 18 D-9101 Corrugated pads 15 x 15 15,241 18,241 16,854 17,458 19 D-9105 Corrugated pads 20 x 12 16,325 19,652 22,418 20,463 20 D-9110 Corrugated pads 24 x 18 12,453 15,874 17,698 18,496 21 D-9115 Corrugated pads 30 x 30 8,653 8,846 9,154 7,763 22 Total 125,922 145,195 154,337 150,860 23 24 Proof of Total 25 26 13,842 12,807 21,795 21,795 48,818 34,285 32,686 14,885 18,128 18,884 15,669 27,073 26,624 23,434 67,794 78,858 64,521 34,416 576,314 576,314 1. Open PreMfg Targets.xlsx, 2. Save the workbook and name it EL2-C6-A2-PreMfg Targets. 3. Share the workbook. 4. Change the user name to Lorne Moir and then edit the following cells: Cil: from 4,352 5520 C18: from 15,241 15960 5. Save the workbook. 6. Open a new instance of Excel. Note: Refer to Project 2c to open a new instance of Excel to to to 7. Change the user name to Gerri Gonzales, open EL2-C6-A2-PreMfg Targets.is and then edit the following cells: F4: from 3,845 to 5126 F9: from 7,745 9320 8. Save the workbook. 9. Create a history sheet with a record of the changes made to the data by all of the users. 10. Print the history sheet. Note: If you submit your assignment work electronically, create a copy of the history sheet in a new workbook, since the history sheet is automatically deleted when the file is saved. 11. Save and then close both instances of EL2-C6-A2-PreMfg Targets.xlsx 12. Change the user name back to the original user name for the computer you are using