Project 7

1.       On the “Database” worksheet, remove table functionable of the table. Retain value, format and data location.

2.       On the “BeSam” worksheet, insert a column sparkline in cell F3 to represent the quantity of Complaint Type from Quarter 1 to 4. Fill this sparkline to the entire “Histogram” column without changing formatting of other cells.

3.       Add the logo.png file in the CA.EDocument folder to the right of the “Monthly Budget” title on the “Database” worksheet. Apply Pencil Grayscale aristic effect and Fill Pattern type Horizontal Brick with Dark Blue Foreground color to this picture.

4.       On the “BeSam” worksheet, create Pareto Chart that shows the number by complaint types in Quarter 3. Change the Chart Title to “Complaint Status”. Place this chart to the right of data.

5.       Move the “INCOME OVERVIEW” chart on the “Summary” worksheet to its own chart sheet named “Overview”.

6.       Modify hyperlink of the image of a baby on the “BeSam” worksheet to link to cell A1 of “BeSam” worksheet.

7.       On the “Summary” worksheet, remove only legend of the “BUDGET OVERVIEW” chart. Accept all other default settings.