You have the following line chart that shows the average sales by month. Which month had the biggest increase in swage sales compared to me previous month in 2019?
Correct Answer: B
To find the month that had the biggest increase in average sales compared to the previous month in 2019, you need to compare the slopes of the line segments between each pair of months. The steeper the slope, the greater the increase. Based on the line chart, October had the steepest slope, meaning it had the biggest increase in average sales compared to September in 2019. Reference: https://help.tableau.com/current/pro/desktop/en-us/buildexamples_line.htm https://www.mathsisfun.com/algebra/line-equation-slope.html
Question 67
You have the following chart that shows the cumulative of sales from various dates. You want the months to appear as shown in the following chart. What should you do?
Correct Answer: A
References: https://help.tableau.com/current/pro/desktop/en-us/dates.htm https://help.tableau.com/current/pro /desktop/en-us/dates_continuous.htm https://help.tableau.com/current/pro/desktop/en-us/formatting.htm To ensure the dates are shown in a continuous axis, you should convert the date to a continuous field. This will display the months in a sequence without any breaks, which is needed for showing a trend over time like the cumulative sum of sales.
Question 68
Open the link to Book1 found on the desktop. Open the Line worksheet. Modify the chart to show only main and max values of both measures in each region.
Correct Answer:
check the steps below in explanation. Explanation: To modify the chart to show only min and max values of both measures in each region, you need to do the following steps: Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Line worksheet. Click on the Line tab at the bottom of the workbook to open the worksheet. You will see a line chart that shows the sales and profit for each month by region. Drag Month from the Columns shelf to Filters shelf. This will open a dialog box that allows you to filter by different criteria. Select Range of Dates from the dialog box. This will show you options to filter by a range of dates or values. Select Minimum and Maximum from the drop-down list next to Month. This will filter by the minimum and maximum values of Month for each region. You can also enter specific values or use the sliders to adjust the range. Click OK to apply the filter. You will see that the line chart now shows only min and max values of both measures in each region. References: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_range.htm
Question 69
You have the following dataset. You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer Which formula should you use for the filter?
Correct Answer: D
To create a boolean calculated field to place on the data source filter, you should use the formula USERNAME() = [Tableau_user]. This formula will return TRUE if the current Tableau user name matches the value in the Tableau_user field, and FALSE otherwise. You can use this formula as a data source filter by dragging it to the Filters shelf and selecting TRUE from the menu. This will filter the data to show only the rows that are relevant to the specific Tableau user. The other options are not correct for this scenario. NAME([Tableau_user]) is not a valid function in Tableau. ISFULLNAME([Tableau_user]) = USERNAME() is not a valid expression in Tableau. 'S' + STR([Sales] /1000) is not a boolean expression, but a string expression that converts sales to thousands with a prefix of "S". References: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help. tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#USERNAME https://help.tableau. com/current/pro/desktop/en-us/calculations_calculatedfields.htm In Tableau, the USERNAME() function returns the username of the user who is currently logged in. To create a filter that only shows data relevant to the logged-in Tableau user, a boolean calculated field can be created to compare the current username with the usernames listed in the Tableau_User_Name field of the dataset. Therefore, the correct formula for this filter is USERNAME() = [Tableau_USER_NAME], which will return true for rows where the Tableau_User_Name matches the current user's username.
Question 70
in which three formats can you export a worksheet from the Worksheet menu? Choose three
Correct Answer: A,C,F
A) .png C) .xlsx F) .csv The Worksheet menu is a menu that appears at the top of the Tableau window when you are working on a worksheet. It contains various options and commands that you can use to work with your worksheet, such as formatting, sorting, filtering, and exporting. The Export option is a sub-menu that allows you to export your worksheet to different formats, such as image, data, or cross tab. You can access the Export option by clicking on Worksheet > Export from the menu. The .png format is an image format that you can use to export a worksheet as an image file. An image file is a file that contains a picture of your worksheet, such as a chart or a table. You can use an image file to share your worksheet with others or insert it into other documents or applications. You can export a worksheet as an image file by selecting Worksheet > Export > Image from the menu. This will open a dialog box where you can choose a file name, location, and resolution for your image. The .xlsx format is an Excel format that you can use to export a worksheet as an Excel workbook. An Excel workbook is a file that contains one or more worksheets in a spreadsheet application, such as Microsoft Excel. You can use an Excel workbook to work with your data in Excel or import it into other applications or databases. You can export a worksheet as an Excel workbook by selecting Worksheet > Export > Data from the menu. This will open a dialog box where you can choose a file name and location for your workbook. The .csv format is a comma-separated values format that you can use to export a worksheet as a text file with values separated by commas. A text file is a file that contains plain text without any formatting or graphics. You can use a text file to store or transfer your data in a simple and universal format. You can export a worksheet as a text file by selecting Worksheet > Export > Crosstab to Excel from the menu. This will open a dialog box where you can choose a file name and location for your text file. The other options are not correct for this scenario. The .html format is a web page format that you can use to export a dashboard or a story as a web page file. A web page file is a file that contains HTML code that defines the structure and content of a web page. You can use a web page file to view your dashboard or story in a web browser or embed it into other web pages or applications. However, you cannot export a worksheet as a web page file from the Worksheet menu. You have to use the Dashboard menu or the Story menu instead. The .txt format is another text format that you can use to export data as a text file with values separated by tabs. However, you cannot export data as a .txt file from the Worksheet menu. You have to use the Data Source menu instead. The .pptx format is a PowerPoint format that you can use to export one or more worksheets as PowerPoint slides. A PowerPoint slide is a page that contains graphics and text that are part of a presentation in Microsoft PowerPoint. You can use PowerPoint slides to present your worksheets to others or insert them into other presentations or documents. However, you cannot export worksheets as PowerPoint slides from the Worksheet menu. You have to use the File menu instead. Reference: https://help.tableau.com/current/pro/desktop/en-us/export.htm https://help.tableau.com/current/pro/desktop/en-us/export_image.htm https://help.tableau.com/current/pro/desktop/en-us/export_data.htm https://help.tableau.com/current/pro/desktop/en-us/export_crosstab.htm https://help.tableau.com/current/pro/desktop/en-us/export_web.htm https://help.tableau.com/current/pro/desktop/en-us/export_datasource.htm https://help.tableau.com/current/pro/desktop/en-us/export_powerpoint.htm Explanation: The three formats that you can export a worksheet from the Worksheet menu are:
