(Answered) : Step Instructions Points Possible 1 Open Exploringe07graderh1apartmentxlsx Save Exploringe Q30581007

1

Open exploring_e07_grader_h1_Apartment.xlsxand save it asexploring_e07_grader_h1_Apartment_LastFirst.

0

2

In cell G8 in the Summary worksheet, insert a date function tocalculate the number of years between 1/1/2018 in cell H2 and thelast remodel date in the Last Remodel column (cell F8). Userelative and mixed references correctly. Copy the function to therange G9:G57. Unit 101 was last remodeled 13.75 years ago. Ensurethat the function you use displays that result.

6

3

In cell H8, insert a nested logical function to display therequired pet deposit