Question 2

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”, “5TH DAY”, “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 (“ ʼʼ).

(j)Save your work with your full name in the folder created on the desktop.

(k)Print your work and submit to the supervisor.