Question 11

Which Sub-Category had the least Profit in the Office Supplies category?
  • Question 12

    Which of the following are valid ways of Grouping Data?
  • Question 13

    Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?
  • Question 14

    Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
    Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
  • Question 15

    _________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins