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.
The type of file organisation in a DVD-ROM is ...
Which of the following terms is not a feature of distributed database? ...
The proactive maintenance of computer equipment before a fault or failure occurs is called ...
Which of the following is a computer professional? ...
In relational model, a tuple is a ...
Figure 3 is a Microsoft Excel Worksheet. Use it to answer questions 20 and 21. ...
A pointing device that controls cursor movement on the screen is ...
When choosing a file organization method a system administrator will not consider ...
Indiscriminate sending of unsolicited e-mails to many addresses is known as ...