Tableau Quiz: Tables And Highlight Tables
10 questions · exam conditions
0:00
Tables And Highlight TablesQuestion 1 of 10

Two analysts review the same profit-margin highlight table at different times. Filters change which products are visible. Management requires a margin of negative ten percent to have the same color intensity before and after filtering, even when the filtered minimum and maximum change.

Which action best ensures consistent color interpretation?

Edit the color legend and set fixed start and end values that cover the approved margin range.
Keep the automatic color range and select Use Full Color Range after every filter change.
Convert the profit-margin pill on Color from continuous to discrete before applying the filters.
Place the profit-margin measure on Detail and assign one fixed color to all Square marks.
← Back to quizzes

Tableau Quiz

Tableau Quiz: Tables And Highlight Tables

Practice Tables And Highlight Tables in Tableau with focused quiz questions that help you check what you know, review explanations, and build confidence with test-style prompts.

What this quiz covers

This quiz focuses on Tables And Highlight Tables, giving you a quick way to practice the rules, question types, and explanations that matter most for Tableau.

How to use this quiz

Try each quiz question before looking at the correct answer. Use the explanations to review missed ideas, then come back to similar questions until the pattern feels familiar.

All questions

Question 1

Two analysts review the same profit-margin highlight table at different times. Filters change which products are visible. Management requires a margin of negative ten percent to have the same color intensity before and after filtering, even when the filtered minimum and maximum change.

Which action best ensures consistent color interpretation?

  1. Edit the color legend and set fixed start and end values that cover the approved margin range. (correct answer)
  2. Keep the automatic color range and select Use Full Color Range after every filter change.
  3. Convert the profit-margin pill on Color from continuous to discrete before applying the filters.
  4. Place the profit-margin measure on Detail and assign one fixed color to all Square marks.
Explanation: When you see a question about color consistency across filter changes in Tableau, think about how the color encoding is anchored. By default, Tableau's continuous color scales adjust dynamically to the visible data's minimum and maximum — meaning the same margin value can appear as a completely different color before and after filtering. Management's requirement here is essentially asking for a fixed reference frame for color. The solution in A is the right one: editing the color legend and manually entering fixed start and end values locks the color scale to a stable range regardless of what filtering does to the visible data. A margin of -10% will always map to the same color intensity because the scale's boundaries never move. This is the "Fixed" option inside the Edit Colors dialog for continuous fields. B is tempting but flawed — "Use Full Color Range" simply removes the option to show muted colors for values outside the range; it doesn't fix the scale boundaries. After each filter change, the automatic range still recalculates, so -10% could still shift in appearance every time. C converts the measure to discrete, which creates categorical color buckets rather than a gradient. This destroys the continuous shading that a highlight table relies on and doesn't give you controlled intensity mapping across a numeric range. D moves the measure off Color entirely, making it invisible in the color encoding. Assigning one flat color to all marks eliminates any margin-based differentiation — the opposite of what's needed. Study tip: Whenever a question mentions "same color intensity before and after filtering," that's your signal to think fixed color axis — just like fixing axis ranges prevents chart distortion when filters change.

Question 2

A highlight table colors variance values. Management wants exactly five visually distinct performance bands, with neutral performance centered at zero and increasingly strong colors for larger positive or negative variances.

Which color configuration most directly satisfies the requirement?

  1. Use a continuous sequential palette, reverse it, and allow Tableau to choose the midpoint automatically.
  2. Use a stepped diverging palette with five steps and set the palette center to zero. (correct answer)
  3. Use a categorical palette, assign five colors manually, and keep the variance measure continuous.
  4. Use a stepped sequential palette with five steps and set the starting value to zero.
Explanation: When a question asks about coloring a measure that has both positive and negative values with distinct visual bands, you should immediately think about diverging palettes — color schemes designed to show deviation from a meaningful center point in two opposing directions. The scenario here has three key requirements working together: exactly five distinct bands, a neutral center at zero, and symmetrical color intensity for positive and negative variances. A stepped diverging palette checks all three boxes. The "stepped" setting converts Tableau's continuous color gradient into a fixed number of discrete color buckets — in this case, five — creating the visually distinct bands management wants. Setting the center to zero ensures neutral performance sits in the middle band, with two bands of increasing intensity extending in each direction. That's answer B, and it directly satisfies every stated requirement. A fails because a sequential palette runs from light to dark in one direction only — it can't represent both positive and negative divergence meaningfully. Letting Tableau choose the midpoint automatically also sacrifices the explicit zero-centering requirement. C is a common trap: categorical palettes are designed for discrete dimensions, not continuous measures. Assigning colors manually to a continuous field creates an inconsistent, unreliable mapping — Tableau won't cleanly partition a continuous range this way. D uses a sequential palette (again, one directional) and misuses the "starting value" parameter, which doesn't create a true neutral midpoint — it just shifts where the color scale begins. Your study tip: diverging = two directions from a center; sequential = one direction from a start. Any time variance, difference, or deviation appears in a color question, diverging is almost certainly the right palette family.

Question 3

A sales table has Customer on rows and Quarter on columns. SUM(Sales) is on Text, so each intersection initially has one aggregated value. After Order ID is added to Detail, some cells contain overlapping text labels and no longer behave as a single summarized cell.

What is the most direct way to restore one sales value per Customer–Quarter intersection?

  1. Move Order ID from Detail to Tooltip and disable Aggregate Measures for SUM(Sales).
  2. Remove Order ID from Detail and keep Aggregate Measures enabled for SUM(Sales). (correct answer)
  3. Keep Order ID on Detail and change SUM(Sales) to a discrete blue pill.
  4. Move Customer and Quarter to Detail, then place Order ID on both Rows and Columns.
Explanation: Whenever Tableau adds a non-aggregated field like Order ID to the Detail shelf, it disaggregates the view — each mark splits into individual rows, so a single Customer–Quarter cell that once showed one summed value now shows multiple overlapping marks. The core concept being tested here is the relationship between level of detail and mark disaggregation. The fix is straightforward: removing Order ID from Detail eliminates the disaggregation and lets Tableau collapse all Order-level rows back into a single aggregated mark per Customer–Quarter pair. With Aggregate Measures still enabled (which is the default), SUM(Sales) computes one value per intersection exactly as intended. That's why B is correct — it directly reverses the action that caused the problem. A is wrong on two counts: moving Order ID to Tooltip doesn't remove it from the data structure determining mark granularity in older Tableau versions if it's already influencing the view, and disabling Aggregate Measures would actually make things worse by showing individual raw values rather than a sum. C fails because keeping Order ID on Detail preserves the disaggregation regardless of whether SUM(Sales) is discrete or continuous — pill color controls display behavior, not the level of detail. D is the opposite of helpful; moving Customer and Quarter to Detail while putting Order ID on Rows and Columns would restructure the entire view around orders, destroying the original Customer–Quarter layout entirely. A good rule of thumb: when your view has unexpected multiple marks per cell, audit the Detail shelf first — a field lurking there is almost always the culprit.

Question 4

A highlight table must display SUM(Sales) in each cell. The cell color should be one of two discrete colors: one for cells whose aggregated Profit is negative and another for cells whose aggregated Profit is zero or positive. Individual profitable records may exist inside an overall loss-making cell.

Which method correctly assigns the color at the table cell's aggregation level?

  1. Create IF SUM([Sales]) < 0 THEN "Loss" ELSE "Non-loss" END and place it on Color.
  2. Create IF [Profit] < 0 THEN "Loss" ELSE "Non-loss" END and place it on Detail.
  3. Place continuous SUM(Profit) on Color and select a sequential palette beginning at zero.
  4. Create IF SUM([Profit]) < 0 THEN "Loss" ELSE "Non-loss" END and place it on Color. (correct answer)
Explanation: When coloring marks in Tableau based on a calculated condition, you need to ask yourself two things: is the logic evaluated at the row level or the aggregation level, and is the result discrete (categorical) or continuous? This question tests both. Because the view is aggregated (each cell represents grouped data), any conditional logic for color must also operate on aggregated values. That means your IF statement must wrap the field in an aggregate function like SUM(). Option D does exactly this — IF SUM([Profit]) < 0 THEN "Loss" ELSE "Non-loss" END evaluates the cell-level sum of Profit and returns one of two string values, producing a discrete, two-color palette on Color. This is the correct answer. Option A makes a logical error in the condition itself — it checks SUM([Sales]) instead of SUM([Profit]). Sales figures are always positive, so no cell would ever be labeled "Loss," making the color meaningless for the stated goal. Option B uses [Profit] without aggregation inside the IF, which means Tableau evaluates it row-by-row before aggregation. Placing it on Detail rather than Color compounds the mistake — it neither colors the cells correctly nor operates at the cell's aggregation level. Option C places a continuous measure on Color, which produces a gradient palette, not two discrete colors. Even if you adjusted the palette to start at zero, you'd get a spectrum rather than a clean binary split between loss and non-loss cells. As a study tip: whenever a question asks for discrete color based on an aggregated condition, look for an IF SUM([Field]) pattern returning string values — that's the reliable Tableau formula for categorical, aggregation-aware coloring.

Question 5

A worksheet uses discrete Category headers on rows and discrete Month headers on columns. Some categories have no records in certain months, and some months have no records for any currently displayed category. The analyst wants the complete row-and-column structure retained, with missing intersections left blank rather than displayed as zero.

Which approach is most appropriate?

  1. Enable Show Empty Rows and Show Empty Columns, while leaving missing measure values unconverted. (correct answer)
  2. Wrap the displayed measure in ZN and enable Show Missing Values on the date field to generate blank cells.
  3. Convert Category and Month to continuous fields, then place the measure on both Text and Detail.
  4. Disable Aggregate Measures and place the record identifier on Detail to generate the missing cells.
Explanation: When working with discrete dimensions in Tableau, you need to understand how Tableau handles structural completeness — the difference between showing all possible row-column combinations versus only showing combinations where data actually exists. Questions like this test whether you know which tools control the grid structure versus which tools handle measure display. The right approach here is A: enabling Show Empty Rows and Show Empty Columns. These options, available when right-clicking a discrete dimension header on the rows or columns shelf, tell Tableau to render every member of the dimension even when no matching records exist. The resulting empty intersections remain blank (null), which is exactly what the analyst wants — preserved structure without forcing zeros. The distractors each represent a different misconception. B conflates two separate concerns: ZN() converts nulls to zeros (the opposite of what's wanted), and "Show Missing Values" applies to continuous date axes — not discrete Month headers. C is a common trap: converting discrete fields to continuous changes the axis type entirely, collapsing the structured row-and-column grid into a continuous scale and breaking the categorical layout. D disabling Aggregate Measures and adding a record identifier to Detail controls granularity of rows in the data source — it doesn't generate missing dimension combinations and would likely produce duplicate or unexpected row structures. A useful pattern to remember: Show Empty Rows/Columns is your go-to when you need structural completeness with discrete headers. Reserve "Show Missing Values" for continuous date axes. Keeping this distinction clear will help you confidently navigate display-control questions on the exam.

Question 6

A text table already contains Department on rows, Month on columns, and SUM(Expenses) on Text. The analyst selects the view and chooses Highlight Table from Show Me. No fields are manually removed afterward.

What change should the analyst expect from this conversion?

  1. The measure becomes discrete headers, the dimensions move to filters, and the marks use shapes.
  2. The text labels are removed, the measure becomes a continuous axis, and the marks use bars.
  3. The dimensions move to Detail, the measure remains only on Text, and the marks use circles.
  4. The text labels remain, the measure is also encoded by color, and the marks use filled squares. (correct answer)
Explanation: When working with Show Me in Tableau, you need to understand what each chart type requires and what it adds — because Show Me doesn't just rearrange fields, it restructures the entire mark encoding to match the target visualization. A Highlight Table is essentially a text table with an added color layer. Tableau keeps your dimensions (Department, Month) on their respective shelves and your measure on Text, but it also places that same measure on Color, encoding values as filled square marks. This gives you both the numeric label and a color gradient that makes patterns visually scannable — which is exactly what D describes. The marks become filled squares (Tableau's default for highlight tables), text labels persist, and the measure does double duty on both Text and Color. Answer A is describing something closer to a dimension-heavy filter view with shape marks — none of which are part of a highlight table conversion. Answer B describes a bar chart transformation: removing text and adding a continuous axis are hallmarks of switching to a bar chart, not a highlight table. Answer C is the trickiest distractor — moving dimensions to Detail and using circle marks describes a scatter plot or circle view, not a highlight table, and a highlight table would never strip the measure off Text entirely. The key study tip here: memorize Show Me's "recipe" for each chart type — what shelf each field lands on, what mark type is used, and what encodings are active. For a highlight table specifically, remember the phrase "text plus color" — both are encoding the same measure simultaneously over a square mark grid.

Question 7

A multi-measure highlight table shows Sales, Profit, and Quantity using Measure Names and Measure Values. Measure Values is used on both Text and Color. Because the measures have very different numeric ranges, the combined color legend causes nearly all Profit and Quantity cells to appear the same color.

How should the analyst correct the color scaling while preserving the single worksheet?

  1. Place Measure Names on Detail instead of Columns, then rely on one automatic legend to scale all Measure Values.
  2. Convert Measure Names to a continuous field, then synchronize the three resulting color axes through the axis menu.
  3. Right-click the Measure Values color legend, select Use Separate Legends, then edit each measure's individual color scale. (correct answer)
  4. Normalize the displayed text formatting so all three measures share the same display units, reducing the numeric range gap.
Explanation: When working with highlight tables that use Measure Names and Measure Values, a critical challenge arises when your measures have vastly different numeric ranges — Sales in the millions will visually "drown out" Profit and Quantity on a shared color scale, compressing most cells into nearly identical hues. Tableau's solution for this exact scenario is separate legends. When Measure Values drives Color, you can right-click the color legend and choose Use Separate Legends, which splits the single combined scale into one independent color scale per measure. Each measure then gets its own min/max range, so Profit cells are colored relative to other Profit values, not relative to Sales. This is option C, and it's the correct approach — it fixes the scaling problem entirely within a single worksheet. Option A is wrong because moving Measure Names to Detail doesn't change how color scaling works; you'd lose the column structure of your highlight table without gaining any scaling benefit. Option B is a misconception about field types — Measure Names is a discrete dimension and cannot be converted to a continuous field in any meaningful way that creates separate color axes. Option D misunderstands the problem: changing display units (like showing Sales in thousands) affects the label text only, not the underlying values driving color calculations, so the scaling issue persists. A useful pattern to remember: anytime you see a Measure Values color legend behaving unexpectedly across very different measures, your first instinct should be to right-click that legend and look for Use Separate Legends — it's Tableau's built-in fix for exactly this situation.

Question 8

A worksheet must show Product Category on rows and Region on columns. Within each Category–Region intersection, users must see separate text values for Sales and Profit. No additional worksheets may be used.

Which configuration most directly creates the required text table?

  1. Place Category and Region on Rows, then place Sales and Profit separately on Text.
  2. Place Category on Rows, Region on Columns, Sales on Text, and Profit on Detail.
  3. Place Category on Rows, Region and Measure Names on Columns, and Measure Values on Text. (correct answer)
  4. Place Category and Measure Values on Rows, Region on Columns, and Measure Names on Text.
Explanation: Whenever Tableau questions ask you to display multiple measures as separate text values within a single worksheet, think immediately about the Measure Names / Measure Values pair. These are Tableau's built-in fields that let you pivot multiple measures into a single view without creating extra sheets. The configuration in C is the correct approach. Placing Category on Rows and Region on Columns establishes your crosstab structure. Adding Measure Names to Columns creates a sub-column for each measure (Sales, Profit), and placing Measure Values on Text populates each cell with the corresponding number as a text label. This directly produces a text table where every Category–Region intersection shows two separate, labeled values — exactly what the question requires. A fails because placing both Sales and Profit on Text simply concatenates or layers them on the same mark rather than creating distinct, labeled entries per measure. You lose the separation the question demands. B is a common trap: putting Profit on Detail means Tableau uses it for granularity in the background but never displays it visibly in the view. The user would only see Sales text, not both values. D misplaces the fields in a way that inverts the logic. Putting Measure Values on Rows would create row-based measure entries rather than column-based ones, and placing Measure Names on Text just labels a mark rather than building the column structure needed for side-by-side display. Study tip: Whenever you need to show multiple measures as text in one view, your default starting point should be Measure Names on Columns and Measure Values on Text — this is Tableau's standard text table pattern.

Question 9

A text table has Category on rows, Region on columns, and SUM(Sales) on Text. The analyst wants to retain the sales amounts as labels while coloring each cell by that region's percentage of its category's total sales. The percentages must sum to 100 percent across each row.

What should the analyst do?

  1. Duplicate SUM(Sales) onto Color, apply Percent of Total, and compute using Table (Across). (correct answer)
  2. Duplicate SUM(Sales) onto Color, apply Percent of Total, and compute using Table (Down).
  3. Move SUM(Sales) from Text to Color, apply Percent of Total, and compute using Pane (Down).
  4. Place Region on Color, apply Percent of Total to Text, and compute using Table (Across).
Explanation: When working with table calculations in Tableau, two concepts must work together: what's displayed (the mark label) and what drives the visual encoding (color). The key insight here is that these can come from different calculations on the same field — you don't have to sacrifice one for the other. The goal requires two things simultaneously: raw sales values as text labels, and percentage-of-row-total driving the color gradient. The way to achieve this is to place SUM(Sales) on both Text and Color — meaning you duplicate the pill, not move it. On the Color instance, you apply a Percent of Total table calculation. Because percentages must sum to 100% across each row (i.e., across regions within a category), the computation direction must be across the table — specifically, Table (Across). This makes A the correct answer. Answer B fails because "Table (Down)" computes percentages down each column, meaning values within each region sum to 100% — that's across categories, not across regions within a category. The percentages would no longer sum correctly per row. Answer C is a trap because moving SUM(Sales) to Color removes it from Text entirely, so you lose the raw sales labels. You'd be left with only colors and no numbers displayed on the marks. Answer D misunderstands how Color works in a text table. Placing a discrete dimension like Region on Color just segments marks by color identity — it doesn't create a continuous color gradient based on percentage magnitude. Study tip: Whenever a question asks you to show one thing and color by another, your first instinct should be to duplicate the measure rather than move it — that's Tableau's way of encoding two versions of the same field independently.

Question 10

A highlight table has Sub-Category on rows and Region on columns. Each cell must display total Sales as text, but its background color must indicate Profit Ratio. A loss-making cell can therefore show high Sales while still receiving a negative-profit color.

Which Marks card configuration meets both requirements without changing the table's level of detail?

  1. Place SUM(Sales) on Text, Profit Ratio on Color, and use the Square mark type. (correct answer)
  2. Place Profit Ratio on Text, SUM(Sales) on Color, and use the Square mark type.
  3. Place SUM(Sales) on both Text and Color, then add Profit Ratio to Detail.
  4. Place Measure Names on Text, Measure Values on Color, and add Sales to Detail.
Explanation: When building a highlight table in Tableau, you need to think carefully about which field controls the visual encoding (color or text) versus which field simply adds context. The mark type matters too — Square marks are what give highlight tables their characteristic colored-cell appearance. Option A is the correct configuration because it precisely separates the two requirements: SUM(Sales) on Text displays the numeric value inside each cell, while Profit Ratio on Color drives the background shading. Using Square marks ensures each cell renders as a filled rectangle whose color reflects profitability. This means a cell can show a high Sales number in text while displaying a red background due to negative profit — exactly what the passage requires. The level of detail (Sub-Category × Region) stays unchanged because no new dimensions are introduced. Option B swaps the roles: putting Profit Ratio on Text and SUM(Sales) on Color gives you colored cells based on Sales magnitude, not profit. You'd see profit numbers as text and have no visual indicator of loss versus gain — the opposite of what's needed. Option C places SUM(Sales) on both Text and Color, meaning the color reflects Sales, not Profit Ratio. Adding Profit Ratio to Detail doesn't make it drive the color; Detail only adds granularity without affecting visual marks. Option D introduces Measure Names and Measure Values, which is the pattern for combined-axis charts or crosstabs showing multiple measures simultaneously. This approach changes the structure of the view and doesn't cleanly isolate one measure for text and another for color. A useful rule of thumb: whichever field you drop on Color is what drives the background shading — so always verify that the business requirement maps directly to the correct shelf.