A reference line is used in Tableau to display a line at a constant value or a computed value such as an average, median, minimum, or maximum in a bar chart. In this case, adding a reference line would allow you to show the median, upper quartile, and lower quartile, which corresponds to the changes shown in the bar chart.

In Tableau dashboards, floating elements are those that can be freely moved over the dashboard canvas without being snapped into the tiled layout. The floating elements are often indicated by their standalone frames and the ability to overlap with other dashboard items. From the provided image, the state filter and the Rate of Obesity chart can be identified as floating if they can be moved independently of the tiled grid layout that constrains other elements.

A Parameter action is designed to let users change a parameter value through direct interaction with a visualization. The parameter can then drive a calculated field that determines which measure—such as Sales, Profit, Quantity, or another metric—is displayed on the chart. Tableau ' s current action framework explicitly includes Change Parameter as an action type and notes that parameter actions can be used with calculations to customize how data is displayed. A Set action changes membership in a set, a Highlight action emphasizes selected marks without changing the metric being displayed, and a Filter action restricts the data shown in the target view. Because the requirement is to let the user dynamically select the measure displayed rather than filter or highlight records, the appropriate action type is Parameter .

To connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet, you need to select New Data Source from the Data menu. This will open the Connect pane, where you can choose Microsoft Excel as your data source and browse for your spreadsheet file. You can then drag and drop your sheets or tables to join or union them in the data source page. References: https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_excel.htm

When connecting to a dataset in Tableau Desktop, you would go to the ' Data ' menu and select ' New Data Source ' . This allows you to connect to various types of data sources, including Microsoft Excel spreadsheets, where you can then select the specific file you wish to connect to.

To ensure that the extract also refreshes on the last day of the month at 18:00, you need to add a new extract refresh task to the workbook on Tableau Server. You can do this by selecting the workbook, selecting Refresh Extracts, and then choosing Schedule a Refresh. You can then select an existing schedule that matches your desired frequency and time, or create a new schedule with a custom frequency and time. This will add a new extract refresh task to the workbook, in addition to the existing one that refreshes every Monday at 10:00. You can also modify or delete the extract refresh tasks as needed. References:

Tableau Certified Data Analyst Exam Prep Guide , page 10, section “Publishing and Scheduling Data Refreshes”

Tableau Help: Refresh Data on a Schedule

Tableau Help: Manage Refresh Tasks

Set actions allow selections made in a worksheet or dashboard to update membership in an existing set. That set can then be used in calculations or placed on the Marks card to change how another visualization is encoded. A common design is to place set membership on Color, so selecting marks in a source view changes which marks are in or out of the set and therefore changes their colors in a target view. This is exactly the interaction described in option B. Set actions are not intended to join or filter across unrelated data sources automatically, and pie-chart dataset-size comparison is simply a chart-design task. Likewise, highlighting proportions in a Gantt chart is not a defining set-action behavior. The key mechanism is selection-driven set membership that controls a visual property such as Color.