Figure 3 is a Microsoft Excel Worksheet....
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?
COUNT(E2:E5
COUNT(E2:E5)
COUNTA(E2:E5)
COUNTIF(E2:E5
Correct answer is D
The formula that will calculate the total number of individuals who earn less than ₦500,000 from the table as shown in Figure 3 is COUNTIF(E2:E5, "< 500,000").
The COUNTIF function counts the number of cells that contain a specific value in a range. In this case, we want to count the number of cells in the E column that contain a value less than ₦500,000. The E column contains the net salaries of the individuals. Therefore, the COUNTIF function will return the total number of individuals who earn less than ₦500,000.
A Word document can have any of these file extension except ...
Which of these measures would not secure data in database? ...
Preventive maintenance measures in computer room do not include ...
One of the characteristic feature of the second generation computer is the presence of ...
Which of the following is not an anti-virus? ...
What kind of relationship exists between users and products as shown in Figure 4? ...
In computer maintenance the dampen material can be used on the following devices except ...