Asked by Scott Johnston on Jul 16, 2024
Verified
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"
Structural Reference
A method in spreadsheet applications that uses table names and column headings to refer to cells within a table, improving clarity.
Salary Column
In spreadsheets or databases, a column specifically designated for listing the salary amounts for individuals or positions.
- Utilize Excel formulas and functions to manipulate and retrieve data.
Verified Answer
KE
Kyomi EscalonaJul 20, 2024
Final Answer :
A
Explanation :
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]'.
Learning Objectives
- Utilize Excel formulas and functions to manipulate and retrieve data.