PrepAway - Latest Free Exam Questions & Answers

Which formula should you add to the ShapeSheet?

You need to add a formula to a ShapeSheet to control the content of a cell.
The formula must meet the following conditions:

If the content of user cell A is WideMan, then the cell must contain a value of red. If the content of user cell A is not WideMan, then the cell must contain a value of blue.
Which formula should you add to the ShapeSheet?

PrepAway - Latest Free Exam Questions & Answers

A.
IF(User.A=”WideMan”,”blue”,”red”)

B.
IF(STRSAME(User.A,”WideMan”),”blue”,”red”)

C.
IF(User.A=”WideMan”,”red”,”blue”)

D.
IF(STRSAME(User.A,”WideMan”),”red”,”blue”)


Leave a Reply