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 program designed to detect and prevent malicious programs from a computer system is ...
Which of the following objects is not located on the slide layout? ...
One advantage of the first generation computers is ...
Which of the following is not an ancient medium for transmitting information? ...
Computer malware is detected by ...
Which of the following persons invented the punch card machine? ...
In spreadsheets, data would not be accepted into a cell by pressing the ...
The erratic movement of the mouse pointer is usually caused by ...
The part labelled I in this figure is used in Microsoft Word to ...