Question: a . In cell N 6 , insert a formula using the IFS function. b . Use a structured reference to test whether the Policy

a.In cell N6, insert a formula using the IFS function.
b.Use a structured reference to test whether the Policy Type is "Renters" and display the text "1 week" if it is.
c.Use a structured reference to test whether the Average rating is less than or equal to 3 and display the text "3 days" if it is.
d.Add a final default argument to test whether any other condition is TRUE and display a blank cell ("") for that condition.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!