Assignment Instructions Assignment Instructions 6 Remove duplicate records from the table. Excel should find and remove one dupilicate record. 7 Create an unqualified structured reference in column 6 to 10. determine the value of the inventory on hand and apply Accounting Number Format To calculate the inventory on hand, multiply the Unit Price and the Amount on Hand 8. Apply a Total Row to the Inventory2023 table, set the 16 Inventory Value to Sum and the Amount on Hand to Average Format the results to display with two decimal points. 9. Create a new condtional formatting rule that displays any 14 Inventory Value in column G for the Food \& Heaith department with a value of $30,000 or more as Red fill color (second column, last row). There will be two qualifying entries Note. Mac users select the range G2 G78. Then in the New. Formatting Rule dialog box, select the style Classic 10 Ensure the warehouse information is not broken up betiveen 10 nanes when neinted Adit a nana hreak tn maka auire that Assignment Instructions Inventory Value in column G for the Food \&. Health department with a value of 530,000 or more as Red fill color (second column, last row). There will be two qualifying entries Note, Mac users select the range 62:678. Then in the New Formatting Rule dialog box select the style Classic. 10 Ensure the warehouse information is not broken up between 10 pages when printed. Add a page break to make sure that each warehouse prints on its own consecutive page 11 Set the worksheet to Landscape orientation. and repeat row 1 10 labels on all pages 12. Insert a footer with your name on the left side, the sheet 5 name code in the center, and the file name code on the right side of the sheet. Display the Inventory sheet in Page Break Preview. 13. Save and close ExP19_Excel_CH04_ML1_HW_PetSupplies.xisx. Exit Excel. Submit the file as directed. Assignment Instructions Assignment Instructions 6 Remove duplicate records from the table. Excel should find and remove one dupilicate record. 7 Create an unqualified structured reference in column 6 to 10. determine the value of the inventory on hand and apply Accounting Number Format To calculate the inventory on hand, multiply the Unit Price and the Amount on Hand 8. Apply a Total Row to the Inventory2023 table, set the 16 Inventory Value to Sum and the Amount on Hand to Average Format the results to display with two decimal points. 9. Create a new condtional formatting rule that displays any 14 Inventory Value in column G for the Food \& Heaith department with a value of $30,000 or more as Red fill color (second column, last row). There will be two qualifying entries Note. Mac users select the range G2 G78. Then in the New. Formatting Rule dialog box, select the style Classic 10 Ensure the warehouse information is not broken up betiveen 10 nanes when neinted Adit a nana hreak tn maka auire that Assignment Instructions Inventory Value in column G for the Food \&. Health department with a value of 530,000 or more as Red fill color (second column, last row). There will be two qualifying entries Note, Mac users select the range 62:678. Then in the New Formatting Rule dialog box select the style Classic. 10 Ensure the warehouse information is not broken up between 10 pages when printed. Add a page break to make sure that each warehouse prints on its own consecutive page 11 Set the worksheet to Landscape orientation. and repeat row 1 10 labels on all pages 12. Insert a footer with your name on the left side, the sheet 5 name code in the center, and the file name code on the right side of the sheet. Display the Inventory sheet in Page Break Preview. 13. Save and close ExP19_Excel_CH04_ML1_HW_PetSupplies.xisx. Exit Excel. Submit the file as directed