apartment complex excel grader. Can someone show me the steps to complete this grader project?
VIEW aBbCcl AaBbC AaBbCcl AaBbCel AaBbCc AaBbCct AaBb :: .12:?. | Emphasis Heading 11Normal!Normal L.. Strong Subtitle TTit Paragraph Styles Office 2016-myitlab:grader-Instructions Excel Project EX16_ XL_CH07_GRADER CAP_HW-Apartment Complex 1.9 Project Description: You own five apartment complexes. You created a dataset listing the apartment numbers, apartment complex names, number of bedrooms, rental price, whether the apartment is occupied or not, and the date the apartment was last remodeled. You want to insert some functions to perform calculations to help you decide whickh apartments need to be remodeled. To focus on the apartments that need to be remodeled, you wll use advanced filtering and database functions for your analysis. Finally, you are considering purchasing a siath apartment complex. You will perform some financial calculations and analysis to help you decide if you wi purchase the complex. Instructions: For the purpose of grading the project you are required to perform the following tasks: Points Step Instructions Open exploning_ e07 grader h Apartment.xlsx and save it as exploring e07 grader h1 Apartment LastFirst. in cel G8 in the Summary worksheet, insert a date function to calculate the number of between 1/1/2018 in cell H2 and the last remodel date in the Last Remodel column (cell FB). was last remodeled 13.75 years ago. Ensure that the function you use displays that result In cell HB, insert a nested logical function to display the required pet deposit for each unit. 2 Use relative and mixed references correctly. Copy the function to the range G9:G57. Unit 101 the unit has two or more bedrooms (C8) AND was remodeled less than 10 years ago (cell H3), references correctly. The pet deposit for Unit 101 is $200. in cell 18, enter a nested logical function to display Need to Remodel if the apartment i 3 the deposit is $275 (cell H4); f not, the deposit is $200 (cell H5). Use relative and mbced unoccupied (NO) AND was last remodeled more than 10 years ago (??). For all other apartments, display No Change. Although Unit 101 was last remodeled over 10 years ago, the recommendation is No Change because the unit is occupied. VIEW aBbCcl AaBbC AaBbCcl AaBbCel AaBbCc AaBbCct AaBb :: .12:?. | Emphasis Heading 11Normal!Normal L.. Strong Subtitle TTit Paragraph Styles Office 2016-myitlab:grader-Instructions Excel Project EX16_ XL_CH07_GRADER CAP_HW-Apartment Complex 1.9 Project Description: You own five apartment complexes. You created a dataset listing the apartment numbers, apartment complex names, number of bedrooms, rental price, whether the apartment is occupied or not, and the date the apartment was last remodeled. You want to insert some functions to perform calculations to help you decide whickh apartments need to be remodeled. To focus on the apartments that need to be remodeled, you wll use advanced filtering and database functions for your analysis. Finally, you are considering purchasing a siath apartment complex. You will perform some financial calculations and analysis to help you decide if you wi purchase the complex. Instructions: For the purpose of grading the project you are required to perform the following tasks: Points Step Instructions Open exploning_ e07 grader h Apartment.xlsx and save it as exploring e07 grader h1 Apartment LastFirst. in cel G8 in the Summary worksheet, insert a date function to calculate the number of between 1/1/2018 in cell H2 and the last remodel date in the Last Remodel column (cell FB). was last remodeled 13.75 years ago. Ensure that the function you use displays that result In cell HB, insert a nested logical function to display the required pet deposit for each unit. 2 Use relative and mixed references correctly. Copy the function to the range G9:G57. Unit 101 the unit has two or more bedrooms (C8) AND was remodeled less than 10 years ago (cell H3), references correctly. The pet deposit for Unit 101 is $200. in cell 18, enter a nested logical function to display Need to Remodel if the apartment i 3 the deposit is $275 (cell H4); f not, the deposit is $200 (cell H5). Use relative and mbced unoccupied (NO) AND was last remodeled more than 10 years ago (??). For all other apartments, display No Change. Although Unit 101 was last remodeled over 10 years ago, the recommendation is No Change because the unit is occupied
