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"

Question

Quizplus · Accepted Answer

A structural reference is used to refer to a specific column or row within a table by using the column or row header. In this case, the formula should be structured as '=[TableName][ColumnName1]+[TableName][ColumnName2]', where 'TableName' is the name of the table containing the columns Salary and Commission, and 'ColumnName1' and 'ColumnName2' are the names of the two columns. Therefore, the correct formula is '=[Table1][Salary]+[Table1][Commission]'.

An Excel Table Contains Columns Named Salary and Commission