I really don't know how to use sumif() or if() in excel, can someone help me with this question

M N O Q R S T U V W Y A B D E F G . J K 1 IF, Vlookup 2 20 Points 3 4 The following table lists employees and whether they have completed the three training programs offered by the company. 5 Complete the table, writing formulas using the IF AND functions in the yellow-shaded cells (E12:E16). 6 Either "Complete" or "Incomplete" should appear under "All Programs Completed?" 7 8 9 10 Employee Training Programs Products and Diversity and All Programs 11 Employee No Orientation Services Inclusion Completed? 12 203 Yes No Yes 13 461 Yes Yes Yes 14 307 No Yes Yes 15 102 Yes No No 16 190 Yes Yes Yes 17 18 20 21 Write a VLOOKUP formula in C34 that finds the correct tax rate based on the income entered in C32. Then, write a formula in C35 to calculate total tax owed. 22 Income 23 Income Tax Rate 24 $ 0% 25 $ 25,000.00 15% 26 $ 50,000.00 20% 27 $ 75,000.00 25% 28 $ 100,000.00 30% 29 $ 125,000.00 35% 30 31 32 Please enter your income 52,000.00 33 34 Your Income Tax Rate is 35 Total Tax Owed 36 38 Provided the information in the HLOOKUP Table, create HLOOKUP formulas for cells C50 and 39 C51 that lookup the information for the ID entered in cell C48. 40 A G H J B D E F 28 $ 100,000.00 30% 29 $ 125,000.00 35% 30 31 32 Please enter your income $ 52,000.00 33 34 Your Income Tax Rate is 35 Total Tax Owed 36 38 Provided the information in the HLOOKUP Table, create HLOOKUP formulas for cells C50 and 39 C51 that lookup the information for the ID entered in cell C48. 40 41 HLOOKUP Table 42 Employee ID 101 102 103 104 105 43 First Name Miyoko Wei Brock Rebbeca Lory 44 Last Name Krebs Zhang Madrid Hagen Wilkinson 45 Department Accounting Marketing Operations Sales Sales 46 47 48 Employee ID 103 49 50 First Name 51 Last Name 52 53 54 55 56