Explanation

Connecting a Tableau workbook to an Excel spreadsheet requires establishing a live or extract connection to the file so Tableau can read its sheets, named ranges, or tables. This is always initiated through the dedicated connection workflow in Tableau Desktop, not by opening or importing the workbook itself. Only one menu option starts this process correctly.

Correct Option:

✅ A. From the Data menu select New Data Source
This is the official and only way to add a brand-new Excel file (or any other data source) to your workbook. Choosing Data → New Data Source opens the Connect pane, where you select “Microsoft Excel,” browse to your .xlsx or .xls file, and Tableau instantly previews sheets and connections. You can then join multiple sheets, create relationships, or build extracts.

Incorrect Options:

❌ B. From the Data menu select Replace Data Source
→ Replace Data Source is strictly for swapping an existing connection with another data source that has identical structure (same field names and data types). It cannot be used to introduce a completely new Excel file and will be grayed out if no data source exists yet.

❌ C. From the File menu select Import Workbook
→ There is no “Import Workbook” command in Tableau Desktop. The File menu offers Open, Save, Export as .twbx, etc., but none of these options establish a data connection to an external Excel file.

❌ D. From the File menu select New
→ File → New creates an empty workbook with no data sources attached. While you can add data afterward, this step alone does not connect to Excel—it only clears the current workspace and starts a blank canvas.

Reference:
Tableau Official Help – Connect to Excel: Excel
New vs Replace Data Source (official distinction): Blend Your Data

Explanation

The goal is to add a single horizontal line that acts as a baseline or target across the entire visualization, allowing for easy comparison of each bar's value against that fixed point. A reference line in Tableau is precisely designed for this purpose: to mark a constant value, an average, a sum, or a calculated parameter value across the axis.

✅ Correct Option: B (A reference line)
A reference line draws a single line across the axis to indicate a specific, constant value (e.g., a target, budget, or previous year's maximum). It is a simple and effective way to instantly show if the bars (the data points) are above or below a key benchmark. This matches the required visualization, which shows one fixed horizontal line.

❌ Incorrect Option: A (A reference band)
A reference band shades an area between two values on the axis (e.g., Min and Max, or 80th and 100th percentile). It is used to highlight a range of acceptable or target values, which is different from showing a single, fixed benchmark line.

❌ Incorrect Option: C (An average line)
An average line is a specific type of reference line that is automatically calculated as the average of the measure currently in the view. While it results in a single line, if the desired line is a specific, pre-determined value (e.g., a fixed sales target of $10,000) and not the calculated average of the displayed data, then the more general Reference Line option is the correct choice to ensure flexibility and accuracy.

❌ Incorrect Option: D (A distribution band)
A distribution band shades the area of the distribution of values, such as the area within one or two standard deviations, or within a specific percentile range (e.g., the middle 60%). Similar to a reference band, it highlights a range (a band), not a single, fixed line.

🔗 Reference
Reference Lines, Bands, Distributions, and Boxes

Explanation

A Tableau Data Extract (a .hyper file) is a static snapshot of data. To filter this extract using a dynamic value like a parameter, you must define the filter criteria using a calculated field. This calculated field creates a boolean condition (e.g., [Date] >= [Start Date]). Adding this calculation to the Extract Filter and setting it to True permanently locks the extract to the records that satisfy the condition based on the parameter's value at the time of extraction.

✅ Correct Option: A (Create a data source based on the Excel worksheet and create a calculated field based on Start Date. Add the calculated field to the extract filter.)
The first step is establishing the connection to the Excel file to create a data source. A calculated field, such as [Order Date] >= [Start Date], is necessary to compare the data field against the parameter value. This calculated field is then applied in the Extract Filter dialog box, selected to filter for the True condition, ensuring only the qualifying records are included in the extract file.

❌ Incorrect Option: B (Create a custom SQL query to define the data source and create a calculated field based on Start Date. Add the calculated field to the extract filter.)
Microsoft Excel files, which are flat files, do not typically support the use of Custom SQL queries to define the data source connection in Tableau. Custom SQL is a feature generally reserved for connections to relational databases (e.g., SQL Server, PostgreSQL) where a query language is required to define the data input.

❌ Incorrect Option: C (Create a custom SQL query that references Start Date in the WHERE clause.)
This approach fails for two reasons: Custom SQL is not applicable to Excel data sources, and Tableau parameters cannot be directly referenced by name within the text of a Custom SQL query for filtering in this context. This method is only valid for some database connections via a Data Source Filter, but not for an Excel extract.

❌ Incorrect Option: D (Create a data source based on the Excel worksheet and create a calculated field based on Start Date. From the Data pane, add the calculated field to the data source filter)
While using a Data Source Filter (as opposed to an Extract Filter) achieves the exact same result (the filter is applied before the extract is saved), the most precise control for defining the contents of the extract file is specifically through the Extract Filter configuration dialog, which is the mechanism referenced in Option A.

🔗 Reference
Extract Your Data - Tableau Help

Explanation

If the data is already visible in a table on a webpage, the absolute fastest way to get it into Tableau is by selecting the table, copying it (Ctrl+C), and pasting directly into Tableau. No files, no drivers, no coding – it just works instantly.

✅ Correct Option: B. Clipboard
Tableau treats anything copied from an HTML table as structured data. Simply open Tableau → click in the Connect pane → press Ctrl+V (or Data → Paste Data). In seconds you have a ready-to-use dataset. Perfect for quick exploration with zero setup.

❌ Incorrect Option: A. ODBC connector
ODBC is a database protocol that requires a compatible driver, server address, port, authentication, and often IT/admin approval. Public websites almost never expose their front-end tables via ODBC, so this approach is either impossible or requires building a whole backend extraction pipeline — completely opposite of “least effort.”

❌ Incorrect Option: C. Web data connector
A Web Data Connector needs either a pre-built connector from the Tableau community or custom JavaScript development (HTML parsing, authentication handling, pagination, etc.). Even if a connector exists, you still have to discover, install, configure, and refresh it — far more steps and technical overhead than a simple copy-paste.

❌ Incorrect Option: D. CSV file
Using a CSV forces an extra workflow: the website must offer a download button (many don’t), you wait for the file to save, locate it on your computer, then drag it into Tableau. If no export exists, you’d have to manually copy into Excel first and save — multiple slow, error-prone steps compared to instant clipboard import.

Reference:
https://help.tableau.com/current/pro/desktop/en-us/examples_paste.htm

Explanation

A Tableau extract is a highly compressed, optimized snapshot of data stored locally on your machine. This local copy, which uses Tableau's proprietary high-performance engine, improves visualization speed, reduces the load on the original database, and allows for offline work. Since Tableau version 10.5, the modern file extension for a data extract is .hyper (replacing the older .tde extension).

✅ Correct Option: C. Sales.hyper
The .hyper extension specifically denotes a Tableau Data Extract file. This file type contains the actual data from the source, compressed and stored in a columnar format that is highly optimized for fast querying within Tableau. It functions as an independent, local copy of the data, which is the definition of an extract.

❌ Incorrect Option: A. Export.mdb
The .mdb extension is associated with a Microsoft Access Database file. While Tableau can connect to this file type to access data, the .mdb file itself is the original data source, not a Tableau-created or optimized data extract. It is a proprietary database format separate from Tableau's extract technology.

❌ Incorrect Option: B. Book1.twb
The .twb (Tableau Workbook) extension contains the design and logic of your visualization, such as worksheets, dashboards, and connection information. Crucially, a standard .twb file does not contain the actual underlying data. It requires live access to the original data source (like the .csv or a database).

❌ Incorrect Option: D. Sales.csv
A .csv (Comma Separated Values) file is a plain-text file containing raw data, which serves as a simple data source. Tableau can connect to this file type, but the file itself is the original source of data, not a compressed, optimized Tableau extract file.

🌐 Reference
Tableau File Types and Folders