The expression IIf(IsNull([ClosedDate]),"Open","Closed") displays ________

A) Closed when the ClosedDate field has no value and Open otherwise
B) Open when the ClosedDate field has no value and Closed otherwise
C) Closed when the ClosedDate field has no value and nothing otherwise
D) Open when the ClosedDate field has no value and nothing otherwise

B

Computer Science & Information Technology

You might also like to view...

Field placeholders are surrounded with ________

A) field codes B) brackets C) dashes D) parentheses

Computer Science & Information Technology

Slicers that are connected to and used in more than one PivotTable are called shared slicers

Indicate whether the statement is true or false

Computer Science & Information Technology