Tableau Quiz: Worksheet Basics
10 questions · exam conditions
0:00
Worksheet BasicsQuestion 1 of 10

An analyst has built a worksheet using several fields on Rows, Columns, Filters, and the Marks card. The worksheet also has custom fonts, background shading, and divider formatting. The analyst selects Clear Sheet.

Which result should the analyst expect immediately after the command?

The fields are removed from Rows and Columns only, while Filters, the Marks card, and custom formatting remain unchanged.
The fields are removed from the view, while the worksheet's custom formatting is retained.
The custom formatting is reset to defaults, while all fields remain on their existing shelves and the Marks card.
Both the fields and the custom formatting are reset, leaving the worksheet in a new blank state.
← Back to quizzes

Tableau Quiz

Tableau Quiz: Worksheet Basics

Practice Worksheet Basics 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 Worksheet Basics, 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

An analyst has built a worksheet using several fields on Rows, Columns, Filters, and the Marks card. The worksheet also has custom fonts, background shading, and divider formatting. The analyst selects Clear Sheet.

Which result should the analyst expect immediately after the command?

  1. The fields are removed from Rows and Columns only, while Filters, the Marks card, and custom formatting remain unchanged.
  2. The fields are removed from the view, while the worksheet's custom formatting is retained. (correct answer)
  3. The custom formatting is reset to defaults, while all fields remain on their existing shelves and the Marks card.
  4. Both the fields and the custom formatting are reset, leaving the worksheet in a new blank state.
Explanation: 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.

Question 2

A worksheet uses custom font, shading, and border settings. It also contains fields on Rows, Columns, and Filters. An analyst selects Worksheet > Clear > Formatting, reviews the result, and then selects Undo once.

What should the worksheet contain after Undo?

  1. The custom formatting returns, and the existing field placements remain unchanged. (correct answer)
  2. The field placements return, but the custom formatting remains at its default settings.
  3. The custom formatting returns, but all fields are removed from the worksheet.
  4. The worksheet remains unchanged because clearing formatting cannot be undone.
Explanation: 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.

Question 3

Worksheet A and Worksheet B contain different fields and different chart types. Worksheet A has the desired fonts, shading, borders, and line formatting. The analyst copies the formatting from Worksheet A and pastes it onto Worksheet B.

What is the expected effect on Worksheet B?

  1. Worksheet B adopts only Worksheet A's font settings because other formats cannot be pasted.
  2. Worksheet B adopts Worksheet A's fields and shelves but retains its original visual formatting.
  3. Worksheet B becomes a duplicate of Worksheet A, including its fields, filters, and chart type.
  4. Worksheet B adopts the copied visual formatting but retains its own fields and view construction. (correct answer)
Explanation: 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.

Question 4

An analyst first applies a blue pane font at the worksheet level. The analyst then selects Profit in the Format pane's field selector and applies a red pane font specifically to that field. Other measures retain no field-specific font setting.

How should values be formatted when Profit and another measure are displayed in the worksheet?

  1. Both measures use red because the most recent font change applies across the worksheet.
  2. Both measures use blue because worksheet formatting overrides field-specific formatting.
  3. Profit uses red, while the other measure continues to use the worksheet-level blue. (correct answer)
  4. Profit uses blue, while the other measure inherits the field-specific red setting.
Explanation: 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.

Question 5

A worksheet has YEAR(Order Date) and Region on Columns, SUM(Profit) on Rows, Segment on Color, and Category on Filters. The analyst opens the Columns shelf menu and selects Clear Shelf.

What is the resulting worksheet state?

  1. Only YEAR(Order Date) and Region are removed; the other field placements remain. (correct answer)
  2. All fields are removed from every shelf, but the worksheet formatting remains.
  3. The Columns fields and SUM(Profit) are removed because both define the axes.
  4. Only Region is removed because it is the last field on the Columns shelf.
Explanation: 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.

Question 6

A worksheet contains Region on Rows and SUM(Sales) on Columns. An analyst selects Undo, which removes SUM(Sales). Before selecting Redo, the analyst changes the worksheet's pane shading.

What should the analyst expect when attempting to select Redo?

  1. Redo restores SUM(Sales) and retains the newly applied pane shading.
  2. Redo restores SUM(Sales) but removes the newly applied pane shading.
  3. Redo is unavailable because the shading change created a new action branch. (correct answer)
  4. Redo reverses the shading change while leaving SUM(Sales) removed.
Explanation: 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.

Question 7

An analyst performs these actions in order on a blank worksheet: places Region on Columns, places SUM(Sales) on Rows, and places Category on Filters. The analyst then selects Undo twice and Redo once.

Which fields remain in the worksheet after the final action?

  1. Region remains on Columns, and SUM(Sales) is restored to Rows. (correct answer)
  2. Region remains on Columns, and Category is restored to Filters.
  3. Only Region remains because Redo repeats the most recent undo operation.
  4. All three fields return because Redo restores the worksheet's last complete state.
Explanation: 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.

Question 8

An analyst manually widens several columns in a text table. The worksheet also contains custom shading and filters that must remain unchanged. The analyst wants to return only the manually adjusted row and column dimensions to their automatic sizing.

Which command should the analyst use?

  1. Select Worksheet > Clear > Formatting to reset dimensions while retaining the fields and filters.
  2. Select Worksheet > Clear > Manual Sizing to reset dimensions while retaining the fields, filters, and formatting. (correct answer)
  3. Clear the Columns shelf and use Undo to recalculate automatic widths while retaining the filters.
  4. Select Clear Sheet and re-add the fields to restore automatic dimensions while retaining the filters.
Explanation: 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.

Question 9

A text table displays Region as row headings, Category as column headings, and sales values within the body of the table. The analyst wants to change the font used for the sales values without changing either set of headings.

Which formatting target should the analyst modify?

  1. Modify the Header font because headers control all text displayed in the table.
  2. Modify the Pane font because the measure values appear in the table body. (correct answer)
  3. Modify the worksheet title font because it establishes the sheet's text defaults.
  4. Modify the field-label font because field labels control the displayed measure values.
Explanation: 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.

Question 10

A text table has row headers and multiple rows of measure values. An analyst wants alternating shading on every other row of the table body, while leaving all row headers unshaded.

Which worksheet formatting approach best meets the requirement?

  1. Apply uniform pane shading and add row dividers between each pair of displayed rows.
  2. Apply row banding to the Header with a band size of one, leaving pane banding unset.
  3. Apply column banding to the Pane with a band size of one, leaving header banding unset.
  4. Apply row banding to the Pane with a band size of one, leaving header banding unset. (correct answer)
Explanation: 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).