Neco 2019 Computer Studies Question 48
Practice objective / multiple choice question 48 from the 2019 Neco Computer Studies examination.
In a spreadsheet, cells A1:A3 contain base salaries of 50000, 60000 and 70000 respectively. Cell E1 holds the tax rate 0.05 (5%). The following formulas are entered: - B1: `=A1*0.10` (allowance 10 % of base) - C1: `=(A1+B1)*$E$1` (tax on base + allowance) - D1: `=A1+B1-C1` (net salary) The formulas in B1, C1 and D1 are then copied down to rows 2 and 3 using the fill handle. What net salary is displayed in cell D3?
Answer Options
About This Question
This is Neco 2019 Computer Studies Question 48. It is one of the objective questions from the 2019 Neco 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.