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
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
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.
To use Smart Lookup, you can ________ on the word
Fill in the blank(s) with correct word
The most common port used to connect a scanner is the _______ port
Fill in the blank(s) with correct word