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 for mulas would be used to obtain the value in cell E2?

Question

Africa Exams · Accepted Answer

Correct Answer is : = B2 + C2 - D2

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

WAEC Data Processing 2016 Paper