WAEC Data Processing 2016 Question 21

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.
Which of the following formulas would be used to obtain the value in cell E2?

1. A.= B2 + C2 - D2
2. B.= B2 + C2 + D2
3. C.= (B2 + C2 + D2)/3
4. D.= C2 - D2