Question: Question 33 Questions 38-39 use the fact pattern on tab 038-39 in the Exam Workbook. You will enter a function for the answer below. Start

Question 33 Questions 38-39 use the fact pattern on tab 038-39 in the Exam Workbook. You will enter a function for the answer below. Start your formula with the = sign. Do not anchor cell references, i.e. there should be no dollar signs ("5") in your answer. Write an HLOOKUP function that will output the correct Net Prot for whichever date is selected in cell H11. For your answer to be scored correctly, please using C5:H3 as your table array and a hard coded number for the row index number. Question 39 In the last question, you wrote an HLOOKUP function to output net prot. Do you need to include a range lookup to output the correct net profit? Yes, the formula needs an exact match in the range lookup parameter to work correctly. Yes, the formula needs an approximate match in the range lookup parameter to work correctly
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
