SF-Admin Data and Analytics Management Practice Question
Which report format allows a user to group records by both rows and columns?
⚠ Common exam trap
Candidates often confuse 'Summary' reports with 'Matrix' reports. Summary reports group by rows, but they do not provide the two-dimensional grid necessary for grouping by both rows and columns.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Matrix
Matrix reports provide a two-dimensional grid, allowing users to group data by both rows and columns. This format is ideal for comparing large datasets, such as revenue by both region and product category. Understanding report types is a core competency for administrators, enabling them to provide the most effective visualizations for business requirements and data analysis.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Tabular
Why it's wrong here
Tabular reports are the simplest format, listing records in rows without any grouping. They are comparable to a basic spreadsheet and do not provide the functionality to group data by rows or columns, making them unsuitable for complex analytical tasks requiring multi-dimensional data aggregation.
- ✗
Summary
Why it's wrong here
Summary reports allow for grouping data by rows only. While they are useful for calculating totals and subtotals within a specific category, they lack the two-dimensional grouping capability required to display data across both row and column axes simultaneously, which is the defining characteristic of a Matrix report.
- ✓
Matrix
Why this is correct
Matrix reports are specifically designed to group data by both rows and columns, creating a grid format. This is the only report format that supports this two-dimensional analytical view, making it the correct choice for requirements involving cross-tabulation of datasets in a clear, summarized view for end users.
- ✗
Joined
Why it's wrong here
Joined reports allow users to create multiple blocks of data from different report types. While they can contain summary or matrix-like blocks, the format itself is designed for multi-block data comparison rather than the standard row/column grouping definition assigned to the Matrix report category in Salesforce.
About these practice questions
One of 202 original SF-Admin practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Salesforce exam blueprint
This SF-Admin practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SF-Admin exam.