JAMB CBT Software 2025 - Free Download
JAMB CBT Mobile App 2025 - Free Download

Figure 3 is a Microsoft Excel Worksheet. Use it to answer questions 20 and 21....

Data Processing
WAEC 2023

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 correctly display the total number of individuals involved in the computation as shown in Figure 3?

  • A. =COUNT(A2:A5)
  • B. =COUNTIF(A2:A5)
  • C. =COUNTA(A2:A5)
  • D. =SUM(A2:A5)
JAMB CBT Mobile App 2025 - Free Download
JAMB CBT 2025 - Candidates, Schools, Centres, Resellers - Get Ready!
JAMB CBT Software 2025 - Free Download
Myschool's prices for products & services are going up again in February - Buy what you need now
Correct Answer: Option C
Explanation

The formula that will correctly display the total number of individuals involved in the computation as shown in Figure 3 is COUNTA(A2:A5).

The COUNTA function counts the number of cells that are not empty in a range. In this case, we want to count the number of cells in the A column that are not empty. The A column contains the identification numbers of the individuals involved in the computation. Therefore, the COUNTA function will return the total number of individuals involved in the computation.

The other formulas mentioned are:

COUNT: This function counts the number of cells that contain numbers in a range.
COUNTIF: This function counts the number of cells that contain a specific value in a range.
SUM: This function sums the values in a range.

In this case, we do not want to count the number of cells that contain numbers or the number of cells that contain a specific value. We want to count the number of cells that are not empty. Therefore, the COUNTA function is the most appropriate function to use.


Report an Error Ask A Question Download App
JAMB CBT 2025 - Candidates, Schools, Centres, Resellers - Get Ready!
JAMB CBT Mobile App 2025 - Free Download
JAMB CBT Software 2025 - Free Download
Myschool's prices for products & services are going up again in February - Buy what you need now

Contributions ({{ comment_count }})

Please wait...

{{ settings.no_comment_msg ? settings.no_comment_msg : 'There are no comments' }}

Quick Questions

Post your Contribution

Please don't post or ask to join a "Group" or "Whatsapp Group" as a comment. It will be deleted. To join or start a group, please click here

{{ quote.posted_by.display_name }}
{{ settings.form_textarea_description }}
 
JAMB CBT Mobile App 2025 - Free Download
JAMB CBT Software 2025 - Free Download
JAMB CBT 2025 - Candidates, Schools, Centres, Resellers - Get Ready!
JAMB CBT Mobile App 2025 - Free Download
JAMB CBT Software 2025 - Free Download
JAMB CBT 2025 - Candidates, Schools, Centres, Resellers - Get Ready!
Myschool's prices for products & services are going up again in February - Buy what you need now