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.
Which of the following objects is not located on the slide layout? ...
Computer virus replicates itself into ...
Virus effect can be prevented by ...
By default numeric values in a worksheet are ...
The use of the internet to perform illegal activities is generally called ...
In relational model, a tuple is a ...
Shared-memory is an architecture in ...
The device that sends information to the CPU is the ...
Companies that provide internet access are referred to as ...
What kind of relationship exists between users and products as shown in Figure 4? ...