Author Question: You are creating an IIF function. If the input in the Net Sales field is greater than or equal to ... (Read 41 times)

MGLQZ

  • Hero Member
  • *****
  • Posts: 579
You are creating an IIF function. If the input in the Net Sales field is greater than or equal to 60, then the custom field will read Pass. If Net Sales are less than 40, the custom field will read Fail. What is the function that will be entered into the field name?
 
  A) If(Net Sales>=.60, Pass, Fail) B) If(Net Sales >=60, Pass, Fail)
  C) IIf(Net Sales >=60, Pass, Fail) D) IIf(Net Sales >=60, Pass, Fail)

Question 2

The three letter code that appears after the period in a filename is called the:
 
  A) file extension B) password C) template D) keyword



DylanD1323

  • Sr. Member
  • ****
  • Posts: 314
Answer to Question 1

D

Answer to Question 2

A



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question


 

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Did you know?

Many medications that are used to treat infertility are injected subcutaneously. This is easy to do using the anterior abdomen as the site of injection but avoiding the area directly around the belly button.

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

Did you know?

As the western states of America were settled, pioneers often had to drink rancid water from ponds and other sources. This often resulted in chronic diarrhea, causing many cases of dehydration and death that could have been avoided if clean water had been available.

For a complete list of videos, visit our video library