Hello, I am really struggling with this Excel question. I would really appreciate any help. Thanks!

1.7 Complete the alculations in Table 4. a. Notice that the salespeople have automatically populated based on the salespeople pasted into table 2. b. Use appropriate conditional aggregate functions in columns J and K. c. When possible, reuse the formulas you create in row 41 of table 4 to complete the calculations for the rest rows in the table. Table 4 1.7 Complete the alculations in Table 4. a. Notice that the salespeople have automatically populated based on the salespeople pasted into table 2. b. Use appropriate conditional aggregate functions in columns J and K. c. When possible, reuse the formulas you create in row 41 of table 4 to complete the calculations for the rest rows in the table. Table 4