Excel task:

Please let me know how to do it in excel with formulae and explanations.

QUESTION 3 A financial advisor needs to recommend investments for an important client. He has narrowed down his choices to three market segments: Technology, Energy, and Healthcare. -Based on past performance, he has estimated the stock market returns depending on the state of the economy whether it is in a GROWTH stage, a STABLE stage, or a RECESSION stage. The anticipated annual return percentages are given for each economic condition as follows: Alternatives GROWTH STABLE RECESSION Technology 10% 5% -5% Energy 7% 4% -2% Healthcare 5% 4% -1% A) Create a payoff table using excel to begin the analysis B) Using the MaxiMax Strategy, which segment should he recommend? Make sure to add this to the excel table C) Using the MaxiMin Strategy, which segment should he recommend? Make sure to ass this to the excel table Attach the completed excel document to your