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
Q11: Shelley creates a table containing the marks
Q273: What happens when you click the sheet
Q274: Tracy created a table where the odd
Q275: Which of the following buttons on the
Q276: How can you hide the filter buttons
Q279: Mia inserted a plain table in a
Q280: To use defined names in existing formulas,
Q281: You cannot add totals to an Excel
Q282: To locate duplicate values in a selected
Q283: References to fields in an Excel table
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents