The components of a structured reference are as follows: Table 1 is Table Name,[Net Amount] and [Commission Amount] are column specifiers and [#Totals] and [#Increase] are item specifiers.Which of these can be the formula for the structured reference?
A) =SUM(#Totals[[Table1],[Net Amount]],#Increase[[Table1],[Commission Amount]])
B) =SUM(Net Amount[[#Totals],[able1]],Commission Amount[[#Increase],[Table1]])
C) =SUM(Table1[[#Totals],[Net Amount]],Table1[[#Increase],[Commission Amount]])
D) =SUM(Table1[[#Totals],[#Increase]],Table1[[Net Amount],[Commission Amount]])

Question

Quizplus · Accepted Answer

C is the correct formula for a structured reference. It specifies the table, column, and item in a way that is understandable to Excel. Option A is close, but the column specifiers should come before the item specifiers. Option B is incorrect because it refers to the item specifier before the column specifier. Option D is also incorrect because the item specifiers do not refer to valid column or table names.

The Components of a Structured Reference Are as Follows: Table