Neco 2020 Data Processing Question 2
Practice objective / multiple choice question 2 from the 2020 Neco Data Processing examination.
In a spreadsheet, column A contains employee IDs, column B the number of hours worked, and column C the hourly rate (₦ per hour). Column D should calculate the gross pay for each employee, adding a 10\% bonus to the gross pay if the employee ID starts with the letter "M". Write a formula that can be entered in D2 and copied down to achieve this, and then compute the total gross pay for the four employees listed below.\n\nA2: M101, B2: 40, C2: 15\nA3: A202, B3: 35, C3: 14\nA4: M103, B4: 45, C4: 16\nA5: B304, B5: 30, C5: 13
Answer Options
About This Question
This is Neco 2020 Data Processing Question 2. It is one of the objective questions from the 2020 Neco Data Processing 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.