WAEC - Data Processing (2023)
- 15
Figure 3 is a Microsoft Excel Worksheet. Use it to answer questions 20 and 21.
A B C D E 1 IDENTICATION NUMBER BASIC SALARY (N) TOTAL ALLOWANCE (N) TOTAL DEDUCTION (N) NET SALARY (N)
2 WASC/LPT/001 800000 60000 40000 820000 3 WASC/LPT/002 700000 40000 20000 720000 4 WASC/LPT/003 300000 10000 5000 305000 5 WASC/LPT/004 400000 20000 10000 410000 Figure 3
What formula will correctly display the total number of individuals involved in the computation as shown in Figure 3?回答(C)=COUNTA(A2:A5) - 16
Figure 3 is a Microsoft Excel Worksheet. Use it to answer questions 20 and 21.
A B C D E 1 IDENTICATION NUMBER BASIC SALARY (N) TOTAL ALLOWANCE (N) TOTAL DEDUCTION (N) NET SALARY (N)
2 WASC/LPT/001 800000 60000 40000 820000 3 WASC/LPT/002 700000 40000 20000 720000 4 WASC/LPT/003 300000 10000 5000 305000 5 WASC/LPT/004 400000 20000 10000 410000 Figure 3
What formula will calculate the total number of individuals who earn less than ₦500,000 from the table as shown in Figure 3?回答(D)=COUNTIF(E2:E5,






