Join your school's WhatsApp group
Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts

Data Processing Past Questions

Clear Selections
Change Subject Post a Question Check Syllabus Study My Bookmarks Past Questions Videos Watch Video Lessons Download App

Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts
NECO offline past questions - All questions, answers & explanations in one app 25712
Join your school's WhatsApp group
381

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)
View Answer & Discuss WAEC 2023
382

 

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?

  • A. =COUNT(E2:E5,
  • B. =COUNT(E2:E5)
  • C. =COUNTA(E2:E5)
  • D. =COUNTIF(E2:E5,
View Answer & Discuss (1) WAEC 2023
383

Figure 4 is an entity relationship diagram in MS Access. Use it to answer questions 22 and 23.
How many entity are listed in Figure 4?

  • A. 30
  • B. 25
  • C. 3
  • D. 5
View Answer & Discuss WAEC 2023
Join your school's WhatsApp group
NECO offline past questions - All questions, answers & explanations in one app 25712
Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts
384

Figure 4 is an entity relationship diagram in MS Access. Use it to answer questions 22 and 23.
What kind of relationship exists between users and products as shown in Figure 4?

  • A. One-to-many
  • B. Many-to-many
  • C. One-to-one
  • D. Many-to-one
View Answer & Discuss WAEC 2023
385

Database Administrator is a professional who

  • A. handles packet sniffing in a network
  • B. designs, implements and maintains a database
  • C. performs data entry in a database
  • D. tests and detects vulnerabilities on hardware devices and software
View Answer & Discuss WAEC 2023
Start a Free Practice Test
 
Post-UTME Past Questions - Original materials are available here - Download PDF for your school of choice + 1 year SMS alerts
Join your school's WhatsApp group