Manage a Database List The Database worksheet contains an identical list of apartments. One of…
Manage a Database List
The Database worksheet contains an identical list of apartments. One of the owners wants to know how many two- and three-bedroom apartments should be remodeled, the value of lost rent, and the year of the oldest remodel on those units. You need to perform an advanced filter and enter some database functions to address the owner’s concerns.
a. Click the Database worksheet tab.
b. Enter conditions in the Criteria Range for unoccupied two- and three-bedroom apartments that need to be remodeled.
c. Perform an advanced filter based on the criteria range. Filter the existing database in place.
d. Enter database functions to calculate the database statistics in the range C8:C10.