7.2 In cell C2 under the HomeOverDrive, enter any 6 -digit number starting with a 6 with the last two numbers as decimal values. For example: 6543.21. Format the number to match B2. In cell B6, create a sinale function to calculate the amount of the monthly payment. BCMP Refresh will be contributing $500 towards the purchase price. Use appropriate addressing schemes and cell referencing. Copy only the function to the C column to determine the monthly payments for the second computer option. The answers will appear as peoative as this is a payroll deduction. (4) 7.3 Select the 9. Annual Income Summary worksheet. In cell D2 lookup the location of the regional offices for each employee, an exact match and absolute values are required. Copy the results for all employees. (3) 7.4 BCMP Refresh offers a generous bonus for sales performance. In cell F2 apply a conditional function that will reward employees who have sales exceeding $100,000 with bonuses by paying 10% of the total sales on the amount oyer the threshold of $100,000 and for employees not achieving bonuses, display the text No Bonus. Copy the results for all employees. (3) \begin{tabular}{l} 1 \\ 2 \\ 3 \\ 4 \\ \hline 5 \\ 6 \\ 7 \\ 8 \end{tabular} WorkGeek $2,799.00 $500 11% 24 Monthly Payments Deducted 7.2 In cell C2 under the HomeOverDrive, enter any 6 -digit number starting with a 6 with the last two numbers as decimal values. For example: 6543.21. Format the number to match B2. In cell B6, create a sinale function to calculate the amount of the monthly payment. BCMP Refresh will be contributing $500 towards the purchase price. Use appropriate addressing schemes and cell referencing. Copy only the function to the C column to determine the monthly payments for the second computer option. The answers will appear as peoative as this is a payroll deduction. (4) 7.3 Select the 9. Annual Income Summary worksheet. In cell D2 lookup the location of the regional offices for each employee, an exact match and absolute values are required. Copy the results for all employees. (3) 7.4 BCMP Refresh offers a generous bonus for sales performance. In cell F2 apply a conditional function that will reward employees who have sales exceeding $100,000 with bonuses by paying 10% of the total sales on the amount oyer the threshold of $100,000 and for employees not achieving bonuses, display the text No Bonus. Copy the results for all employees. (3) \begin{tabular}{l} 1 \\ 2 \\ 3 \\ 4 \\ \hline 5 \\ 6 \\ 7 \\ 8 \end{tabular} WorkGeek $2,799.00 $500 11% 24 Monthly Payments Deducted