Question

COMPUTER STUDIES PRACTICAL (Paper III)
Instructions: (i) Use computer system to answer the question. (ii) Use Microsoft Excel to perform the task. (iii) No content of the candidates' work should be the same. (iv) You are required to print out the hard copy(ies) of your work.
Reproduce the spreadsheet document of a cost schedule as shown below and perform the underlying tasks.

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.

Accepted Answer

Type the table into Microsoft Excel with columns A to E (MONTHS, INCOME, EXPENDITURE, PROFIT, LOSS) and rows 2 to 14 (January to December, then TOTAL). Sample values within the allowed ranges:

Month: Income / Expenditure / Profit / Loss
June: 6000 / 3000 / 3000 / -
July: 8000 / 4000 / 4000 / -
August: 9000 / 5000 / 4000 / -
September: 4000 / 5000 / - / 1000
October: 7000 / 3000 / 4000 / -
November: 5000 / 2000 / 3000 / -
December: 3000 / 4000 / - / 1000
(September and December each give a loss of ₦1,000, the same as April.)

(iii) Profit in D7: =IF(B7>C7,B7-C7,"-")   Loss in E7: =IF(C7>B7,C7-B7,"-")   Copy both down to row 13.

(iv) (a) Total income: =SUM(B2:B13) gives 27,000 + 42,000 = 69,000.
(b) Total expenditure: =SUM(C2:C13) gives 21,500 + 26,000 = 47,500.
(c) Sum of profits from May to August: =SUM(D6:D9) gives 2,000 + 3,000 + 4,000 + 4,000 = 13,000.

Save the work and print the hard copy.

BECE Basic Science 2023 Theory — Question 1

Sign up free to unlock