Assignment 4 - Let’s solve Assignment 4 from 50 ms excel assignments

Описание: Assignment 4 - Let’s solve Assignment 4 from 50 ms excel assignments
Use of Formulas - Sum, NestedIf, Counta, Countif, Sumif, Vlookup

00:00 - Into
00:05 - Let us find the DA, HRA, PF and Total before solving the questions
01:14 - Q.1 HOW MANY EMPLOYEE IN COMPUTER, FINANCE AND ELECTRICAL DEPT.
02:38 - Q.2 HOW MANY BASIC SALARY IN COMPUTER DEPARTMENT ONLY
03:10 - Q.4 IF TOTAL SALALRY IS GREATER THEN 20000 THEN "A", IF TOTAL SALARY GREATER THEN 10000 THEN "B", OTHERWISE "C"
04:00 - Q.3 MANOJ, ASHISH POST & GRADE
05:43 - Q.5 HOW MANY EMPLOYEES IS MANAGER AND GUARD
06:45 - Subscribe for more