Which of the following is an unqualified structure reference

Which of the following is an unqualified structure reference?  = [Sales]Purchase_Price - [Sales]Down_Payment  = Purchase_Price-Down_Payment  = Sales[Purchase_Price]-Sales[Down_Payment]  = [Purchase_Price]-[Down_Payment]  Which of the following is not an aggregate function that can be applied in a total row?  COUNT  MAX  VLOOKUP  AVERAGE  If you would like to set a conditional formatting rule based on the function = AND(G6 = \"Finance\", H7

Solution

Mark the questions as 1, 2, and 3 respectively.

1.

Solution:

The correct syntax of the structure reference is as follows:

Reference_of_structure: = Name_of_variable{[Subscripts]}.Tags

Tags: = {Tags.} Tag

Tag: = Name_of_Tag{[Subscripts]}

Thus, the wrong syntax is =[Purchase_Price] – [Down_Payment].

2.

Solution:

Thus, the non-aggregate function is VLOOKUP.

3.

Solution:

Thus, the correct rule is use a formula to determine which cells to format.