Gce Model Questions Vol1 2023 Computer Studies Question 49
Practice objective / multiple choice question 49 from the 2023 Gce Model Questions Vol1 Computer Studies examination.
In a spreadsheet column A the following product codes are stored: A1 = "P-2019-020", A2 = "P-2021-055", A3 = "P-2022-013". Column B contains the base prices: B1 = 100, B2 = 150, B3 = 200. Write a formula that extracts the year and the three‑digit serial number from each code, applies a discount of 10\% if the year is 2020 or earlier, a discount of 5\% if the year is 2021, and no discount otherwise; then adds a surcharge of $2 if the serial number is divisible by 5. Using that formula, calculate the total amount payable for the three products.
Answer Options
About This Question
This is Gce Model Questions Vol1 2023 Computer Studies Question 49. It is one of the objective questions from the 2023 Gce Model Questions Vol1 Computer Studies examination.
Difficulty level: Hard .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.