An Excel Table Contains Columns Named Salary and Commission

question 209

Multiple Choice

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

• A) =SUM(Salary:Commission)
• B) =SUM(Salary!Commission)
• C) =SUM([Salary]:[Commission])
• D) =SUM("Salary":"Commission")

---

Definitions:

Sense Organs

Organs that receive stimuli (like the eyes, ears, nose, tongue, and skin) and send information to the brain via the nervous system to be interpreted.

Lens Flexibility

Lens flexibility refers to the capacity of the eye's lens to change shape to focus on objects at various distances, crucial for sharp vision.

Visual Acuity

The clarity or sharpness of vision, a measure of how well a person can see details at a distance.

Vestibular Branch

The division of the vestibulocochlear nerve that provides sensory input for balance and spatial orientation from the inner ear to the brain.