Expecting a with-type report or field filter to find records with no children
The wrong answers filter on an Opportunity field, use a report type such as Accounts with Opportunities, or add a WITH cross filter. Each of these only evaluates Accounts that already have related Opportunities, so Accounts with none are excluded before the filter applies. A cross filter set to Accounts WITHOUT Opportunities, or the Accounts without Opportunities report type, tests for the absence of related records and returns the dormant Accounts.
See it in a sample questionConfusing matrix, summary and joined report formats
The wrong answers offer a summary report, nested groupings or a joined report when the question asks for a grid with one grouping down the side and another across the top. Summary reports group only down the rows, and a joined report places separate blocks side by side. A matrix report groups by both row and column fields and shows a summarised value at each intersection. Tabular reports only list records.
See it in a sample questionSwapping bucket fields and summary formulas
Bucketing is offered for a percentage of a grand total, and a summary formula is offered for sorting Amount into Small, Medium and Large. A bucket field categorises the values of a column into named groups inside one report and performs no arithmetic. A summary formula calculates at group and grand-total level, using a function such as PARENTGROUPVAL, and returns numbers rather than text labels.
See it in a sample questionAssuming a standard dashboard shows each viewer their own data
The wrong answers expect a standard dashboard to scope figures per viewer, or choose run as the logged-in user when every viewer needs the same complete figures. A standard dashboard renders through one running user, so every viewer sees that user's data. Only a dynamic dashboard, set to run as the logged-in user, shows each viewer their own data. A specified user with full access gives uniform totals.
See it in a sample questionControlling dashboard access with something other than the folder
The wrong answers adjust the running user, grant Run Reports, grant View All Data or share a personal dashboard directly. None of these controls who can open a dashboard. The running user decides whose data appears, View All Data over-grants record access, and personal folders cannot be shared. Access comes from the folder: move the dashboard into a shared folder and grant the audience Viewer access to that folder.
See it in a sample question