To answer this question, complete the lab using the information below.

In this lab, your task is to create charts to display revenue information. You'll need to create and modify both a chart and a PivotChart. Perform the following actions:

1. On the Regions sheet, use the data in A1:C9 to create a combo chart using clustered columns for revenue and a line for cost of goods sold, with both fields sharing the same axis.
2. On the Alter Data sheet, modify the data selection to only use year 1 and year 2.
3. From the Product Data sheet, create a PivotChart using default values, with Products as the rows, Regions as the columns, and Revenue in the Values field.
4. On the Array worksheet, in cell B2, use the RANDARRAY function to fill B2:E5 with random integers. All the numbers should be between 0 and 25 (inclusive), and each number should be a multiple of 5.