As a manager of a small business, you need to calculate bonuses, create an inventory search tool, plan for a trades how, and determine if the company can purchase a new vehicle with branding for shows. Perform the following actions:

$1.$ On the Sales Bonus sheet, use a logical function to determine the bonus for each employee based on their attainment in column E$.$

$2.$ On the Search sheet, in cell B$4,$ use the appropriate lookup function to return the price for any product specified in cell B$1.$ Use the name Products to reference the cell range D$1$:S$4.$

$3.$ On the Search sheet, in cell B$7,$ use the appropriate lookup function to return the average customer rating from the rating sheet for any product specified in cell B$1.$

$4.$ On the Tradeshow sheet, in cell C$10,$ calculate the deadline date to be the specified number of days in B$10,$ which contains the number of days before the show begins. No work will be done on weekends or any of the dates in the Holidays named range.

$5.$ On the Loan sheet, in cell D$6,$ use the appropriate function to determine how many months it will take to pay off the loan amount.