Write a formula in E2 that would find if you are Qualified (Yes or No) for a bonus; you should be a manager and hired before 1/1/2021. It should be an accurate statement so I can fill it in the column. Write the complete formula. A B D E Name Title Hire Date Salary Qualified 1 Admas 3 Bacarella Manager Account Rep 2/5/2022 $ 68,750.00 5/8/2019 $ 49,575.00 4 Chen 5 Deberard Manager Account Rep 3/9/2022 $ 75,800.00 12/14/2021 $ 46,795.00 6 Hart Account Rep 3/18/2021 $ 45,000.00 7 Laing 8 Lenny Manager Account Rep 1/17/2019 $ 65,500.00 5/20/2022 $ 49,750.00