1.
Create a gmail address for the following employess
First Name Last Name Mail id
Anderson John
Ravi Kumar Ravi.Kumar@gmail,com
2 Find the length of the following string ?
How are you ? 13 13
13
3.The following data convert into a proper case
hi there ,"how are you" Hi There ,"How Are Y
Hi There ,"How Are You"
4. Compare the following data. If data in both columns are same then write "Same" otherwise "Not Same"
Pie Chart pie chart SAME
Paretto chart Paretto Chart SAME
Trendline Trend line NOT SAME
spark lines spark lines NOT SAME
5.Convert the following string starting with "C" and followed by number
QZD234 C234 C234
ASD123 C123 C123
WER345 C345 C345
FGT678 C678 C678
6.Extract the hightlighted String from the following sentence
little star star star
Monday Blues Monday Monday
How are you are are
7.Clean the following data
awert@#7234589 7234589 7234589
8
Code
100-UT UTAH UTAH
123-TX TEXAS TEXAS
6-OH OHIO OHIO
74-TX TEXAS TEXAS
18-UT UTAH UTAH
480-OH OHIO OHIO
91-TX TEXAS TEXAS
little star 9
little world world
little jack jack
little flower flower
little boy boy
AndersonJohn@gmail.com
ar@gmail,com RaviKumar@gmail.com
21
Hi There ,"How Are You"
Hi There ,"How Are You"
lumns are same then write "Same" otherwise "Not Same"
SAME SAME
SAME SAME
NOT SAME
NOT SAME NOT SAME
and followed by number
c234 C234
c123 C123
c345 C345
c678 C678
ng sentence
star star
Monday Monday
are are
7234589 7234589
For a given state code, you need to give a state . UT="Utah",TX="Texas",OH="Ohio"
Utah
Texas
Ohio
Texas
Utah
Ohio
Texas
star
world
jack
flower
boy
Anderson.John@gmail.com AndersonJohn@gmai.com
Ravi.Kumar@gmail.com Ravi.Kumar@gmail.com)
Hi There ,"How Are You"
Hi There ,"How Are You"
same SAME same
same SAME same
not same NOT SAME not same
not same NOT SAME not same
0 C234
C123
C345
C678
) little
Monday
are are are
7234589
Utah
Texas
Ohio
Texas
Utah
Ohio
Texas
star star
world world
jack jack
flower flower
boy boy
How to get first and last name
Original Name First Name
AREESHA WADIA AREESHA
ARMAAN BHASIN ARMAAN
ARYAN RANA ARYAN
ATHARV SRIVASTAVA ATHARV
AZAAN SYED AZAAN
BHARAT SUREKA BHARAT
CHANDAS E CHANDAS
CHETNA SAHNI CHETNA
DHIR LAKHANI DHIR
EKAANSH REWRI EKAANSH
HARSH SINGLA HARSH
Original Name Extract First Name and Last Name Only
Ravi Krishna Kumar
Jasmit Kapil Arora
Mahesh Abhay Saswant
Ram Kumar Gopal
Meena Shantham Singh
Sally Katrin Brook
MR. NAVINS CAR Mr. Navins Car
MR FRIEND Mr Friend
DEDF JCTH
FTHDJ CYJG
THCDFR CHCFFF
THCDFR CG
XFTGH FCTYC
FCHF FCFT
Last Name
WADIA WADIA WADIA
BHASIN BHASIN BHASIN
RANA RANA N RANA
SRIVASTAVA SRIVASTAVA VASTAVA
SYED SYED N SYED
SUREKA SUREKA SUREKA
E E NDAS E
SAHNI SAHNI SAHNI
LAKHANI LAKHANI LAKHANI
REWRI REWRI REWRI
SINGLA SINGLA SINGLA
MR. NAVINS CAR mr. navins car
MR FRIEND mr friend
DEDF JCTH Dedf Jcth dedf jcth
FTHDJ CYJG Fthdj Cyjg fthdj cyjg
THCDFR CHCFFF Thcdfr Chcfff thcdfr chcfff
THCDFR CG Thcdfr Cg thcdfr cg
XFTGH FCTYC Xftgh Fctyc xftgh fctyc
FCHF FCFT fchf fcft
P:R
DEDF JCTH DEDF JCTH DEDF JCTH DEDF JCTH
FTHDJ CYJG FTHDJ CYJG
THCDFR CHCFFF THCDFR CHCFFF
THCDFR CG THCDFR CG
XFTGH FCTYC XFTGH FCTYC
FCHF FCFT FCHF FCFT
11
11 2 0 0 heyy excel
8
123252
HELLO WORLD 6 0
hello world 11 0 OHIT
11 hello world
helloworld
o XCE HELLO WORLD
llo heyy excel WORLD
ex xce HEYY EXCEL
ellow HEYY EXCEL H
Hello hey excel
11 heyy excel S
Hello World NESS this is a string
HYUGA
LLO
p:r HELLO WORLD
=proper("
jane smith janesmith jane smith
jane smith
hello world hello world
jane smith hello world
HELLO WORLD
HELLO
E Mr. Navin'S Car
EXCE mr. navin's car
Mr. Navin'S
12345 #NAME?
45
HELLO
WORLD this is a string
This Is A String
This Is A String
this is a string 1233vfb
1233Vfb
Check String
SH
hello Hello
=upper(" Test String
Check String
5
6
P:R
Excel Is A Powerful Tool excel is a powerful tool
HELLO STRING
hello string
Hello String
Manish Patel
=A14 &" "& B14)
H
ce
hello string Hello String hello world
Hello String
