WAECData ProcessingDatabase Management2023

WAEC Data Processing Practice Question

medium

Question:

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?