On the Documentation worksheet, enter your full name. Enter

mark$)$

Create a new worksheet named Dashboard. Place it to the right of Documentation. In cell $B_2,$ type

Summary and apply the Title cell style. In cell B$3,$ type Number of Sales, in B$4$ type Total Sales, in B$5$

type Average Sales, in cell B$6$ type Minimum Sales and in B$7$ type Maximum Sales. Apply Heading $4$ to

these cells. $(3)$

Next, copy the Orders worksheet $5$ times. Make sure they are to the right of the Dashboard worksheet,

On the Orders$(2)$ worksheet, split into four panes at the intersection of row $20$ & column D$.$ Rename

the worksheet to Split Panes. $(2)$

On the Orders$(3)$ worksheet, Freeze panes so that the second column and header row of the table stay

visible while scrolling. Rename this worksheet Freeze Panes. $(2)$

On the Orders$(4)$ worksheet, in the Street column $(H),$ use conditional formatting to find the duplicate

records in the database. Use Green fill with Dark green text. Correct the record located in $H48$ to $7$ Flint

St$.$ Leave the other duplicates unchanged. Rename the worksheet to Duplicate Records. $(3)$

On the Orders$(5)$ worksheet, Sort the proper field so you can create a subtotal report. For each change

in Category create a Subtotal to find the Sum for the Sales. At each change in Category Subtotal the

Average Sales and be careful not to replace the current total sales subtotals. Rename the worksheet to

Subtotals. $(4)$