Perform the following tasks:

Open Excel and create a new workbook. Create a worksheet $($should be the first worksheet of the workbook$)$ with your name in cell A$1,$ date in cell A$2,$ course in cell A$3,$ instructor name in cell A$4,$ and assignment name in cell A$5.$ Name this worksheet "Module $1$ Lab Assignment Info".

Create a worksheet. Name the worksheet "First Quarter Revenue Data", and change the worksheet tab color to a shade of green. Enter the worksheet title, Rebecca's Shoe Warehouse, in cell A$1$ and the worksheet subtitle, First Quarter Revenue Analysis, in cell A$2.$ Beginning in row $4,$ enter the region data shown below:

North South East West

Saucony $72714\mathrm{.}5877627\mathrm{.}2976607\mathrm{.}3149008\mathrm{.}32$

Under Armour $45052\mathrm{.}2369165\mathrm{.}6676243\mathrm{.}4184844\mathrm{.}01$

Vans $77630\mathrm{.}9478684\mathrm{.}2456601\mathrm{.}2572716\mathrm{.}68$

Brooks $65423\mathrm{.}7377690\mathrm{.}6958383\mathrm{.}6754433\mathrm{.}07$

Sketchers $55666\mathrm{.}9278618\mathrm{.}9747317\mathrm{.}0968594\mathrm{.}40$

Create totals for each region and product. Also, create a company grand total. HINT: You will have both column TOTALS and row TOTALS.

Format the worksheet title with the Title cell style. Center and merge the title across columns A through F$.$

Format the worksheet subtitle to $16-$point Calibri Light. Center and merge the subtitle across columns A through F$.$

Use Cell Styles to format the range A$4$:F$4$ with the Heading $3$ cell style, the range B$4$:F$4$ with the Accent $1$ cell style, and the range A$10$:F$10$ with the Total cell style.

Center the column titles in row $4.$ Apply the accounting number format to the ranges B$5$:F$5$ and B$10$:F$10.$ Apply the comma style format to the range B$6$:F$9.$ Adjust any column widths to the widest text entry in each column.

Select the ranges B$4$:E$4$ and B$10$:E$10$ and then insert a $3-$D pie chart. Apply the Style $3$ chart style to the chart. Move the chart to a new worksheet named "Revenue Analysis Chart". Change the chart title to First Quarter Revenue Analysis.

Change the "First Quarter Revenue Data" worksheet orientation to landscape orientation.

Reorder the worksheets: $(1)$ Module $1$ Lab Assignment Info, $(2)$ First Quarter Revenue Data, $(3)$ Revenue Analysis Chart.

Update the author $($use your name$)$ and title $($use 'Student'$)$ in the document properties.