Question 11
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.

Split the Customer Name field into two fields named First Name and Last Name.

Question 12
You have a dataset that contains people and the awards they have won.

Which formula should you use to get the number of different types of awards that have been won?

Which formula should you use to get the number of different types of awards that have been won?
Question 13
You have the following dataset.
Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?
Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?
Question 14
You have a dashboard that contains a parameter named Start Date.
You need to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date.
What should you do?
You need to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date.
What should you do?
Question 15
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?

You want the months to appear as shown in the following chart.

What should you do?
