Welcome to Schoolngr.com

Home   School   News   C B T   Classroom
Thursday, 07 November 2024

RegisterLogin

The MS Excel worksheet below shows the salary distribution for four staff of a ...

The MS Excel worksheet below shows the salary distribution for four staff of a company. The net salary is paid after deductions have been made.
S/N A B C D E
1 IDENTIFICATION NUMBER BASIC SALARY (N) TOTAL ALLOWANCE (N) TOTAL DEDUCTION (N) NET SALARY (N)
2 LP/p/1202 22000 29000 7000 44000
3 L/P/1250 26000 35000 9000 52000
4 L/P/3205 15000 21000 6000 30000
5 L/P/3215 33000 41000 8000 66000



Which of the following for mulas would be used to obtain the value in cell E2?

A. = B2 + C2 - D2
B. = B2 + C2 + D2
C. = (B2 + C2 + D2)/3
D. = C2 - D2




STAY UPDATED
FOLLOW US ON :


AboutContact usBack to Top
...

Disclaimer
All Views, Names, Acronyms, Trademarks, Expressed on this website are those of their respective owners. Please note that www.schoolngr.com is not affiliated with any of the institutions featured in this website. It is always recommended to visit an institutions or sources official website for more information. In the same vein, all comments placed here do not represent the opinion of schoolngr.com


SCHOOLNGR - © 2020 - 2024 - Tayo Hammed | Terms Of Service | Copyright | Privacy Policy