- Which worksheet formatting approach best meets the requirement?
Answer: Apply row banding to the Pane with a band size of one, leaving header banding unset.
When working with formatting in Tableau, it helps to think in two dimensions: what region you're formatting (Header vs. Pane) and what direction the banding runs (row vs. column). The Header region covers your row and column labels, while the Pane covers the body of the table where measure values live. Banding simply alternates a shaded band with an unshaded one at a given interval.
The requirement here is alternating shading on every other row of the table body, with headers left untouched. That maps directly to row banding on the Pane with a band size of one — each band covers one row, alternating shaded and unshaded, applied only to the data area. Because header banding is left unset, row labels remain clean and unshaded. That's exactly what D describes, making it the correct answer.
A is wrong because uniform pane shading colors everything the same tone — it doesn't alternate. Adding row dividers creates visual separation but not alternating color bands, so the requirement isn't met.
B applies row banding to the Header region, which would shade the row labels — the opposite of what's needed. The analyst explicitly wants headers unshaded, so targeting the Header region directly contradicts the requirement.
C applies column banding instead of row banding. Column banding alternates shading across columns, not rows, so you'd get vertical stripes rather than horizontal alternating rows.
A useful memory trick: match the direction of banding to the direction of your stripes (row banding → horizontal stripes), and match the region to where you want the effect (Pane = data body, Header = labels).
- Which command should the analyst use?
Answer: Select Worksheet > Clear > Manual Sizing to reset dimensions while retaining the fields, filters, and formatting.
When working with text tables in Tableau, it's important to understand the granularity of the Clear menu options under the Worksheet menu. Each option targets a specific layer of your view — formatting, sizing, filters, etc. — and choosing the wrong one can wipe out work you intended to keep.
In this scenario, the analyst needs to undo only the manual row and column sizing adjustments, while preserving custom shading (formatting) and filters. Worksheet > Clear > Manual Sizing does exactly this: it resets any manually adjusted dimensions back to automatic sizing without touching formatting or filters. That makes B the precise, surgical tool for the job.
A is tempting but incorrect. Clearing Formatting removes custom shading, colors, fonts, and other visual styling — which is exactly what the analyst wants to preserve. It doesn't specifically target row/column sizing either, so it solves the wrong problem and creates a new one.
C is a workaround, not a solution. Clearing the Columns shelf removes the fields themselves from the view, not just their sizing. Using Undo is unpredictable and could reverse other changes beyond just the column widths.
D is far too destructive. Clear Sheet wipes everything — fields, filters, formatting, and sizing — requiring the analyst to rebuild the view from scratch. This contradicts the requirement to retain filters.
A useful tip: on Tableau exams, when a question asks you to reset only one specific element of a view, look for the most targeted Worksheet > Clear sub-option. Tableau's Clear menu is designed with this precision in mind, and the exam frequently tests whether you know which sub-option affects which layer.
- What should the analyst expect when attempting to select Redo?
Answer: Redo is unavailable because the shading change created a new action branch.
Whenever you see a question about Tableau's Undo/Redo behavior, think about how Tableau manages its action history as a linear stack — not a branching tree that preserves alternate paths.
Here's the key concept: Tableau's Redo function only works when your current state sits at a point within an existing action history. The moment you perform any new action after undoing, you permanently overwrite the forward history. That new action becomes the current branch tip, and the previously "redoable" actions are discarded. In this scenario, the analyst undid the SUM(Sales) addition, then immediately made a new change — applying pane shading. That shading change wrote a new action onto the history stack, collapsing the Redo path entirely. Redo is now grayed out and unavailable, making C the correct answer.
A is wrong because it assumes Tableau can simultaneously restore SUM(Sales) and preserve the shading — this would require branching history, which Tableau doesn't support. B is similarly wrong; even if you imagined Redo somehow working, Tableau wouldn't selectively remove the shading — it would simply restore what was undone. That's not how the mechanism operates. D describes behavior that's entirely fictional — Redo never reverses a new action; that's what Undo is for. This choice conflates the two functions.
A useful rule of thumb: think of Undo/Redo like a tape recorder with no branching. Once you record something new mid-tape, everything that was ahead is erased. If a Tableau exam question mentions a new action taken between Undo and Redo, your answer is almost always that Redo becomes unavailable.
- Which formatting target should the analyst modify?
Answer: Modify the Pane font because the measure values appear in the table body.
When working with Tableau's formatting options, it helps to think of the view as divided into distinct zones — and formatting targets correspond to those zones, not to what the data means but to where it appears on the screen. The key distinction here is between headers (the row and column labels) and the pane (the body of the view where measure values are rendered).
Since the analyst wants to change the font for the sales figures — the actual numbers sitting inside the table body — the correct target is the Pane font. In Tableau's Format menu, "Pane" controls the appearance of marks and values displayed within the interior cells of the view. Modifying it leaves the Region and Category headings completely untouched, which is exactly the goal. B is the right answer.
A is a common trap: headers do control row and column label text (like "East," "West," "Furniture," "Technology"), but they have no effect on the values inside the body. Choosing this would change the wrong thing entirely. C is wrong because the worksheet title refers to the sheet name displayed at the top of the view — it sets no default for cell-level data and is irrelevant here. D confuses "field labels" (the dimension name labels like "Region" and "Category" that appear above or beside headers) with the measure values themselves; these are yet another distinct formatting zone.
A useful habit: before selecting a formatting target in Tableau, ask yourself where in the view the element lives — title, field label, header, or pane — and match that location to the correct Format option.
- What should the worksheet contain after Undo?
Answer: The custom formatting returns, and the existing field placements remain unchanged.
When working with Tableau's Clear and Undo functions, it helps to understand what each operation actually touches — and how Tableau treats them as distinct, reversible actions.
Worksheet > Clear > Formatting is a targeted operation. It resets only visual formatting elements — custom fonts, shading, and borders — back to Tableau's defaults. Critically, it does not touch field placements on Rows, Columns, or Filters. Those remain exactly where they are. Once you apply this clear, Undo reverses it completely, restoring your custom formatting while leaving everything else — including those field placements — exactly as they were. That makes A the correct answer.
Here's why the other options fall apart. B suggests that field placements return after Undo, implying they were removed by the Clear Formatting action — but they weren't. Clear > Formatting never touches field placements, so there's nothing field-related to undo. C claims that all fields are removed, which would be the result of Clear > All or Clear > Fields, not Clear > Formatting — these are separate sub-options under the Clear menu. D states that clearing formatting cannot be undone, which is simply false. Tableau's Undo stack tracks formatting changes just like any other action, so this is fully reversible.
A useful study tip: memorize Tableau's Clear sub-menu options — Formatting, Fields, Filter, Manual Sizing, and All — because exam questions love to test whether you know which one affects which layer. When you see "Clear > Formatting," think visuals only, and remember that Undo always restores the state just before that action.
- What is the resulting worksheet state?
Answer: Only YEAR(Order Date) and Region are removed; the other field placements remain.
When working with Tableau's shelf system, it's important to understand that each shelf — Columns, Rows, Color, Size, Filters, etc. — operates independently. Clearing one shelf affects only the fields living on that specific shelf, nothing more.
When you select Clear Shelf from the Columns shelf menu, Tableau removes every field currently placed on the Columns shelf — in this case, both YEAR(Order Date) and Region. The Rows shelf, Marks card, and Filters shelf are completely untouched. So SUM(Profit) stays on Rows, Segment stays on Color, and Category stays on Filters. This makes A the correct answer: only the Columns fields are removed, and everything else remains exactly as it was.
B describes a "Clear Sheet" or "Clear Worksheet" operation — a much more destructive action that wipes all field placements across every shelf simultaneously. Don't confuse "Clear Shelf" with "Clear Sheet." C is built on a false premise: the Rows shelf and Columns shelf are independent. Clearing Columns has no cascading effect on Rows just because both contribute to the axis structure of a chart. D reflects a misunderstanding of how Clear Shelf works — it removes all fields on that shelf, not just the last one added. There's no "most recent" logic here; every field on the shelf is cleared at once.
A useful habit: when you see Tableau questions involving shelf operations, mentally picture each shelf as its own container. Clearing one container empties only that container — neighboring containers stay full.
- Which fields remain in the worksheet after the final action?
Answer: Region remains on Columns, and SUM(Sales) is restored to Rows.
When working with Tableau's Undo/Redo system, think of each action as a discrete, reversible step on a linear history stack — not a snapshot of the full worksheet state.
Here's how the sequence plays out: The analyst takes three actions — (1) place Region on Columns, (2) place SUM(Sales) on Rows, (3) place Category on Filters. Selecting Undo twice reverses the last two actions, removing Category from Filters and SUM(Sales) from Rows. Only Region remains on Columns. Then Redo once replays exactly one undone action — the most recently undone step, which was placing SUM(Sales) on Rows. The result: Region on Columns and SUM(Sales) on Rows, making A the correct answer.
B is tempting but wrong — it assumes Redo restores Category to Filters, skipping over the fact that SUM(Sales) was undone before Category was. Redo always replays actions in the order they were originally performed, so SUM(Sales) comes back first, not Category.
C incorrectly claims Redo simply repeats the undo operation itself, as if it removes another field. Redo does the opposite — it re-applies an action that was undone. It doesn't compound the undo.
D reflects a common misconception that Redo is a "restore all" command. Tableau's Redo is granular — it replays one step at a time, not the entire session state.
Study tip: Treat Undo/Redo questions like a stack: Undo pops actions off, Redo pushes them back on — one at a time, in strict order. Count the steps carefully.
- What is the expected effect on Worksheet B?
Answer: Worksheet B adopts the copied visual formatting but retains its own fields and view construction.
When working with Tableau's formatting tools, it helps to distinguish between what a worksheet shows (its fields, shelves, filters, and chart type) and how it looks (fonts, shading, borders, line styles). These are two independent layers, and Tableau lets you copy just the visual layer from one worksheet to another using Format > Copy Formatting and Paste Formatting.
That's exactly what makes D correct. When you paste formatting onto Worksheet B, Tableau applies only the visual styling — the fonts, shading, borders, and line formatting from Worksheet A — while leaving Worksheet B's fields, measures, dimensions, and chart type completely untouched. The two worksheets can look stylistically consistent without sharing any data structure.
A is wrong because it understates what formatting paste transfers. It isn't limited to fonts — all visual formatting elements (shading, borders, lines) carry over together, not selectively. B has the logic completely backwards: fields and shelves are never transferred through formatting paste; only the visual styling moves, not the data structure. C describes what would happen if you duplicated a worksheet entirely, which copies everything — fields, filters, chart type, and formatting — a fundamentally different operation from copy/paste formatting.
A useful way to remember this: think of formatting paste as a paint job, not a transplant. You're repainting Worksheet B's exterior to match Worksheet A, but the engine and interior stay exactly as they were. On the Tableau exam, any time you see "copy formatting," lock in on the idea that data and structure never move — only style does.
- How should values be formatted when Profit and another measure are displayed in the worksheet?
Answer: Profit uses red, while the other measure continues to use the worksheet-level blue.
Tableau uses a layered formatting hierarchy where more specific settings take precedence over broader ones. When you see a question about competing format levels, ask yourself: which setting is more targeted? Field-level formatting sits above worksheet-level formatting in that hierarchy, meaning it wins for the specific field it targets — but only for that field.
In this scenario, the blue pane font is applied at the worksheet level, acting as a baseline for all fields. When the analyst then selects Profit in the field selector and applies red, that red setting is scoped exclusively to Profit. Tableau treats this as a more precise instruction that overrides the worksheet default — but only where that instruction applies. Any other measure with no field-specific setting simply falls back to the worksheet-level blue. That's exactly what option C describes, making it correct.
Option A is wrong because a field-level change doesn't ripple outward to the entire worksheet. It only affects the targeted field. Option B has the hierarchy backwards — worksheet formatting does not override field-specific formatting; it's the other way around. Field-level settings are more granular and therefore take priority. Option D inverts the logic entirely: it incorrectly assigns blue to Profit (which has the red override) and red to the other measure (which has no field-specific setting at all).
A useful rule of thumb: in Tableau's formatting system, specificity wins. Field-level > worksheet-level > workbook-level. If a question describes settings applied at multiple levels, always identify which level is most specific — that's the one that will render on screen.
- Which result should the analyst expect immediately after the command?
Answer: The fields are removed from the view, while the worksheet's custom formatting is retained.
When working with Tableau's worksheet management commands, it's important to distinguish between what's on the shelves (fields, filters, marks configurations) and how the view looks (custom fonts, shading, formatting). Clear Sheet targets these two categories differently, which is exactly what this question tests.
Clear Sheet removes all fields from every shelf — Rows, Columns, Filters, and the Marks card — essentially wiping the data-driven structure of the view. However, it deliberately preserves any custom formatting you've applied, such as fonts, background shading, and dividers. This makes answer B correct: the fields disappear, but your formatting stays intact. Tableau treats formatting as a separate layer that you'd remove intentionally using Format > Clear Sheet from the Format menu, not through the worksheet-level Clear Sheet command.
Answer A is wrong because Clear Sheet doesn't limit itself to just Rows and Columns — it clears all shelves including Filters and the Marks card. Answer C reverses the actual behavior entirely; formatting is what survives Clear Sheet, not the fields. Answer D describes what you might expect from a completely fresh worksheet, but that's not what Clear Sheet does — it's a common trap to assume "clear" means "erase everything."
A helpful mental model: think of Clear Sheet as clearing the data conversation you're having with Tableau, while leaving the room's décor (formatting) untouched. If you also want to reset formatting, you need a separate, explicit action. On the Tableau exam, watch for questions that conflate data configuration with visual formatting — they're tested as distinct concepts.
