Title First Last Phrase
Mr. Donald Chiltern
Ms. Brittany Rolling
Ms. Susie Adams
Dr. Heather Bernulli
Dr. Mary Monet
Mr. Raul Winslow
Mr. Manny Curtis
Dr. Sandra Mulholland
Mr. Stan Riggs
Dr. Stanley Benett
Mr. Stephen Hurst Your formula in column D:D should p
Dr. Nick Burgess
Mr. Ray Longworth Hey, Chiltern!
Do you want me to call you "Mr. Don
Ms. Melissa Kimsey
Dr. Electra Bourne Your formula should utilize both cell
Dr. Daisy Landrieu The red bold parts of the sentence
while the rest should be text literals.
The end result should produce two-l
Don;t forget to format the formula ce
so that the change of line is visible.
taller.
our formula in column D:D should produce sentences like:
ey, Chiltern!
o you want me to call you "Mr. Donald"?
our formula should utilize both cell references and text literals.
he red bold parts of the sentence should be cell references
hile the rest should be text literals.
he end result should produce two-line formulas, as above.
on;t forget to format the formula cells to the proper alignment,
that the change of line is visible. If necessary make the rows
ller.
Code Price Phrase
D-0-888 11.25
Y-0-265 7.74
S-4-4 17.99
X-5-678 8.34
Y-9-14 11.59
W-8-1 12.41
W-4-1 11.85
J-4-32 2.08
O-4-43 8.53 Produce the following phrase, for each product:
N-6-4 21.18
Q-7-46 21.41 The product is of class "D", belongs to group "0" and its serial number is 888.
Z-5-1 2.12 It sells at 11 euros and 25 cents.
C-9-58 11.54 You must change line before "it sells...
D-3-4 15.02
O-3-10 4.22 You are guaranteed that there will always be 2 digits after the "." in the prices.
U-0-88 2.14
N-1-308 3.09 Don;t forget to format the formula cells to the proper alignment, so that the change of line
F-0-2 14.28 is visible. If necessary make the rows taller.
V-2-8 7.51
H-8-163 2.99
U-8-11 13.74
F-3-3 17.87
R-1-1 2.88
T-7-158 16.98
A-7-7 11.85
P-0-8 2.04
I-6-77 17.29
V-0-36 13.05
N-8-80 20.05
number is 888.
"." in the prices.
t, so that the change of line
Name Phrase
Andrea
Miranda
Johnas
David
Mellon
Greg
Darlene
O' Neal
Lylah Phrase:
Jorge
Roberto The name "Andrea" starts with the letter "A" and ends with the letter "A".
Raul
Bukovski
Machiels
Stephen
Gerard
Stone
Libby
Kettering
Rania
Lois
Keats
Angelo
Hepburn
Foreman
Abramson
Pepito
Shuttleworth
Gina
Evangelista
Maynard
Edmonson
Kollias
Burt
Alice
Mestri
Holland
Arnie
Diane
Monroe
Justin
Kirstgen
Perkins
Daniela
Kurt
Margaret
Rebecca
Ogilvy
Jaimito
Caynes
Grant
Durban
Riggs
Bunkers
Rosa
Ogilvy
Benjamin
Cindy
Baldwin
Croft
Morgan
Damon
Nate
Scott
Montana
Dirac
Spader
Claris
Banks
Jaimito
Edmonson
Philippa
Welsh
Elmsford
Jessie
Boyle
Marceau
Youngblood
Hearst
Xavier
Dwayne
Courtney
Dijkstra
Rand
Michaels
Kettering
Spears
Katie
Isadora
Mia
Austin
Bob
Croft
Marturano
Merel
Sallie
Oaklie
Smith
Erol
Montalban
Bellinson
Woodward
Daisy
Claude
Greenspan
Jasmine
Mirela
Witherspoon
Lee
Machiels
Lili
Euridice
Daniela
Mimi
Rubens
Dawson
Spears
McBeal
Montana
Auldrin
Gus
Webster
Willard
Bridget
Christian
Gillet
Nat
David
d ends with the letter "A".
Title First Middle Last
MR PHILIPPE PALMER HOPKINS
MR BOB CHIP JONASON
MS ALIE DAISY WINSLOW
MR JAIMITO NORMAN BLOOMBERG
MS SABRINA CELESTE MARTURANO
MR CHUCK CHIP HUNTER
MS MINA MERCEDES MELLON
MS CYNTHIA JENNY KOWALSKI
MR BEN GIORGIO JILCRHIST
MS VALERIE ROSA TENNET
MS SUE HALLE ADAMS
MR DAMON NATHANIEL FALK
MS BROOKE LINDA AHO
MS PRISCILLA JULIETTE AYRE
MR CLEANTHE RAY BRIGHTON
MR THEODORE DASHIEL GALLAGHER
Full Name
Produce the Full Name in the following format through a text
formula (example from row 2).
Mr. Hopkins, Philippe P.
Red parts are dynamic and are produced from expressions
(operations or functions) involving cell references.
Notice that the output should not be all capital letters.
rough a text
xpressions
s.
al letters.
Title First Middle Last
MR PHILIPPE PALMER HOPKINS
MR BOB CHIP JONASON
MS ALIE DAISY WINSLOW
MR JAIMITO NORMAN BLOOMBERG
MS SABRINA CELESTE MARTURANO
MR CHUCK CHIP HUNTER
MS MINA MERCEDES MELLON
MS CYNTHIA JENNY KOWALSKI
MR BEN GIORGIO JILCRHIST
MS VALERIE ROSA TENNET
MS SUE HALLE ADAMS
MR DAMON NATHANIEL FALK
MS BROOKE LINDA AHO
MS PRISCILLA JULIETTE AYRE
MR CLEANTHE RAY BRIGHTON
MR THEODORE DASHIEL GALLAGHER
Sentence
Produce the Full Name in the following format through a text formula (example from
Good ol' Philippe P., he is the son of Hopkins
Red parts are dynamic and are produced from expressions (operations or functions)
involving cell references.
Depending on Title, you should use he/she and son/daughter. Thus you will need IF
IF(A2="mr","he","she")
If it makes it easier for you, you can use auxiliary columns for individual dynamic par
you can coin the Sentence by using only the cell references of the intermediate resu
rough a text formula (example from row 2).
Hopkins
xpressions (operations or functions)
son/daughter. Thus you will need IF.
y columns for individual dynamic parts. Then
references of the intermediate results.
Number Everett Joe Derek Harry Gary Erick
3 Melissa
Andrea
Betty
Leona
Madeleine
Christa
Melissa had 3 boyfriends before she met Everet.
Fill the gray area with phrases like the above. For the number you have to use
whatever number appears at top left.
Rolling Monet Winslow Benett Hurst Burgess Kimsey Bourne
Mr. Donald
Ms. Brittany
Ms. Susie
Mr. Raul
Mr. Manny
Mr. Stan
Mr. Stephen
Mr. Ray
Ms. Melissa
If Donald was Rolling's son, he would be called Mr. Donald Rolling.
Fill the gray area with phrases. The words "son/daughter" and
"he/she" should be chosen with on IF, based on the title.
Name Phrase
Tanya
Liza
Giorgos
Andreas
Tatiana
Domna
Maria
Antonia
Sakis
Nikos
Roula
Alekos
Kostas
Vasilis
Fenia
Makis
Koula
Giannis
Rena
Tanya is a female and should be addressed as "Ms. Tanya".
Assume that all male greek names end in "s" and all female names end in "a".
Produce phrases like the one above. Use Mr/Ms for the title.
end in "a".
