Please help me to solve this excel sheet

1	Click the Database worksheet and enter conditions in the Criteria Range for unoccupied two- and three-bedroom apartments that need to be remodeled. Enter Need to remodel in the Recommendation column for these rows.
2	Perform an advanced filter based on the Criteria range. Filter the existing database in place.
3	In cell C7, enter a DCOUNTA function to calculate the number of apartments to remodel using the existing Criteria range name.
4	In cell C8, enter a database function to calculate the total lost rent for the month using the Criteria range.
5	Enter a database function to calculate the year of the oldest remodel in cell C9.

Criteria Range
Unit #	Development	Unit #	# Bed	Rental Price	Occupied	Last Remodel	Recommendation
Database Statistics
	No. of Apts. to Remodel
	Value of Lost Rent
	Year of Oldest Remodel
List of Rental Property
Unit #	Development	# Bed	Rental Price	Occupied	Last Remodel	Recommendation
101	Rolling Meadows	1	750	Yes	2004	No change
103	Rolling Meadows	2	850	No	1999	Need to remodel
104	Rolling Meadows	2	850	Yes	2005	No change
105	Rolling Meadows	3	1,000	No	2007	No change
302	Lakeview Apartments	1	875	No	2001	Need to remodel
303	Lakeview Apartments	1	900	No	2001	Need to remodel
306	Lakeview Apartments	2	1,200	Yes	2004	No change
406	Mountaintop View	3	1,200	No	2002	Need to remodel
407	Mountaintop View	2	975	Yes	2002	No change
408	Mountaintop View	2	975	Yes	2002	No change
501	Sunset Valley	1	550	Yes	2010	No change
502	Sunset Valley	1	550	No	2010	No change
503	Sunset Valley	1	550	No	2003	Need to remodel
504	Sunset Valley	1	550	Yes	2003	No change
505	Sunset Valley	2	700	No	2003	Need to remodel
605	Oak Tree Living	3	1,500	No	2010	No change
606	Oak Tree Living	3	1,500	Yes	2004	No change
607	Oak Tree Living	3	1,500	No	2004	Need to remodel