MS-EXCEL

SOME.EXAMPLES

1.FIND OUT HOW MANY PEOPLE ARE BORN IN THE MONTH OF JAN,FEB,….DEC.BASED ON THE DATA PROVIDED?

2.FIND THE AGE OF ABC TILL DATE USING DATEDIF ?

3.1.WHICH PERSON MADE SALES OF 2081 USING INDEX FORMULA ?

3.2.WHO MADE MAXIMUM SALES USING INDEX FORMULA?

3.3.WHO SOLD TO MINIMUM NUMBER OF CUSTOMERS USING INDEX?

4.EXTRACT FIRST INITIAL OF FIRST NAME AND FIRST INITIAL OF LAST NAME SEPARATED BY A SPACE?

5.CALCULATE THE TOTAL AMOUNT BASED ON SALES AMT AND QUNATITY?

6.Sort the Data based on Month order?

7.Total "A" in colored Range ?

8.EXPENSIVE PRODUCT ?

9.Create a pivot based upon the below data?

DOWNLOAD PIVOT TABLE FILE

ms-excel-solution

10.NEED TO IDENTIFY HOW MANY STUDENT PRESENT AND ABSENT USING FORMULA ?

11.USE VLOOKUP AND LEN FUNCTION TO EXTRACT FULL FORM BASED ON NAME?

12.FIND OUT 2ND MAX NUM OF A?

13.FIND INVALID MOBILE NUMBER?

14.FIND THE MAXIMUM SALE OF EACH SALESMAN?

15. DYNAMIC HEAT MAP USING SCROLL BAR ?

16. SOLVE IT AND GIVE 2 SOLUTIONS ?