Employee Expense Workbook

Start Excel and open the attached file: e$01\_$EmployeeExpense. Save the workbook as Lastname$\_$Firstname$\_$e$01\_$EmployeeExpense using your own name.

Change the theme to Droplet. Set the width of column A to $11\mathrm{.}5$ and the width of columns B:H to $14.$

Merge and center the title in cell A$1$ across columns A:H and apply the Title cell style. Merge and center the subtitle in cell A$2$ across columns A:H and apply the Heading $1$ cell style.

Center the column titles in cells B$3$:H$3$ and apply the Heading $3$ cell style.

In cell B$7,$ enter a SUM function to total the Quarter $1$ expenses. Copy the sum to the remaining quarters in cells C$7$:E$7.$

In cell F$4,$ enter a SUM function to total the Northeast expenses for the four quarters. Copy the formula down to cell F$7.$

Apply the Accounting Number format to cells B$4$:F$4$ and B$7$:F$7.$ Apply the Comma style to cells B$5$:F$6.$ Format the totals in row $7$ with the Total cell style.

Insert a new row $6$ and type Midwest in cell A$6.$ Add the following figures for each quarter in cells B$6$:E$6$:

$110975\mathrm{.}45$

$115764\mathrm{.}92$

$101549\mathrm{.}40$

$120598\mathrm{.}14$

Copy the formula from cell F$5$ to cell F$6.$

In cell G$4,$ create a formula to calculate the $\%$ of Total Expenses for the first region using an absolute cell reference as needed. Copy the formula to cells G$5$:G$7.$ Apply Percent Style with two decimal places to cells G$4$:G$7$ and center the percentages.

In the range H$4$:H$7,$ insert Line sparklines. Do not include the totals. Show the Sparkline markers. Apply the Blue Sparkline Style Dark#$5.$

Insert a Clustered Column chart that represents the expense figures for the four quarters. Display the regions on the horizontal axis and the quarters in the legend.

Apply Chart Style $8$ and change the colors to Colorful Palette $2.$ Position the chart so that the upper left corner of the chart aligns with cell D$10.$ Change the chart title to $2021$ Regional Expenses

Change the page orientation to Landscape. Center the worksheet horizontally on the page. Insert a footer with the file name in the left section.

For the Tags, type employee, expense For the Subject, type your course name and section number. Be sure your name displays as the author.

Spellcheck and proof your document before saving.

Display the formulas in the worksheet making sure all are visible.

Save the workbook and exit Excel. Submit your file via this assignment on Blackboard.