You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.


You want to create the following dashboard.
The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.
When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.
How should you lay out the objects on the dashboard?
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.
In a dataset, you have a string field named Name that contains unnecessary semicolons.
Which function should you use to remove the semicolons from the Name field?
You have a data set that contains three columns named Sales, Profit, and Quantity.
You need to build the following scatter plot.


