Join your school's WhatsApp group
Download WAEC Nov/Dec App - Get all past questions and answers, 100% offline - 129393

Data Processing 2023 WAEC 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
Download WAEC Nov/Dec App - Get all past questions and answers, 100% offline - 129393
Join your school's WhatsApp group
16

 

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
17

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
18

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
Download WAEC Nov/Dec App - Get all past questions and answers, 100% offline - 129393
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
19

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
20

The aim of administering questionaire is to collect

  • A. data
  • B. information
  • C. specimen
  • D. statistics
View Answer & Discuss WAEC 2023
Start a Free Practice Test
 
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
Download WAEC Nov/Dec App - Get all past questions and answers, 100% offline - 129393