2023 – Practical | BECE Computer Studies

Reproduce the spreadsheet document of a cost schedule as shown below and perform the underlying task

APPLICATION:

(i) Provide the income values of your choice for the months of June to December ranging between ₦3,000 to ₦10,000.

(ii) Provide the expenditure values of your choice for the months of June to December ranging from ₦2,000 to ₦5,000.

Note: The months of September and December should result in a loss similar to the month of April.

(iii) Compute and key in the profit or loss for the months of  June to December.

Note: (a) Profit = Income – Expenditure, (b) Loss = Expenditure – Income

(iv) Give the formula and corresponding results of the following:

(a) The total income
(b) The total expenditure
(c) The sum of profits from the months of May to August.