Continue to use the FIN 6455 Excel Questions 1-6.xlsx file f…

Continue to use the FIN 6455 Excel Questions 1-6.xlsx file for this question. Note that you have to use the Excel function(s) specified below to get points for this question. Question 4.  Using the function COUNTIFS, rite down a formula to calculate the total number of two bedroom Victorian properties.  Also write down the answer you get from this calculation.  

Continue to use the FIN 6455 Excel Questions 1-6.xlsx file f…

Continue to use the FIN 6455 Excel Questions 1-6.xlsx file for this question. Note that you have to use the Excel function(s) specified below to get points for this question. Question 3. The closing cost is based on the the style of the properties, as captured in the “Closing cost table” in Q10:S14.  (This table is also named “ClosingCostTable” in this file.)  Calculate the closing cost in column N by entering a formula in N2 then copy it down to the rest of the properties. Using VLOOKUP, write down the formula that you entered in N2 (for property ID 101).  Note that this formula has to work when you copy it down to N3:N101.  

Continue to use the FIN 6455 Excel Questions 7-8.xlsx file f…

Continue to use the FIN 6455 Excel Questions 7-8.xlsx file for this question. Question 8. Which region has the highest sales growth in 2012, and what is the growth rate of this highest-growth region from January to December?  Your answer should look like this: YYY region has the highest growth. Growth rate: X.XX%  

Continue to use the FIN 6455 Excel Questions 1-6.xlsx file f…

Continue to use the FIN 6455 Excel Questions 1-6.xlsx file for this question. Note that you have to use the Excel function(s) specified below to get points for this question. Using the functions INDEX and MATCH, write down a formula to calculate the sales price of the first property sold on this list.  Also write down the answer (in $) you get from this calculation.