ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 68 - AD0-E903 discussion

Report
Export

An executive wants to see the actual cost of projects within a selected portfolio, allowing for multiple reports with the option to select a specific portfolio, sorted in a descending order, so the most expensive projects appear on top. Which steps should be taken to create this report?

A.
Visit the Reports area and create a new Project report. Add a column for Actual Cost and sort the column in descending order. From the Reporting Settings dropdown, add a prompt for Portfolio Name.
Answers
A.
Visit the Reports area and create a new Project report. Add a column for Actual Cost and sort the column in descending order. From the Reporting Settings dropdown, add a prompt for Portfolio Name.
B.
Visit the Reports area and create a new Project report. Group the results by Portfolio Name. Add a column for Actual Cost and summarize this column by SUM.
Answers
B.
Visit the Reports area and create a new Project report. Group the results by Portfolio Name. Add a column for Actual Cost and summarize this column by SUM.
C.
Visit the Reports area and create a new Project report. Add a column for Actual Cost and sort the column in descending order. Group the results by Portfolio Name.
Answers
C.
Visit the Reports area and create a new Project report. Add a column for Actual Cost and sort the column in descending order. Group the results by Portfolio Name.
Suggested answer: A

Explanation:

To meet the executive's request, the best approach is to create a Project Report in the Reports area. Adding a column for Actual Cost and sorting it in descending order ensures that the most expensive projects appear at the top. Additionally, by adding a prompt for Portfolio Name, the report can be filtered by the specific portfolio, allowing for tailored views across different portfolios.

asked 02/10/2024
Tina Christiansen
31 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first