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:

Complementary Resources

Different types of goods or services that, when used together, enhance each other's value and performance.

Market Value

The ongoing rate at which a commodity or service can be traded in the public market.

Productivity

The measurement of efficiency in which goods and services are produced, often assessed by the amount of output per unit of input.

Marginal Revenue Product Curve

A graphical representation showing how the addition of one more unit of a resource affects the total revenue.