Author Question: You are creating an IIF function. If the input in the Net Sales field is greater than or equal to ... (Read 38 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?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

Certain chemicals, after ingestion, can be converted by the body into cyanide. Most of these chemicals have been removed from the market, but some old nail polish remover, solvents, and plastics manufacturing solutions can contain these substances.

Did you know?

The human body's pharmacokinetics are quite varied. Our hair holds onto drugs longer than our urine, blood, or saliva. For example, alcohol can be detected in the hair for up to 90 days after it was consumed. The same is true for marijuana, cocaine, ecstasy, heroin, methamphetamine, and nicotine.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

For a complete list of videos, visit our video library