Which Function Returns a Value at the Intersection of a Specified

question 10

Multiple Choice

Which function returns a value at the intersection of a specified row and column?

• A)MATCH
• B)INDEX
• C)VLOOKUP
• D)IF

---

Definitions:

Normal Populations

Populations that follow a normal distribution, where the majority of data points are concentrated around the mean value.

Standard Error

A statistical term that measures the accuracy with which a sample distributes around the population mean; it is the standard deviation of the sampling distribution.

Sampling Distribution

The probability distribution of a given statistic based on a random sample, used to estimate population parameters.

Formal Charge

Used to calculate the charge of an atom in a molecule, assuming that electrons in all chemical bonds are shared equally between atoms.