These Q's are regarding Excel functions.

66. Refer to the screenshot below, where we have total sales within different product categories. A product category is entered in cell C12. Which of the following functions will retrieve the corresponding value for sales? =LOOKUP(C12,B3:07,C,TRUE) =LOOKUP(C12,B3:07,C,FALSE) =HLOOKUP(C12,B3:07,C,TRUE) =HLOOKUP(C12,B3:07,C,FALSE) =VLOOKUP(C12,B3:07,2,TRUE) =VLOOKUP(C12,B3:07,2,FALSE) A B 1 2 3 4 Product movies candy tea soda $ $ $ $ $ Sales 120.00 95.00 45.00 83.00 97.00 5 6 7 ice cream 8 9 10 11 12 Enter product: soda Sales: 13 59. A company has revenues of $100 during Year 1. Each year their profit is 20% of revenue. Revenue is growing 15% per year. Suppose you want to determine how the company's total profit during years 1-10 depends on the annual revenue growth rate and assumed profit margin. What Excel feature would you use? I. Data Table II. Goal Seek III. Subtotals IV. Data Validation Just Just I and 11 Just III Just II and III Just IV Just I and IV