The MS Excel worksheet below shows the salary distributio...
The MS Excel worksheet below shows the salary distribution for four staff of a company. The net salary is paid after deductions have been made.
| S/N | A | B | C | D | E |
| 1 | IDENTIFICATION NUMBER | BASIC SALARY (N) | TOTAL ALLOWANCE (N) | TOTAL DEDUCTION (N) | NET SALARY (N) |
| 2 | LP/p/1202 | 22000 | 29000 | 7000 | 44000 |
| 3 | L/P/1250 | 26000 | 35000 | 9000 | 52000 |
| 4 | L/P/3205 | 15000 | 21000 | 6000 | 30000 |
| 5 | L/P/3215 | 33000 | 41000 | 8000 | 66000 |
Which of the following formulas would be used to obtain the value in cell E2?
B2 + C2 - D2
B2 + C2 + D2
(B2 + C2 + D2)/3
C2 - D2
Correct answer is A
No explanation has been provided for this answer.
Virus effect can be prevented by ...
The rpocess of gathering facts and statistics from different sources is known as data ...
Which of the following persons invented the punch card machine? ...
Which of the following are parts of a computer processor? ...
Dust from the system unit casing can be removed using ...
Safety measures to be observed when using the computer include all of the following except ...