The table below shows products, and figures representing each day; follow the statement below to resolve it.
Question:
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 | |||||||
Financial Institutions Management A Risk Management Approach
ISBN: 978-0071051590
8th edition
Authors: Marcia Cornett, Patricia McGraw, Anthony Saunders