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:

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.

$\backslash$begin$\{$tabular$\}\{|$l$|$l$|$l$|$l$|$l$|\}$

$\backslash$hline & North & South & East & West $\backslash \backslash$

$\backslash$hline Saucony & $72714\mathrm{.}58$ & $77627\mathrm{.}29$ & $76607\mathrm{.}31$ & $49008\mathrm{.}32\backslash \backslash$

$\backslash$hline Under Armour & $45052\mathrm{.}23$ & $69165\mathrm{.}66$ & $76243\mathrm{.}41$ & $84844\mathrm{.}01\backslash \backslash$

$\backslash$hline Vans & $77630\mathrm{.}94$ & $78684\mathrm{.}24$ & $56601\mathrm{.}25$ & $72716\mathrm{.}68\backslash \backslash$

$\backslash$hline Brooks & $65423\mathrm{.}73$ & $77690\mathrm{.}69$ & $58383\mathrm{.}67$ & $54433\mathrm{.}07\backslash \backslash$

$\backslash$hline Sketchers & $55666\mathrm{.}92$ & $78618\mathrm{.}97$ & $47317\mathrm{.}09$ & $68594\mathrm{.}40\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$