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.
To complete the task outlined in the question, you can follow these steps:
- Open a spreadsheet application such as Microsoft Excel or Google Sheets.
- In cell A1, type the text "My One Week Expenses On Five items".
- In row 2, type the following column headings: "ITEM", "1ST DAY", "2ND DAY", "3RD DAY", "4TH DAY", "5TH DAY", "6TH DAY", "7TH DAY".
- In column A, starting from A3 to A7, list the items you spent money on.
- Enter the amount spent on each item for each day in their respective columns.
- In cells A12 and A8, type "TOTAL".
- In the cells below the "TOTAL" row, use the SUM formula to calculate the total expenses for each day and for each item. For example, to calculate the total expenses for the first day, you could use the formula "=SUM(B3:B7)".
- Select the entire table and add borders to it.
- Insert a footer and type in your full name and index number.
- Below the table, in cell A18, type the formula that was used to calculate the total expenses for each day. For example, if the formula used was "=SUM(B3:H3)", type "=SUM(B3:H3)" in cell A18.
- Save your work with your full name as the file name in a folder on the desktop.
- Print your work and submit it to the supervisor.
This will give you a complete table of your expenses for one week on five items, along with the total expenses for each day and for each item.
To complete the task outlined in the question, you can follow these steps:
- Open a spreadsheet application such as Microsoft Excel or Google Sheets.
- In cell A1, type the text "My One Week Expenses On Five items".
- In row 2, type the following column headings: "ITEM", "1ST DAY", "2ND DAY", "3RD DAY", "4TH DAY", "5TH DAY", "6TH DAY", "7TH DAY".
- In column A, starting from A3 to A7, list the items you spent money on.
- Enter the amount spent on each item for each day in their respective columns.
- In cells A12 and A8, type "TOTAL".
- In the cells below the "TOTAL" row, use the SUM formula to calculate the total expenses for each day and for each item. For example, to calculate the total expenses for the first day, you could use the formula "=SUM(B3:B7)".
- Select the entire table and add borders to it.
- Insert a footer and type in your full name and index number.
- Below the table, in cell A18, type the formula that was used to calculate the total expenses for each day. For example, if the formula used was "=SUM(B3:H3)", type "=SUM(B3:H3)" in cell A18.
- Save your work with your full name as the file name in a folder on the desktop.
- Print your work and submit it to the supervisor.
This will give you a complete table of your expenses for one week on five items, along with the total expenses for each day and for each item.