Question: 1 2 . On the Table orkse, insert a Histogram that displays the sales. Move the Histogram to the Dashboard worksheet, without using Copy, Cut

12. On the Table orkse, insert a Histogram that displays the sales. Move the Histogram to the Dashboard worksheet, without using Copy, Cut or Paste. Position the Histogram within M2.720.
Remove the Chart Title and the vertical axis. In the horizontal axis change the Number format to Accounting, no decimals. Then make sure the Number of bins is set to 5.(3)
13. Still on the shard worksheet, go the Summary area you it ate earlier. Use the Wei Tol database on the Table worksheet and the Subtotal function to calculate the following: In cell D3- Number of Products, in cell D4- Total Sales, in cell D5- Average Sales, cell D6- Minimum Quantity, and cell D7- Maximum Quantity. Be sure to use structural references in your functions! Cells are properly formatted. (11)
14. Copy the Table worksheet, rename the copied sheet Filter, move it after Table. In the Filter worksheet, clear any existing filters. Filter the Category column to display only Beverages, Condiments, Dried Fruit and Dried Vegetables. Sort the Category column in ascending order.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!