You have a calculated field that includes the value for distance. You use a parameter to control the distance in the view. You need to ensure that workbook users can enter any numeric value for the distance. Which setting should be configured in the Parameter? Set Allowable values to Range. Set Data type to String. Set Allowable values to List. Set Allowable values to All. 2 You have a field named Ship Date that contains the date on which orders are shipped. You need to create a calculated field that predicts delivery dates by adding one week to the Ship Date field. Which date function should you use? DATEDIFF DATEADD DATEPARSE DATEPART 3Which scope and direction option should you use to compute a percent of total table calculation that has a total of 100% on the right for each row in a text table? Table Cell Table (across) Pane (across then down) 4 In a viz showing monthly product sales, why might you use a reference line set to average? To compare sales month to month. To compare sales year to year. To compare sales of individual products. To compare actual sales to the sales average. 5 Your data contains a string field, CustomerName, and integer field, OrderID. You want to concatenate the fielc. CustomerName and OrderID to create a field called Customer and Order. You also want to add a comma and a space between CustomerName and OrderID. Which of the following calculations will give you the desired results? STR ([CustomerName]) + "," + STR ([OrderID]) STR ([CustomerName]) + ", " + [OrderID] [CustomerName] + ", " + [OrderID] [CustomerName] + ", " + STR ([OrderID]) You have a field that tracks the names of products that have been ordered. You need to create a calculated field that displays the number of unique products that were previously ordered. 6 Which aggregate function should you use? COVAR COUNT COUNTD ATTR 7 What is a calculation for profit as a percentage of sales, aggregated on the content in the view? SUM ([Profit]) / SUM ([Sales]) [Profit] / [Sales ] SUM ([Sales]) / SUM ([Profit]) [Sales] / [Profit] 8 Which of the following is best used to investigate the shape of a data distribution? Trend lines Histograms Bar charts Treemaps