What chart elements can use a formula? Note: There are 2 correct Answers to this question.

• A.Chart title
• B.Axis titles
• C.Data labels
• D.Legend labels

Comment: *

Name: *

Email: *

Verification: *

You want to know which other stores' revenues match or exceed your store's revenue. You build a query using the sales revenue. What is the next step?

• A.Add a combined query displaying all stores and revenues using the intersection operator.
• B.Add a combined query displaying all stores and revenues using the union operator.
• C.Add a second query displaying all stores and revenues and merge the store name dimensions.
• D.Add a subquery displaying all stores and revenues with the operator "Greater than or equal to" your store's revenue.

Comment: *

Name: *

Email: *

Verification: *

To what can you apply a conditional formatting rule? Note: There are 2 correct Answers to this question.

• A.Data in a table
• B.Data in a section header cell
• C.Data in a chart
• D.Data in a query filter

Comment: *

Name: *

Email: *

Verification: *

A variable in your report contains the statement:
=If[State] = "California" Then [Sales revenue] * 1.05 Else If[State] = "Colorado" Then [Sales revenue] *
1.1 Else If[State] InList ("DC";"Texas ") Then [Sales revenue] * 1.15 Else If[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue] Sales revenue for Florida is $1,879,159. Which rate is applied to the Florida revenue by the formula?
Please choose the correct answer.
Response:

• A.1.15
• B.1.05
• C.1.00
• D.1.10
• E.1.18

Comment: *

Name: *

Email: *

Verification: *

Which three rules apply when you manually synchronize queries?
There are 3 correct answers to this question.
Response:

• A.Dimensions with different names can be merged.
• B.Dimensions from multiple data sources can be merged.
• C.Dimension value formats must be the same.
• D.Dimensions with different data types can be merged.

Comment: *

Name: *

Email: *

Verification: *