The table below shows products, and figures representing each day; follow the statement below to resolve it.

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

3. In Cells B9:H9, create formulas to sum up the figures in rows 2 to 8.

4. Below the label TOTAL, in cell A10, add a new label 'AVERAGE'.

5. In Cells B10:H10, create formulas to average the figures in rows 2 to 8.

6. Format the numbers in cells B10:H10 to be a 'Number' and have 2 decimal places (i.e. 10.12).

7. Apply borders format to cells A10:H10.

8. Create a column chart for your worksheet.

    a.Select cells A1 to H8 (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).

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

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

9. Complete in Excel spreadsheet

 

Products	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
Pasta	54	45	65	71	44	38	89
Apple sauce	45	54	68	77	39	48	77
Green beans	62	66	68	60	81	55	62
Steak	57	44	75	74	32	48	50
Bread	65	80	85	90	85	77	84
Milk	70	67	77	65	63	62	90
Cookies	45	40	35	33	38	51	40
Total