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.
New messages received are save in the part labelled ...
A file kept in case of an accident or natural disaster is called ...
Which of the following command would undo the last operation carried out in Microsoft Word? ...
Responsibilities of a database administrator includes the following except performing ...
Which of the following terms is not a feature of distributed database? ...
To access a website, the URL of the website is typed into the part labelled ...
The following precautionary measures are taken against virus infection except ...
The student ID in Tables II is referred to as ...