You add a new object to a query and run the query. How do you display the new object in the document?

• A.Drag the new object from the Available Objects pane onto the report.
• B.Choose "Refresh All' in the report.
• C.Select the "Insert a table in a new report" option.
• D.Select the "Insert a table in the current report" option.

Comment: *

Name: *

Email: *

Verification: *

What option do you select to change the Total Revenue to a currency (shown in the attached graphic)?

• A.1. Right click on the edge of the table.
  2. Select Format Table.
• B.1. Right click a number in the Total Revenue column.
  2. Select Format Cell.
• C.1. Right click the Total Revenue column name.
  2. Select Format Number.
• D.1. Right click a number in the Total Revenue column.
  2. Select Format Number.

Comment: *

Name: *

Email: *

Verification: *

How do you duplicate a query?
Please choose the correct answer.
Response:

• A.Right-click Query in the Report Manager and select Duplicate Query
• B.Right-click the Query Tab in the Query Panel and select Duplicate Query
• C.Choose Duplicate Query in the Tools Menu
• D.Select Duplicate Query in Properties in the Query Panel

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.10
• B.1.00
• C.1.18
• D.1.15
• E.1.05

Comment: *

Name: *

Email: *

Verification: *

Where are contexts created?
Please choose the correct answer.
Response:

• A.In a report
• B.In a derived table
• C.At the database level
• D.In a universe

Comment: *

Name: *

Email: *

Verification: *