You are trying to assess the performance of your North American branches. The performance measure is gross profit. The relevant figures are contained in the "Gross Profit" field. If Gross Profit is greater than or equal to 55, the custom field, named "Status," will read "Approve." If Gross Profit is between 54 and 30, the custom field will read "Attention." If Gross Profit is less than 30, the

field will read "Fail." What is the field name that will be entered?

A) IIf([Gross Profit] >=55, "Approve", IIf([Gross Profit] >=30, "Attention", "Fail"))
B) IIf(Gross Profit >=55, "Approve", IIf(Gross Profit >30, "Attention", "Fail"))
C) IIf([Gross Profit] >=55, "Approve", >30, "Attention", "Fail")
D) IIf([Gross Profit] >=55>30, "Approve", "Attention", "Fail")


A

Computer Science & Information Technology

You might also like to view...

What application can be used to set Windows 8 to boot into Safe Mode while still in Windows?

A. msconfig.exe B. sfc.exe C. services.msc D. rstrui.exe

Computer Science & Information Technology

After using a pen to write a note on the notebook page, what do you do?

A) Use your finger on a touch screen to select the note. B) Click the pen again to select the note. C) Click Lasso Select to select the note. D) Use the stylus to select the note.

Computer Science & Information Technology

To use Smart Lookup, you can ________ on the word

Fill in the blank(s) with correct word

Computer Science & Information Technology

The most common port used to connect a scanner is the _______ port

Fill in the blank(s) with correct word

Computer Science & Information Technology