M$5$ Assignment: Sorting, Formatting, Formulas and Charts $($Graded$)$

Listen

Hide Folder Information

Instructions

Assignment Title: Sorting, Formatting, Formulas and Charts

Weight: $10\%$ of the final grade. The total points are $30$ marks.

Type: Individual

Instructions:

Open the workbook Assignment $-$ Sorting Formulas and Charts.xlsx$.($You can also click the Download All File button below to download this file.$)$

Sort column A alphabetically. After sorting, the list should start with Apple Sauce and end with Steak.

In Cells B$9$:H$9,$ create formulas to sum up the figures in rows $2$ to $8.$

Below the label TOTAL, in cell A$10,$ add a new label $$AVERAGE$.$

In Cells B$10$:H$10,$ create formulas to average the figures in rows $2$ to $8.$

Format the numbers in cells B$10$:H$10$ to be a $$Number$$ and have $2$ decimal places $($i$.$e$.10\mathrm{.}12).$

Apply borders format to cells A$10$:H$10.$

Create a column chart for your worksheet.

Select cells A$1$ to H$8($the row headings $-$ names of products, and column headings $-$ names of days, are included in the selection, while the cells containing the TOTAL and AVERAGE are not included as this can skew the resulting chart$).$

Click the Insert tab, and create a two$-$dimensional clustered column chart.

Change the title of the chart to "Quantities Sold Per Day."

Submission Guidelines:

Save the workbook $($complete with the chart$)$ with the name Module $5$ Assignment $-$ YOUR NAME.

Complete this assignment in an Excel spreadsheet and then upload it to this Dropbox folder.

Your assignment will be graded using this grading rubric.

Due on Jan $19,202412$:$59$ AM