Within portfolio management, we can distinguish between the reactive and proactive approach towards project selection (week 6). A downside of the reactive approach is that it leads to:

2. Question 2 Once you have completed Exercise 3, what is the correct formula in cell K197? 1 point   =SUMIFS(Head_Count,Office_Name,$B197,Role,”Finance”,AvgHourlyCost,”>=”&K$185,AvgHourlyCost,”<=”&K$186) =COUNTIFS(Head_Count,Location_Name,$B197,Role,”Finance”,AvgHourlyCost,”>=”&K$185,AvgHourlyCost,”<=”&K$186) =SUMIFS(Head_Count,Location_Name,$B197,Role,”Finance”,AvgHourlyCost,”>=”&K$185,AvgHourlyCost,”<=”&K$186)