Question: a . In cell N 6 , insert a formula using the IFS function. b . Use a structured reference to test whether the Policy
aIn cell N insert a formula using the IFS function.
bUse a structured reference to test whether the Policy Type is "Renters" and display the text week" if it is
cUse a structured reference to test whether the Average rating is less than or equal to and display the text days" if it is
dAdd 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
