Gce Model Questions Vol1 2024 Computer Studies Question 10

Practice objective / multiple choice question 10 from the 2024 Gce Model Questions Vol1 Computer Studies examination.

Gce Model Questions Vol1 2024 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 10 GCE_MODEL_QUESTIONS_VOL1 • 2024 • COMPUTER_STUDIES • objective

In a spreadsheet the months January to June are listed in cells B3:B8. The expense categories Rent, Food, Transport and Entertainment are in columns C to F, with the monthly amounts entered in the range C3:F8. (a) Write a formula to calculate the total annual expense for all categories. (b) Write a formula to calculate the average monthly expense for each category. (c) Assuming column G contains the total expense for each month (e.g., G3 = SUM(C3:F3)), write a formula that returns the month name (from column B) with the highest total expense. (d) Provide the conditional‑formatting formula that highlights any individual expense cell in C3:F8 that exceeds 20 % of that month's total expense.

Answer Options

A. a) =SUM(C3:F9) b) Rent: =AVERAGE(C3:C7); Food: =AVERAGE(D3:D7); Transport: =AVERAGE(E3:E7); Entertainment: =AVERAGE(F3:F7) c) =INDEX(B3:B8, MATCH(MAX(G3:G8), G3:G8, 1)) d) Conditional‑formatting formula: =C3>0.2*SUM($C$3:$F$8)
Correct Answer B. a) =SUM(C3:F8) b) Rent: =AVERAGE(C3:C8); Food: =AVERAGE(D3:D8); Transport: =AVERAGE(E3:E8); Entertainment: =AVERAGE(F3:F8) c) =INDEX(B3:B8, MATCH(MAX(G3:G8), G3:G8, 0)) d) Conditional‑formatting formula: =C3>0.2*SUM($C3:$F3)
C. a) =SUM(C3:F8)*12 b) Rent: =AVERAGE(C3:C8); Food: =AVERAGE(D3:D8); Transport: =AVERAGE(E3:E8); Entertainment: =MEDIAN(F3:F8) c) =INDEX(B3:B8, MATCH(LARGE(G3:G8,2), G3:G8, 0)) d) Conditional‑formatting formula: =C3>0.15*SUM($C3:$F3)
D. a) =SUM(C3:E8) b) Rent: =AVERAGE(C3:C8); Food: =AVERAGE(D3:D8); Transport: =AVERAGE(F3:F8); Entertainment: =AVERAGE(E3:E8) c) =INDEX(B3:B8, MATCH(MIN(G3:G8), G3:G8, 0)) d) Conditional‑formatting formula: =C3>0.25*SUM($C3:$F3)
Correct Answer
B
Correct Option:
a) =SUM(C3:F8) b) Rent: =AVERAGE(C3:C8); Food: =AVERAGE(D3:D8); Transport: =AVERAGE(E3:E8); Entertainment: =AVERAGE(F3:F8) c) =INDEX(B3:B8, MATCH(MAX(G3:G8), G3:G8, 0)) d) Conditional‑formatting formula: =C3>0.2*SUM($C3:$F3)

About This Question

This is Gce Model Questions Vol1 2024 Computer Studies Question 10. It is one of the objective questions from the 2024 Gce Model Questions Vol1 Computer Studies examination.

Difficulty level: Hard .

View More Gce Model Questions Vol1 2024 Computer Studies Questions More Gce Model Questions Vol1 Practice Questions Back to Questions

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Chat with Support