Match the Following Functions with When They Would Be Used

question 86

Multiple Choice

Match the following functions with when they would be used:
i. Date
II. DatePart
III. IIf
IV. Round
v. IsNull

• A) When you need to use today's date
• B) When you need to display a number to four decimal places
• C) When you need to do one action if a condition is true and another if a condition is false
• D) When you need to see if a field was skipped in data entry
• E) When you need to use only the month within a date

---

Definitions:

Cold Front

A leading edge of a cooler mass of air, replacing (at ground level) a warmer mass of air, which can lead to dramatic changes in weather conditions.

Rain Shadow Effect

A climatic phenomenon where a mountain range causes precipitation on one side, creating a dry area on the leeward side due to the blocking of rain-producing weather systems.

Tornadoes

are violently rotating columns of air that are in contact with both the surface of the Earth and a cumulonimbus cloud or, in rare cases, the base of a cumulus cloud, known for causing significant destruction.

Per Annum

A Latin term meaning "per year," used to describe a rate or amount measured over the course of a year.