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")
Correct Answer:
Verified
Correct Answer:
Verified
Q17: Derek wants to remove columns from Query
Q84: Changing a worksheet window to Normal view
Q94: To format text so that it automatically
Q147: To retrieve data values from a comma-separated
Q206: Which of the following form controls can
Q208: Evelyn wants to work on different parts
Q211: A _ is a structured collection of
Q212: You use conditional formatting to format a
Q213: What does the Highlight Duplicate Values conditional
Q311: The Remove Duplicates tool locates and deletes