Question

Experts plz answer exercise 4 by filling this table of ms excel

Answer 1

A                   B                 C                   D                    E                      F

  Name   Basic   Allowances  GrossSal.   Deductions    Netsalary

4 Lewis  30000   = 23% * B4   = B4 + C4    = 12% * D4    = D4 - E4

5 Francis 45000 = 23% * B5   = B5 + C5   = 12% * D5    = D5 - E5

6 Edwin  30000  = 23% * B6  = B6 + C6   = 12% * D6    = D6 - E6

Hope it helps!