Question 126

You have the following dataset.


When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.

What should you do?
  • Question 127

    You want to ensure that when you click a bar on a dashboard, a tooltip appears that contains a link named
    "Click here to know more!" as shown in the following exhibit.

    Question 128

    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?
  • Question 129

    You have a dataset that contains sates dat
    a. The following is a sample of the data.

    You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.
    Which two formulas achieve the goal Choose two
  • Question 130

    You have the following view.

    You want to filter the view lo show only records that have a movie name starting with the word. "The". You must achieve the goal without writing any formulas.
    Which type of filter should you use?