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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!