I need help with these questions. Willing to extend the deadline and price for good accurate answers.

9. See the screenshot below. What function can be used in cell E5 to find the unit sales of the person selected in cell E4? (Assume that the range A1:B20 has been named lookup.) Choose answer below: =LOOKUP(E4,lookup,B,TRUE) =LOOKUP(E4,lookup,B,FALSE) =VLOOKUP(E4,lookup,2,TRUE) =VLOOKUP(E4,lookup,2,FALSE) =HLOOKUP(E4,lookup,2,TRUE) =HLOOKUP(E4,lookup,2,FALSE) 10. Again refer to the screenshot below. Which of the following is another way of retrieving the appropriate value for unit sales, given a name entered in cell E4? Choose Answer Below: =INDEX(B1:B20, MATCH(E4,A2:A20,0)) =INDEX(B2:B20, MATCH(E4,A2:A20,0)) =INDEX(B1:B20, MATCH(E4,A2:A20,1)) =INDEX(B2:B20, MATCH(E4,A2:A20,1)) =MATCH(E4,INDEX(B1:B20),0) =MATCH(E4,INDEX(B2:B20),0) =MATCH(E4,INDEX(B1:B20),1) =MATCH(E4,INDEX(B2:B20),1) 11. Again refer to the screenshot below. Suppose we would like to create a drop down box in cell E4 so that the user could enter a name by selecting the name from a list. One way of accomplishing this would be via the _________ (twoword answer) feature from the Ribbon. 17. Again refer to the screenshot below. Suppose we want to use the Subtotal feature to create a summary of our sales data that lists the total units sold by each salesperson in January, followed by the total units sold by each salesperson in February, etc. What sort order should be implemented before running the subtotals? Choose Answer Below Sort by Month Sort by Name Sort by Units Sold Sort by Name, then Month Sort by Month, then Name Sort by Units Sold, then Month 28. You are going to borrow $500,000 to buy a house. Assume an annual interest rate of 8%. The length of the loan is 30 years and you are making payments at the end of each month. Your monthly payment is _____. Enter just the number (no dollar sign), as a positive number, rounded to the nearest dollar; e.g., 4218.5 should be entered as 4219 44. Suppose you have listed Le Napoleon's monthly sales of pear tortes in a twelvesheet workbook. The first worksheet contains January sales, the second worksheet February sales, etc. The pear torte sales are always listed in cell F7. What multisheet (threedimensional) formula would give the total pear torte sales for the months MarchJuly, inclusive? Assume that each worksheet is named with the month name only, spelled out in full. Include the equal sign at the beginningfor example, =SUM(A1:A24)but do not include any unnecessary spaces or parentheses in your response. Also do not anchor any cellsi.e., do not use any $ characters