1. Go to the Orders worksheet. The Deliveries table in the range A4:C27 lists the number of days between a customer order and the delivery of a mobile device. Marina wants to know how many orders were delivered in the periods listed in the range E5:E8.
Insert a histogram as follows to provide this information for Marina:
a. Use the Data Analysis tool to create a histogram.
b. Use the number of days until delivery (range C5:C27) as the input range.
c. Use the Bin list (range E5:E8) as the bin range.
d. Use cell A29 as the output range.
e. Show a cumulative percentage and chart output in the histogram.
2.Modify the Histogram chart as follows to incorporate it into the worksheet and display the data clearly:
a. Resize and position the Histogram chart so that it covers the range A35:G48.
b. Display the legend at the bottom of the chart to allow more room for the data.
3.The Order_Summary table in the range G4:J15 shows the sales for three categories of mobile device orders, with each category divided into types and then into models. Marina wants to display these hierarchies of information in a chart.
Insert a Sunburst chart to display the hierarchies for Marina as follows:
a. Insert a Sunburst chart based on the mobile device order data in the range G4:J15.
b.Resize and position the chart so that it covers the range G16:K34.
c. Use Mobile Device Orders as the chart title.
4. Go to the Customers by Plan worksheet, which contains a PivotTable showing the payments, customers, and lines for each plan. Marina does not need to display the number of lines, but does want to show subtotals in a different layout since Eastern Mobile is running a special on unlimited plans with three or more lines. Marina wants to know where the current customers of these plans reside so that she can encourage sales representatives to promote the plans in those states.
Modify the PivotTable for Marina as follows:
a. Remove the Sum of # of Lines field from the Values area.
b. Change the report layout to Tabular Form.
5. Go to the Sales Pivot worksheet, which contains a PivotTable comparing sales for plans in Quarter 1 and Quarter 2. Marina wants to know the difference between the two quarters.
Reorder the fields and add a calculated field to the PivotTable as follows:
a. Change the order of the fields in the Values area to display the Total of Q1 Sales before the Total of Q2 Sales.
b.Create a calculated field using Difference as its name.
c. The formula should subtract the Total Q1 Sales field value from the Total Q2 Sales field value to calculate the difference.
d. Use +/- Q1 to Q2 in cell D1 as the column heading for the calculated field.
6. Go to the Location Pivot worksheet, which contains a PivotTable and PivotChart that should show customer plan payments made according to where customers ordered their plans.
Move the State field below the Order Location field in the Rows area so that the PivotTable is easier to interpret.
7. Eastern Mobile is raising the cost per line of their Family plans. Marina wants you to fine-tune the PivotChart on the Location Pivot worksheet, but first asks you to update the data.
a. Return to the Plans worksheet, and then change the cost per line to $50.00 for the three Family plans.
b. Refresh the PivotChart data on the Location Pivot worksheet so that it displays accurate data.
8. Now you can make the PivotChart easier to understand and use as follows:
a. Change the PivotChart to a Stacked Column chart.
b. Apply Layout 4 to the PivotChart to display values in the columns, and then apply the Monochromatic Palette 4 colors if the colors changed when you changed the chart type.
c.Increase the height of the chart until the lower-right corner is in cell G30.
9. Add a slicer to the PivotTable and PivotChart as follows to make it easy for Marina to filter the data:
a. Add a slicer based on the Plan Type field.
b. Without resizing the slicer, position it so that its upper-left corner is in cell I9.
c. Use the slicer to filter the PivotTable and PivotChart to display Family and Unlimited plans only.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
