+
Exploring Series Vol. 2 Specialized Functions

Exploring Series Vol. 2 Specialized Functions

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/exploring-series-vol-2-specialized-functions/

Specialized Functions
 
Project Description:
In the following project, you will use Excel to perform calculations regarding rental properties. You will create a basic search, utilize database functions, and create an amortization table
 
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

Download and open the file namedexploring_e07_grader_h1.xlsx, and then save the file ase07c2Apartment_LastFirst, replacing LastFirst with your name.

0

2

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

3

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.

10

4

Type 101 in cell B2.

4

5

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

6

Click the Database worksheet and enter conditions in the Criteria Range for unoccupied two- and three-bedroom apartments that need to be remodeled.

10

7

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 month.

2

10

Enter a database function to calculate the year of the oldest remodel in cell C9.

2


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial