In this project, you will create functions that calculate statistical data for apartment complexes. You will then filter the data based on multiple criteria and calculate the payments for a loan on a new complex. Instructions:
For the purpose of grading the project you are required to perform the following tasks: Step| Instructions| Points Possible|
1| Start Excel. Download, save, and open the Excel workbook named Exploring_e07_Grader_EOC.xlsx.| 0| 2| On the Summary worksheet, in cell H14, enter a nested function that will return Need to remodel as the result if the apartment is unoccupied and was last remodeled before 2005. Otherwise, the function should return No change as the result. Copy the function down through H26.| 10| 3| In cell B6, insert a function to calculate the total number of units in the apartment complex in A6. Be sure to enter the criteria range as an absolute reference. Copy the function down through B10.| 10| 4| In cell C6, insert a function that will calculate the number of occupied units in the apartment complex in A6. Be sure to enter the criteria ranges as absolute references. Copy the function down through C10.| 10| 5| In cell D6, calculate the percentage of units that are occupied in the Lakeview Apartments complex. Copy the formula down through D10.| 6| 6| In cell E6, insert a function that will rank the value in D6 based on the occupancy rates of all five apartment complexes, in descending order. Enter the range as an absolute reference. Copy the function down through E10.| 10| 7| In cell F6, insert a function that will sum the potential rent (i.e., the total rent if all units are occupied) for the apartment complex in A6. Copy the function down through F10.| 10| 8| In cell G6, insert a function that will sum the actual amount of rent (i.e. total rent for occupied units) for the apartment complex in A6.| 8| 9| Copy the function in G6 down...