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

Download The App On Google Playstore

Everything you need to excel in your exams

Green Bridge CBT Mobile App
Personalized AI Learning Chat Assistant
200,000+ Past Papers Across IGCSE, JAMB, WAEC & NECO
Over 3000 Lesson Notes
Offline Support - Learn Anytime, Anywhere
Green Bridge Timetable
Literature Summaries & Potential Questions
Track Your Performance & Progress
In-depth Explanations for Comprehensive Learning