An Excel Table Contains Columns Named Salary and Commission

question 71

Multiple Choice

An Excel table contains columns named Salary and Commission.Which of the following formulas uses a structural reference to add the values in the Salary column to the values in the Commission column?

• A) '=[Salary]+[Commission]
• B) =[Salary+Commission]
• C) =(Salary)+(Commission)
• D) ="Salary" + "Commission"

---

Definitions:

Poisson Distribution

A probability distribution that expresses the probability of a given number of events occurring in a fixed interval of time or space if these events happen with a known constant mean rate and independently of the time since the last event.

Occurrences

Instances or examples of something happening; events that take place.

Specified Interval

A defined range or period, often set for a particular purpose or task, indicating the precise limits within which something operates or occurs.

Binomial Experiment

An experiment having the four properties stated at the beginning of Section 5.5.