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.
In spreadsheets, data would not be accepted into a cell by pressing the ...
When information is conveyed from one space to another, it is referred to as information ...
Use Table 1 to answer the following question. Table 1: TableStudent &nbs...
Which of the following file organizations requires primary Key? ...
Which of these operations would not improve the performance of a parallel database system? ...
The student ID in Tables II is referred to as ...
Providing access control to a school is the responsibility of a ...
New messages received are save in the part labelled ...
A suitable application software for creating Tables 1 and 2 is ...