cameroon gce intermediate level 2026 industrial computing 3
cameroon gce intermediate level 2026 industrial computing 3
Question 1: Spreadsheet
| 1. | a) | Open the Candidate folder provided and open the spreadsheet Sales.xlsx | (1 mark) |
| b) | On the Invoice Worksheet use a Date Function in Cell B3 that will return the current date. | (2 marks) | |
| c) | Write out the Function as used in B3 Above | (2 marks) | |
| 2. | a) | In cell F6 use a Formula to calculate the Amount of the first product based on Quantity and Unit Price. | (2 marks) |
| b) | Copy apply the formula to get the results of the remaining products from Cell F7 to F25. | (1 mark) | |
| c) | Write down the formula in Cell B10. | (2 marks) | |
| 3. | a) | In cell I6, use the IF Function or related function to return YES if the Amount in Cell F6 is greater than the Targeted Amount in cell G6; and NO if the value is less. | (4 marks) |
| b) | Copy apply the formula to the remaining cells I7 to I25 | (1 mark) | |
| c) | Write the function used in Cell I6 above. | (2 marks) | |
| 4. | a) | In cell F28 use a suitable function that will return the number of paid invoices as indicated in the cell range G6 to G25. | (3 marks) |
| b) | Write down the Function or formula used in F28 above. | (2 marks) | |
| 5. | a) | In cell F30 use a suitable function that will return the number of invoices whose amounts are above 1,000,000 in the cell range F6 to F25 | (2 marks) |
| b) | Write down the Function or formula used in F30 above. | (2 marks) | |
| c) | Sort the data table in Ascending Order of Product Name. | (2 marks) | |
| 6. | Print a copy of the Worksheet and submit | (2 marks) | |
(Total = 30 marks)
Question 2: Database
| 1. | a) | Open the Candidate folder provided and open the database file Hilltop Construction.accdb | (1 mark) | ||||||||||||||||||||||||||||||||||||||||||||||||
| b) | Open the Workers database and Identify which field is most suitable as the Primary Key. Switch to design mode and assign the Primary key you have identified. |
(3 marks) | |||||||||||||||||||||||||||||||||||||||||||||||||
| c) | Write the name of the Primary Key field identified above. | (1 mark) | |||||||||||||||||||||||||||||||||||||||||||||||||
| d) | Indicate how many Fields and Records that are found on the Workers Database.
|
(2 marks) | |||||||||||||||||||||||||||||||||||||||||||||||||
| e) | Use suitable filtering options to extract workers who work either in the Civil Engineering or Carpentry departments. Sort the extracted Records in ascending order. Print a copy (Landscape) of the extracted records. |
(4 marks) | |||||||||||||||||||||||||||||||||||||||||||||||||
| f) | Add the following Records to the Workers database.
Workers
|
(3 marks) | |||||||||||||||||||||||||||||||||||||||||||||||||
| 2. | a) | Create a Query using the Workers Table or Database. Add the following fields only to your Query | (4 marks) |
