TEST OF PRACTICAL KNOWLEDGE QUESTION
Use a spreadsheet application to do the following. (a) In cell A1, type "My One Week Expenses On Five items".
(b) In row 2, type column-by-column the following: "ITEM", 1ST DAY, "2ND DAY, "3RD DAY", *4TH DAY, "5THDAY", "6TH DAY" and "7TH DAY".
(c) In column A, starting from A3 to A7, List the items you spent money on.
(d) Enter the amount spent on each item for each day in their respective columns.
Note: select your own items and the amount spent.
(e) In cells 12 and A8. type "TOTAL N".
(f) Using formula/function compute the total expenses for each day and for each item.
(g) Create borders around the table.
(h) Insert a footer and type in your full name and index number. (i) Below the table, type in the formula that was used:
(i) in cell 18: (ii) for summing from B3 to H3.
Note: Enclose your formula in quotes ave your work with your full name in the folder created on the desktop.
(k) Print your work and submit to the supervisor.
Test of Practical Knowledge: one-week expenses spreadsheet
The steps below use Microsoft Excel; any spreadsheet package follows the same idea. A sample table is shown so the layout and formulas are clear.
1. Title and headings
- In cell A1 type: My One Week Expenses On Five Items.
- In row 2 type the headings across the columns: A2 = ITEM, B2 = 1ST DAY, C2 = 2ND DAY, D2 = 3RD DAY, E2 = 4TH DAY, F2 = 5TH DAY, G2 = 6TH DAY, H2 = 7TH DAY, I2 = TOTAL N.
2. Items and amounts
- In column A, from A3 to A7, list five items (choose your own). Enter the amount spent on each item for each day in the day columns. A worked example:
| ITEM | 1ST | 2ND | 3RD | 4TH | 5TH | 6TH | 7TH | TOTAL N |
|---|
| Food | 500 | 450 | 600 | 500 | 550 | 700 | 650 | 3950 |
| Transport | 200 | 200 | 250 | 200 | 300 | 150 | 100 | 1400 |
| Airtime | 100 | 0 | 200 | 0 | 150 | 0 | 100 | 550 |
| Water | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 350 |
| Snacks | 150 | 100 | 120 | 200 | 180 | 250 | 200 | 1200 |
| TOTAL N | 1000 | 800 | 1220 | 950 | 1230 | 1150 | 1100 | 7450 |
3. Totals using formulas/functions
- Total for each item (row) in column I, e.g. in I3 type
=SUM(B3:H3) and copy down to I7. - Total for each day (column), in row 8, e.g. in B8 type
=SUM(B3:B7) and copy across to H8. - Grand total in I8:
=SUM(B3:H7) or =SUM(I3:I7).
4. Borders, footer, formula display
- Select the table and apply All Borders (Home → Borders).
- Insert → Header & Footer → type your full name and index number in the footer.
- Below the table, type the formulas used, enclosed in quotes, e.g. the formula in I8 = "=SUM(B3:H7)" and the formula summing B3 to H3 = "=SUM(B3:H3)".
5. Save, print, submit
- Save the file with your full name in the folder created on the desktop, then print and submit to the supervisor.
Test of Practical Knowledge: one-week expenses spreadsheet
The steps below use Microsoft Excel; any spreadsheet package follows the same idea. A sample table is shown so the layout and formulas are clear.
1. Title and headings
- In cell A1 type: My One Week Expenses On Five Items.
- In row 2 type the headings across the columns: A2 = ITEM, B2 = 1ST DAY, C2 = 2ND DAY, D2 = 3RD DAY, E2 = 4TH DAY, F2 = 5TH DAY, G2 = 6TH DAY, H2 = 7TH DAY, I2 = TOTAL N.
2. Items and amounts
- In column A, from A3 to A7, list five items (choose your own). Enter the amount spent on each item for each day in the day columns. A worked example:
| ITEM | 1ST | 2ND | 3RD | 4TH | 5TH | 6TH | 7TH | TOTAL N |
|---|
| Food | 500 | 450 | 600 | 500 | 550 | 700 | 650 | 3950 |
| Transport | 200 | 200 | 250 | 200 | 300 | 150 | 100 | 1400 |
| Airtime | 100 | 0 | 200 | 0 | 150 | 0 | 100 | 550 |
| Water | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 350 |
| Snacks | 150 | 100 | 120 | 200 | 180 | 250 | 200 | 1200 |
| TOTAL N | 1000 | 800 | 1220 | 950 | 1230 | 1150 | 1100 | 7450 |
3. Totals using formulas/functions
- Total for each item (row) in column I, e.g. in I3 type
=SUM(B3:H3) and copy down to I7. - Total for each day (column), in row 8, e.g. in B8 type
=SUM(B3:B7) and copy across to H8. - Grand total in I8:
=SUM(B3:H7) or =SUM(I3:I7).
4. Borders, footer, formula display
- Select the table and apply All Borders (Home → Borders).
- Insert → Header & Footer → type your full name and index number in the footer.
- Below the table, type the formulas used, enclosed in quotes, e.g. the formula in I8 = "=SUM(B3:H7)" and the formula summing B3 to H3 = "=SUM(B3:H3)".
5. Save, print, submit
- Save the file with your full name in the folder created on the desktop, then print and submit to the supervisor.
