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.
One unique feature of index file is that it contains ...
Which of these devices does not support wireless communication? ...
Stages in data processing cycle includes the following except data ...
The symbols dialog box of MS Word application is located on the ...
Virus effect can be prevented by ...
Pressing the key combination Ctrl + J on a selected text in a Microsoft Word document would ...
Magnetic Ink Character Recognition (MICR) are used to read codes on ...