Analytics-DA-201 Exam Question 16

You have the following table.

You need each record to alternate between grey and white.
What should you change in the Format Shading pane?
  • Analytics-DA-201 Exam Question 17

    Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
    Create a histogram on the Quantity field by using bin size of 3.

    Analytics-DA-201 Exam Question 18

    A Data Analyst at a coffee company has the following visualization already built.

    The analyst wants to make this more visually appealing by coloring the bars based on whether they are above or below the Average Sales within each Product Type.
    Which calculation should the analyst use to calculate the Average Sales for each Product Type?
  • Analytics-DA-201 Exam Question 19


    You need the top 10 values to appear in a different color. The lop 10 values must be colored dynamically.
    What should you do?
  • Analytics-DA-201 Exam Question 20

    You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future Which three actions should you perform m order?
    (Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)