Match the Following Terms to Their Description

question 54

Short Answer

Match the following terms to their description.
I.Data validation
II.List validation
III.Decimal validation
IV.Date validation
V.Whole number validation
A.Restricts users to entering data in a cell that contain digits and a decimal point
B.Any means of increasing the probability of correct data entry through programmatic tools and/or behavioral modifications
C.Restricts the user to entering integer values in a validated cell
D.Presents the user with a list of data values from which the user can choose
E.Restricts the user to entering dates that satisfy the specified criteria in a validated cell

---

Definitions:

High-low Method

An analytical technique used in accounting and finance to estimate fixed and variable costs associated with business operations based on the highest and lowest levels of activity.

Fixed Cost

Costs that do not vary with the level of production or sales, remaining constant regardless of the amount of goods or services produced or sold.

Electricity

A form of energy resulting from the existence of charged particles, used as a power source for machinery and equipment.

Least-squares Regression

A statistical method used to determine the best-fitting line through a set of points by minimizing the squares of the distances of the points from the line.