Solved

The Components of a Structured Reference Are as Follows: Table

Question 21

Multiple Choice

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]])

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions