$4.$ which of the following statements describes a reference band? a$)$Adds a gradient of shading to indicate the distribution of values along the axis b$)$ Adds a line at a constant or computed value on the axis c$)$Creates a standardized graphic for describing the distribution of values along an axis d$)$ Shades an area behind the marks in the view between two constant or computed values on the axis

$5.$ your date contains a string field, Customer Name, and an integer, ORderID. You want to concatenate the fields Customer Name and Order ID 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. a$)[$CustomerName$]+\text{'}+[$OrderID$]$: b$)$ STR$([$CustomerName$])+","+$ STR$([$OrderID$])$: c$)[$CustomerName$]+","+$ STR$([$OrderID$])$ d$)$ STR$([$CustomerName$])+","+[$OrderID$]$

$6.$you have a field name 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? a$)$ DATEDIFF b$)$ DATEPART c$)$ DATEPHASE d$)$ DATEADD

$7.$ you have a field that tracks products that have been ordered. You need to create a calculated field that displays the number of unique products that were previously ordered. which aggregate function should you use? a$)$ COVAR b$)$ COUNTD c$)$ COUNT d$)$ ATTR

$8.$ which function should you use in a table calculation to specify the offset in a table? a$)$ WINDOW$\_$COUNT$()$ b$)$ FIRST$()$ c$)$ RANK$()$ d$)$ INDEX$()$

$9.$ sales of tables in your company have fluctuated over the years, and you want to create a view that shows the annual change in sales of Tables. Which quick table calculation can you use to show the change in sales over the years. a$)$ rank b$)$ Year over Year Growth c$)$ running total d$)$ YTD Growth

$10.$ which tend line model uses the formula Y$=$b$0+$ b$1*$In$($X$)?$ a$)$ linear b$)$ Power c$)$ logarithmic d$)$ Polynomial

$11.$ 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. What should you do$?$ a$)$ set Allowable values to All b$)$ set Data type to String c$)$ set the Step size to $1$ d$)$ set Allowable values to Range

$12.$ after you create a calculated field that concatenates the Region and Country fields, what happens to the original Region and Country fields? a$)$They are replaced in the Data pane but remain in the original data source. b$)$ They remain in the Data pane and in the original data source. c$)$ They remain in the Data pane but are replaced in the original data source. d$)$ They are replaced in both the Data pane and in the original data source.