Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please give a step by step in such a way that someone with no Excel experience would be able to follow along, thank you. Excel
Please give a step by step in such a way that someone with no Excel experience would be able to follow along, thank you.
Excel Grader 7 in MyItLab:
Points Possible Step Instructions Download and open the file named exploring_e0Z _graderhi.xisx, and then save the file as e07c2Apartment_ LastFirst, replacing LastFirst with your name 1 0 Insert functions in the Pet Deposit column of the Summary worksheet to calculate the required pet deposit for each unit. If the unit has two or more bedrooms and was remodeled after 2008 the deposit is $125, if not it is $75 10 Enter nested functions in the Recommendation column to indicate Need to remodel if the apartment is unoccupied and was last remodeled before 2005. For all other apartments, display No change. 3 10 4 Type 101 in cell B2. 4 Insert a nested lookup function in cell E2 that will look up the rental price in column D using the apartment number referenced in cell B2. 10 Click the Database worksheet and enter conditions in the Criteria Range for unoccupied two- and three-bedroom apartments that need to be remodeled 6 10 Perform an advanced filter based on the criteria range. Filter the existing database in place. 10 8 In cell C7, enter a DCOUNTA function to calculate the number of apartments to remodel 6 9 In cell C8, enter a database function to calculate the total lost rent for the monthStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started