MCQs on Reporting and Dashboards Fundamentals | Salesforce Sales Cloud

Master the essentials of reporting and dashboards in Salesforce Sales Cloud with these 30 output-based MCQs. Explore standard and custom reports, dashboards, sharing options, and advanced techniques to track performance effectively.


Topics Covered:

  1. Introduction to Standard Reports and Dashboards
  2. Creating Simple Custom Reports
  3. Sharing and Scheduling Reports
  4. Using Dashboards to Track Key Metrics

MCQs on Reporting and Dashboards Fundamentals | Salesforce Sales Cloud

Introduction to Standard Reports and Dashboards

  1. Output:
    You run the “Leads by Source” standard report, and the result shows a bar chart with five sources but no data under “Trade Shows.” What could be the reason?
    • A) Trade Shows is inactive as a lead source.
    • B) No leads are associated with the “Trade Shows” source.
    • C) The report filter excludes Trade Shows.
    • D) The report is not refreshed.
  2. Output:
    In a standard “Opportunities by Stage” report, the summary row shows Total Amount as $1,000,000. What does this value represent?
    • A) Sum of expected revenue from all stages.
    • B) Total potential revenue for all open opportunities.
    • C) Combined revenue from closed-won opportunities.
    • D) Total pipeline value for all stages.
  3. Output:
    After running a standard “Accounts by Industry” report, the chart shows data for only three industries. However, the industry field contains ten options. What could explain this?
    • A) The report filter is limiting the data.
    • B) Industries with no accounts are excluded.
    • C) Data visibility settings are hiding certain industries.
    • D) Both A and B.
  4. Output:
    You view a “Cases by Priority” report and see priority categories but no corresponding case data. What is likely causing this?
    • A) No cases are assigned a priority.
    • B) The report date range is incorrect.
    • C) Case sharing settings restrict visibility.
    • D) All of the above.
  5. Output:
    A user runs the “Opportunities with Products” report and notices that the Total Amount field is blank for some records. Why might this happen?
    • A) The opportunities do not have products associated.
    • B) The products are not priced.
    • C) The opportunities are not closed.
    • D) The report filter excludes opportunities with zero amount.

Creating Simple Custom Reports

  1. Output:
    You create a custom report to display “Opportunities by Close Date” grouped by month, but the report shows only three months of data. What could be the issue?
    • A) The Close Date filter limits the range.
    • B) The grouping option is incorrect.
    • C) The report format is Summary instead of Matrix.
    • D) Data sharing rules are restricting access.
  2. Output:
    A custom report on “Accounts with Contacts” shows blank values for the contact fields. Why?
    • A) The accounts have no associated contacts.
    • B) The report type does not include contacts.
    • C) The user does not have permission to view contacts.
    • D) All of the above.
  3. Output:
    When grouping a custom report by “Account Owner,” the Total Amount field shows “$0” for one group. What does this indicate?
    • A) The account owner has no opportunities.
    • B) The associated opportunities have no amount values.
    • C) The report filter excludes revenue-generating opportunities.
    • D) Both A and B.
  4. Output:
    A custom report on “Leads with Activities” displays activities without corresponding lead data. What could explain this?
    • A) The activities are not related to leads.
    • B) The leads were deleted.
    • C) The report type includes activities but not leads.
    • D) The user does not have permission to view leads.
  5. Output:
    You build a custom report on “Opportunities with Campaign Influence” and see no campaign data for some opportunities. Why?
    • A) Campaign Influence is not enabled.
    • B) The opportunities are not linked to campaigns.
    • C) The report filter excludes unlinked opportunities.
    • D) All of the above.

Sharing and Scheduling Reports

  1. Output:
    A scheduled report fails to run, and you receive an error. The error message states: “Insufficient privileges to access report data.” What could be the issue?
    • A) The report contains private data.
    • B) The user scheduling the report lacks access to some records.
    • C) The report is in a private folder.
    • D) Both B and C.
  2. Output:
    A shared report is visible in the folder but displays “Insufficient privileges” when opened by a user. Why?
    • A) The user lacks report folder access.
    • B) The user lacks data visibility permissions.
    • C) The report has been deleted.
    • D) Both A and B.
  3. Output:
    A scheduled report sends an email with blank data. Why might this occur?
    • A) The report has incorrect filters.
    • B) The user lacks access to the report’s data.
    • C) The report was not refreshed before scheduling.
    • D) All of the above.
  4. Output:
    After sharing a report folder with a team, some users still cannot access the reports inside. Why?
    • A) The folder is not shared with “Read/Write” access.
    • B) The reports inside are marked as private.
    • C) Both A and B.
    • D) Sharing rules are misconfigured.
  5. Output:
    A user schedules a report to run weekly, but it is not appearing in the email inbox. What could be the problem?
    • A) The email address is not verified.
    • B) The report schedule has expired.
    • C) The report is in a private folder.
    • D) All of the above.

Using Dashboards to Track Key Metrics

  1. Output:
    A dashboard chart on “Sales Performance by Region” shows no data for certain regions. What could explain this?
    • A) The data filter excludes those regions.
    • B) There are no sales in those regions.
    • C) The user lacks access to the regional data.
    • D) All of the above.
  2. Output:
    You add a dashboard component for “Open Opportunities” but it shows zero. What could be the issue?
    • A) The data filter excludes open opportunities.
    • B) The underlying report contains no data.
    • C) The user lacks access to opportunity records.
    • D) Both B and C.
  3. Output:
    A KPI component on the dashboard shows “N/A” for a key metric. What might be the reason?
    • A) The metric is not calculated in the underlying report.
    • B) The report data is unavailable.
    • C) The dashboard filter excludes relevant data.
    • D) All of the above.
  4. Output:
    A user views a dashboard and notices that the data is outdated. What could be causing this?
    • A) The dashboard components are not refreshed.
    • B) The reports are scheduled to update less frequently.
    • C) The user does not have access to live data.
    • D) Both A and B.
  5. Output:
    A dashboard for “Quarterly Revenue” shows incomplete data for one team. Why might this occur?
    • A) The data visibility rules restrict access for that team.
    • B) The team has no revenue data.
    • C) The report filter excludes that team’s data.
    • D) Both A and C.

Answer Key

QnoAnswer
1B) No leads are associated with the “Trade Shows” source
2B) Total potential revenue for all open opportunities
3D) Both A and B
4D) All of the above
5A) The opportunities do not have products associated
6A) The Close Date filter limits the range
7A) The accounts have no associated contacts
8D) Both A and B
9A) The activities are not related to leads
10B) The opportunities are not linked to campaigns
11D) Both B and C
12D) Both A and B
13D) All of the above
14C) Both A and B
15D) All of the above
16D) All of the above
17D) Both B and C
18D) All of the above
19D) Both A and B
20D) Both A and C

Use a Blank Sheet, Note your Answers and Finally tally with our answer at last. Give Yourself Score.

X
error: Content is protected !!
Scroll to Top