if you arent sure about the answer, please let someone who does answer it . thank you !

May NI Sheet2 Sheet3 May Rey E2 E3 E4 ES E6 $17,913.35 $787.40 $1,159.45 $187.01 S2,362.20 $12,007.85 $116.14 May Net Income $1,293.301 P(1) P(2) P(3) P(4) P(5) Assumptions Using the Defined Name feature Excel, nape each column in the below Proper Data Set. Then using the correct Defined Name, Absolute Cell Reference and Relative Cell Reference, create a formula to Add Sales for Each froduct that Modi Sold in cell H8 and then copy through the range H8:H10. Date SalesRep Abdi Total Sales Product Quad Carlota Bellen Product SalesRep Sales 11/18/19 Quad Sioux 73.62 11/18/19 Carlota Chantel 113.8 11/18/19 Quad Tyrone 184.61 11/18/19 Carlota Chantel 19.25 11/18/19 Bellen Abdi 139.83 11/18/19 Bellen Sioux 153.31 11/18/19 Carlota Chantel 104.38 11/18/19 Quad Tyrone 185.21 11/18/19 Quad Chantel 38.31 11/18/19 Bellen Abdi 154.66 11/18/19 Bellen Sioux 26.75 11/18/19 Bellen Chantel 17.71 11/18/19 Carlota Tyrone 101.83 11/18/19 Carlota Chantel 104 11/18/19 Carlota Abdi 148.97 11/18/19 Quad Sioux 146.31 11/18/19 Carlota Chantel 197.01 11/18/19 Quad Tyrone 188.32 11/18/19 Bellen Chantel 20.54 May NI Sheet2 Sheet3 May Rey E2 E3 E4 ES E6 $17,913.35 $787.40 $1,159.45 $187.01 S2,362.20 $12,007.85 $116.14 May Net Income $1,293.301 P(1) P(2) P(3) P(4) P(5) Assumptions Using the Defined Name feature Excel, nape each column in the below Proper Data Set. Then using the correct Defined Name, Absolute Cell Reference and Relative Cell Reference, create a formula to Add Sales for Each froduct that Modi Sold in cell H8 and then copy through the range H8:H10. Date SalesRep Abdi Total Sales Product Quad Carlota Bellen Product SalesRep Sales 11/18/19 Quad Sioux 73.62 11/18/19 Carlota Chantel 113.8 11/18/19 Quad Tyrone 184.61 11/18/19 Carlota Chantel 19.25 11/18/19 Bellen Abdi 139.83 11/18/19 Bellen Sioux 153.31 11/18/19 Carlota Chantel 104.38 11/18/19 Quad Tyrone 185.21 11/18/19 Quad Chantel 38.31 11/18/19 Bellen Abdi 154.66 11/18/19 Bellen Sioux 26.75 11/18/19 Bellen Chantel 17.71 11/18/19 Carlota Tyrone 101.83 11/18/19 Carlota Chantel 104 11/18/19 Carlota Abdi 148.97 11/18/19 Quad Sioux 146.31 11/18/19 Carlota Chantel 197.01 11/18/19 Quad Tyrone 188.32 11/18/19 Bellen Chantel 20.54