You create a shape that has two Shape Data rows named Department and CostCode. Both the Department and the CostCode rows have the Type =1.
The Department row Format cell has the formula =A;B.
You need to modify the ShapeSheet to meet the following requirements:
When a user selects Department A, only CostCodes A1 and A2 are visible. When a user selects Department B, only CostCodes B1 and B2 are visible.
What should you do?
A.
Insert a new user-defined cell and enter the formula =SETF(GetRef(Prop.CostCode.Format), = INDEX(LOOKUP(Prop.Department,Prop.Department.Format),”A1;A2|B1;B2″,”|”))
B.
Enter the following formula in the Format cell of the CostCode Shape Data row.
=INDEX(LOOKUP(Prop.Department,Prop.Department.Format),”A1;A2|B1;B2″)
C.
Enter the following formula in the Format cell of the CostCode Shape Data row.
=””””&INDEX(LOOKUP(Prop.Department,Prop.Department.Format),”A1;A2|B1;B2″,”|”)&””””
D.
Enter the following formula in the Format cell of the CostCode Shape Data row.
=INDEX(LOOKUP(Prop.Department,Prop.Department.Format),”A1;A2|B1;B2″,”|”)