Complete the assignment showing steps in excel

es Paragraph On Sheet 1, compute and display the bonus amount in 33. Domestic, full time employees receive 7% bonus; international, full time employees receive 6%; domestic, part time employees receive 5%; international, part time employees receive 4%; others, receive 3%. Copy the function/formula down the column. On Sheet 1, compute and display the annual leave in K3. Full time employees hired before January 2011 or domestic employees whose total sales are above $250,000 are entitled to 20 10.000 3 3 annual leave days. Others are entitled to 10 annual leave days. 20.000 Copy the function/formula down the column On Sheet 2, use advanced filter to display part time, domestic employees whose total sales are below $250,000 or full time, international employees hired in 2016. 10.000 The criteria range must begin in A18 and the result in A23. On Sheet 3, use advanced filter to display domestic employees whose total sales are between 10.000 5 $240,000 and $260,000 or who were hired in 2017 The criteria range must begin in A18 and the result in A23. on Sheet 4, compute and display the class in 12. An art is lassied as Marketabl if the art meets all of the these criteria; Limited edition print or limited edition canvas, Sold out, The estimated value is between $2,000 and $3,000, and Released in 1991. Otherwise, an art is dlassified as dass Peculiar. Copy the function/formula down the column. On Sheet 5, use advanced filter to display WR (wide receivers) or DE (defensive ends) whose 2016 salaries are above $15,000,000 or below $400,000. The criteria range must begin in H1 and the result in H7. 10.000 On Sheet 6, use advanced filter to display players whose 2016 salaries are above $15,000,000 or below $400,000 playing in NFC North division or AFC North division. The criteria range must begin in H1 and the result in H7 10.000 On Sheet 7, use advanced filter to display QB (quarterbacks) whose salaries are above $12,000,000 playing in Arizona Cardinals, Carolina Panthers, Dallas Cowboys, Green Bay Packers, or New England Patriots 10.000 The criteria range must begin in H1 and the result in H10