Gce Model Questions Vol1 2018 Computer Studies Question 11
Practice objective / multiple choice question 11 from the 2018 Gce Model Questions Vol1 Computer Studies examination.
A spreadsheet is set up to calculate an employee's pay. Column A contains Hours Worked (regular hours), column B contains the Hourly Rate, column C contains Overtime Hours, column D contains Overtime Rate calculated as (1.5\times B\), column E contains Regular Pay = (A\times B\), column F contains Overtime Pay = (C\times D\), and column G contains Gross Pay = (E+F\). Overtime Pay is only added if the Gross Pay before tax exceeds £700. A tax of 10 % is deducted from the Gross Pay to give the Net Pay shown in cell H2. An employee works 40 regular hours and 5 overtime hours. The Net Pay recorded in H2 is £641.25. Determine the hourly rate applied (in pounds) and state whether overtime pay was included.
Answer Options
About This Question
This is Gce Model Questions Vol1 2018 Computer Studies Question 11. It is one of the objective questions from the 2018 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.