(1.)Find the first name only in proper case :- (2.

) Use the Ta
amit kumar pandey Name Salary EmplyeeID Birth Date
Rakesh kumar Rakesh 53226 2004578 5-Mar-88
price Balyan Prakash 61044 2004583 3-Oct-87
manish singh Mohan 52700 2004588 10-Feb-85
Uday prakash Sohan 54978 2004593 8-Oct-85
BRIJ MOHan Jasdev 59261 2004598 20-Oct-75
Mohan lal Deepak 58357 2004603 8-Jan-85

(5.)Show the Day wise achive percentage:-

Day Target Sales
sun 100 75
mon 100 89
tue 100 80
wed 100 89
thu 100 88
fri 100 99
sat 100 51
sun 100 78
mon 100 76
tue 100 87
wed 100 87
thu 100 65
fri 100 85
sat 100 97
sun 100 72 (9) Question 4:20:00
mon 100 98 >=7:30:00 ,P 8:50:11
tue 100 53 >=4:30:00, HD 6:25:11
wed 100 74 <4:30:00, Check 3:00:12
thu 100 82 5:20:09
fri 100 65 9:30:20
sat 100 79 4:29:59
sun 100 88 8:59:59
mon 100 55 5:20:11
tue 100 66
wed 100 97
 (2.) Use the Table and fill the data
Phone Number Name Salary EmplyeeID Birth Date Phone Number
9565844124 2004588
8541247457 2004593
7845125478 2004598
9632587410 2004583
7541236587 2004603
8741265897 2004578

(6) Using the 5th question output show the graph of Target, Sales and Achieve %

Name hrs Amount Target

(10) Question Rakesh 56:00:00
Prakash 47:21:51
Mohan 14:00:00
1 extra hrs Sohan 65:00:00
pay Rs Jasdev 25:00:00
1000/- Deepak 58:00:00
 (3.) convert into Date (4.) convert into hh:mm:ss
20140518 6368
20140931 6737
20141225 3871
20141112 8491
20140912 2919
20140715 4293
20140631 7475
20140101 7548

nd Achieve % (8) Question 18

Apply 50
conditional
formating only 52
for hilighting 66
the numbers Amit
40
60
26
Kumar
79
31
15
Pandey
41
59
33
67
11
24
48:00:00
1. Find the number that is no in List 1 2. Fill the year data using the Qtr table Emp_Name
List 1 Result List 2 Qtr 4 Number Qtr 1 Number Betsy
34 40 jan 40 apr 17 Hallagan
18 30 feb 30 may 32 Ashley
48 12 mar 12 jun 31 Hallagan
25 17 Qtr 2 Number Qtr 3 Number Betsy
36 12 jul 29 oct 28 Colleen
10 17 aug 32 nov 21 Cristina
10 32 sep 12 dec 32 Colleen
41 31 Ashley
30 29 Year Number 3. Question Emilee
23 32 Jan Ashley
40 12 Feb Year Ashley
12 28 Mar Emilee
16 21 Apr Hallagan
37 14 May Month Emilee
15 25 Jun Colleen
47 38 Jul Find the Jen
46 28 Aug difference Day Jen
between
12 11 Sep Year, Zaret
43 24 Oct Month,Day Zaret
38 11 Nov using today Betsy
and your
35 14 Dec date of Colleen
28 14 Jan birth. Hallagan
27 25 Emilee
14 29 5 Question Jen
21 14 Value in G28, conditional formating in G29 Cristina
21 22 <50 - Red 52 Hallagan
21 20 >=50 - Yellow Emilee
38 11 >=75 Green Emilee
Betsy
Colleen
Emilee
Ashley

34
18
48
25
36
10
10
41
30
23
40
12
16
37
15
47
46
12
43
38
35
28
27
14
21
21
21
Date Product Units Dollars 4 Question
4-Jan-04 foundation 52 158
10-Mar-04 foundation 50 152 (A) find the Sum of unit for "Betsy" for April 04.
25-Feb-05 lipstick 9 29
22-May-06 lip gloss 55 167
4-Jan-04 foundation 52 20 (B) Find the sum of Dollar for Jen, lipstick and unit Greater than 50.
27-Nov-05 eye liner 58 176
21-Mar-04 eye liner 8 26
17-Dec-06 lip gloss 72 218 {C} Find the error and Use the Dsum to fill sum of dollar
5-Jul-06 eye liner 75 227 Emp Name Product Units
14-Apr-04 lip gloss 24 74 Name contain "e" any >50
29-Nov-04 mascara 43 131
18-Nov-04 lip gloss 23 71 (D) Count the Emp_Name begning with "C"
31-Aug-05 lip gloss 49 150
1-Jan-05 eye liner 18 56
12-Apr-04 mascara 45 137 (E) Sum of units where Units itself greater and equal to 50
30-Apr-06 mascara 66 200
31-Aug-05 lip gloss 88 265
27-Oct-04 eye liner 78 236 (F) Using Sumif fill Fill the sum of unit
27-Nov-05 lip gloss 57 173 Emp_Name Units
2-Jun-06 mascara 12 38 Hallagan
15-Jan-04 lip gloss 13 42
1-Feb-06 mascara 25 77 (G) Fill the coun for below mention headings
2-May-05 foundation 29 88 Emp_Name Date Product
6-Dec-06 lip gloss 24 75
12-Apr-04 lipstick 38 116
22-Sep-05 foundation 77 233 (H) Fill the unique item fo below mention headings
24-Jun-06 foundation 38 116 Emp_Name Date Product
6-Feb-04 eye liner 25 77
10-Apr-05 mascara 19 59
26-Jan-04 lip gloss 73 221 (I) Use advance filter to copy the data on P34
6-Jun-04 lip gloss 55 167 Emp_Name Product Units
20-Sep-06 lip gloss 2 8 End with "E" contain "L" Less than 10
9-Aug-05 mascara 93 281
 for April 04.

pstick and unit Greater than 50.

m to fill sum of dollar

Dollars

greater and equal to 50

Units

ention headings

Less than 10