Assignment 2: Using logical operators AND, OR, NOT, IF, etc, work through each of the 4 problems found in this sheet.Assignment 2 - Excel 46B.xlsx \pm In problems 1,2,3,try to complete the problems using IF statements, only. In problems 1a,2a,3a, try to complete the problems using AND/OR logicals. You may need to combine them, give it a shot! For questions regarding the bonus, let's assume: a 5% bonus on average sales if the store is in the East territory. 3. For question 4, determine the bonus computed at 5% of the sales of the quarter with the largest sales if the store is in the East territory and if the sales of either quarter are greater than $20,000. You will likely need to use some combination of IF, AND, OR. Generally, think about this like a puzzle, and solve small portions of the larger problem. Good luck