0% found this document useful (0 votes)
5 views19 pages

Execel Lesson 2

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
5 views19 pages

Execel Lesson 2

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Orange

Mango Apple Watermelon Apple


Watermelon Grapes Pear Grapes
Grapes Kiwi Papaya Kiwi
Pear Mango Orange Mango
Papaya Orange Mango Orange
Apple Papaya Kiwi Papaya
Kiwi Pear Grapes Pear
Watermelon Apple Watermelon

A to Z Z to A
Watermelon
Emp ID Emp Name Depauture Salary Emp ID Emp Name
E206 Mehul Gupta Finance 36000 E201 Deepika Mahajan
E205 Sonika Sharma Marteking 39000 E206 Mehul Gupta
E204 Suyash Chopra HR 45000 E203 Anil Mahadevan
E203 Anil Mahadevan HR 45000 E204 Suyash Chopra
E202 Ritika Chung Markating 50000 E202 Ritika Chung
E201 Deepika Mahajan Finance 52000 E205 Sonika Sharma

Emp ID Emp Name Depauture Salary CUSTOM SORT


E206 Mehul Gupta Finance 36000 DEPATMENT ATO Z
E205 Sonika Sharma Marteking 39000 SALARY LARGE TO SMALL
E204 Suyash Chopra HR 45000
E203 Anil Mahadevan HR 45000
E202 Ritika Chung Markating 50000
E201 Deepika Mahajan Finance 52000
Depauture Salary
Finance 45000
Finance 39000
HR 52000
HR 36000
Markating 50000
Marteking 45000

MENT ATO Z
LARGE TO SMALL
Emp ID Emp Name DepautureSalary
E204 Suyash Chopra HR 45000
E203 Anil Mahadevan HR 45000

Emp ID Emp Name DepautureSalary


E206 Mehul Gupta Finance 36000
E205 Sonika Sharma Marteking 39000
E204 Suyash Chopra HR 45000
E203 Anil Mahadevan HR 45000
E202 Ritika Chung Markating 50000
E201 Deepika Mahajan Finance 52000
Emp ID Emp Name Depauture Salary
E206 Mehul Gupta Finance 36000
E205 Sonika Sharma Marteking 39000
E204 Suyash Chopra HR 45000
E203 Anil Mahadevan HR 45000
E202 Ritika Chung Markating 50000
E201 Deepika Mahajan Finance 52000

Emp ID Emp Name Depauture Salary


E206 Mehul Gupta Finance 36000
E205 Sonika Sharma Marteking 39000
E204 Suyash Chopra HR 45000
E203 Anil Mahadevan HR 45000
Item Sold Jan Feb Mar Item Sold Jan Feb Mar
LCD/LED 85 70 90 LCD/LED 85 70 90
Washing Machine 45 67 56 Washing Machine 45 67 56
Refrigerator 87 69 100 Refrigerator 87 69 100
Food Processer 78 83 67 Food Processer 78 83 67
Air Conditiner 65 75 90 Air Conditiner 65 75 90
Microwave Oven 55 42 53 Microwave Oven 55 42 53
Air Purifier 38 49 52 Air Purifier 38 49 52

Item Sold Jan Feb Mar Item Sold Jan Feb Mar
LCD/LED 85 70 90 LCD/LED 85 70 90
Washing Machine 45 67 56 Washing Machine 45 67 56
Refrigerator 87 69 100 Refrigerator 87 69 100
Food Processer 78 83 67 Food Processer 78 83 67
Air Conditiner 65 75 90 Air Conditiner 65 75 90
Microwave Oven 55 42 53 Microwave Oven 55 42 53
Air Purifier 38 49 52 Air Purifier 38 49 52

types of conditonal formating


Item Sold Jan Feb Mar
LCD/LED 85 70 90
Washing Machine 45 67 56
Refrigerator 87 69 100
Food Processer 78 83 67
Air Conditiner 65 75 90
Microwave Oven 55 42 53
Air Purifier 38 49 52

Item Sold Jan Feb Mar


LCD/LED 85 70 90
Washing Machine 45 67 56
Refrigerator 87 69 100
Food Processer 78 83 67
Air Conditiner 65 75 90
Microwave Oven 55 42 53
Air Purifier 38 49 52
Item Sold Jan Feb Mar Item Sold Jan Feb Mar
LCD/LED 85 70 90 LCD/LED 85 70 90
Washing Machine 45 67 56 Washing Machine 45 67 56
Refrigerator 87 69 100 Refrigerator 87 69 100
Food Processer 78 83 67 Food Processer 78 83 67
Air Conditiner 65 75 90 Air Conditiner 65 75 90
Microwave Oven 55 42 53 Microwave Oven 55 42 53
Air Purifier 38 49 52 Air Purifier 38 49 52

Item Sold Jan Feb Mar Item Sold Jan Feb Mar
LCD/LED 85 70 90 LCD/LED 85 70 90
Washing Machine 45 67 56 Washing Machine 45 67 56
Refrigerator 87 69 100 Refrigerator 87 69 100
Food Processer 78 83 67 Food Processer 78 83 67
Air Conditiner 65 75 90 Air Conditiner 65 75 90
Microwave Oven 55 42 53 Microwave Oven 55 42 53
Air Purifier 38 49 52 Air Purifier 38 49 52

Item Sold Jan Feb Mar Item Sold Jan Feb Mar
LCD/LED 85 70 90 LCD/LED 85 70 90
Washing Machine 45 67 56 Washing Machine 45 67 56
Refrigerator 87 69 100 Refrigerator 87 69 100
Food Processer 78 83 67 Food Processer 78 83 67
Air Conditiner 65 75 90 Air Conditiner 65 75 90
Microwave Oven 55 42 53 Microwave Oven 55 42 53
Air Purifier 38 49 52 Air Purifier 38 49 52
Item Sold Jan Feb Mar
LCD/LED 85 70 90
Washing Machine 45 67 56
Refrigerator 87 69 100
Food Processer 78 83 67
Air Conditiner 65 75 90
Microwave Oven 55 42 53
Air Purifier 38 49 52

Item Sold Jan Feb Mar


LCD/LED 85 70 90
Washing Machine 45 67 56
Refrigerator 87 69 100
Food Processer 78 83 67
Air Conditiner 65 75 90
Microwave Oven 55 42 53
Air Purifier 38 49 52
FINISHED L
ED LESSON ll
N ll
REVISION
ON 1
Emp ID Emp Name Depauture Salary
E204 Suyash Chopra HR 45000
E203 Anil Mahadevan HR 45000
Emp ID Emp Name DepautureSalary
E206 Mehul Gupta Finance 36000
E205 Sonika Sharma Marteking 39000
E204 Suyash Chopra HR 45000
E203 Anil Mahadevan HR 45000
Item Sold Jan Feb Mar
LCD/LED 85 70 90
Washing Machin 45 67 56
Refrigerator 87 69 100
Food Processer 78 83 67
Air Conditiner 65 75 90
Microwave Oven 55 42 53
Air Purifier 38 49 52

You might also like