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 DE...

Assessment: WAEC SSCE - Data Processing - 2023 (Objective) Subject: Data Processing

Question 1 Report

 

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?

View Answer

Related Questions

1

The Difference Engine and the Analytical Engine were invented by
2

A type of file organization that stores data in the order of their arrival is called
3

The volume of data that can be sent from one point to another in a given time period is called
4

Advantages of parallel database include the following except
5

The ruler feature in MS Word that is used to indent the second and subsequent lines of a paragraph is
6

Which of the following computer types represents data as variable and continuous values?
7

The following feature are found in the toolbox of CorelDraw application except
8

One application of ICT in medicine is

Download The App On Google Playstore

Everything you need to excel in JAMB, WAEC & NECO

Green Bridge CBT Mobile App
Personalized AI Learning Chat Assistant
Thousands of JAMB, WAEC & NECO Past Questions
Over 1200 Lesson Notes
Offline Support - Learn Anytime, Anywhere
Green Bridge Timetable
Literature Summaries & Potential Questions
Track Your Performance & Progress
In-depth Explanations for Comprehensive Learning