Question: 1
Open the link to Book1 found on the desktop. Open the sales dashboard.
Add the Sales by State sheet in a Show/Hide button to the right side of the dashboard.
Question: 2
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: 3
in which throe formats can you export a worksheet from the Worksheet menu? Choose three
Question: 4
You have a database that includes field named sales, City and Region.
You have the following chart that shows the number of sales made in different cities.
You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?
Question: 5
You have the following box plot that shows the distribution of average profits made in every state by region.
Which region has the smallest distribution of profits?
