Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have an excel document with 5 questions was wondering if theres anyway I could post the excel spread sheet on here or email it
I have an excel document with 5 questions was wondering if theres anyway I could post the excel spread sheet on here or email it to someone instead of posting each question seperately.
- (TOTAL 18 points)
Refer to worksheet Question 4. You are given the full names and the last names of employees in columns A and B respectively. Use appropriate text functions :
- To remove excess spaces that may be present in these names. The trimmed output needs to appear in column C (6 points)
- To change the names in column C to upper case. The output needs to appear in column D (6 points)
- To create email addresses for each employee by using their last names (as provided in column B) and adding @iup.edu to them. For instance: the email address for the first employee should appear as public@iup.edu. Please do not use the Flash Fill feature here (6 points)
La Paste B I U a. Av HIH Merge Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Xfx Trimmed output C1 A B D E Trimmed output Upper case Email addresses 1 Full Name 2 John Q Public 3 Lisa Smith 4 J. R. Robins 5 Dr. Lester B. Jones 6. J.R.R. Tolkien 7 Franklin H. Lee 8 Melvina Mary Jane Pryce 9 Suzette 1. Thorson 10 J. Frank 11 Amanda M. Rowe 12 Madonna Simon 13 Aaron E. Pacheco 14 Dennis Michael Batie 15 Lloyd Benedict Arnold 16 Agnes K. Saterfiel 17 Robert M. Simmons 18 Joseph Q. Glenn 19 Jeffrey George Bishop 20 Henrietta D. Markowski 21 William R. Gordon 22 Khalilah Gorski 23 Tammy Faye. Lindsey 24 Wilfred A. Moy 25 Carla V. Richards-Walker 26 Joseph Q Ramsey 27 Lina B. Poston 28 James Trott 29 Annita J. Alvarado 30 Kathleen C. Sullivan 31 John Paden 32 Gregory O. Dameron 33 Joyce Katherine. Russell 34 Virginia Hodge 35 Donald David. Williams 36 Justin B. Gil 37 Brittani E. Frasier 38 'Rebecca Gomez 39 Anne Richards 40 George W. Robinson 41 Peter J. Ruiz 42 Question 1 Last public smith cursins ST jones tolkien lee pryce thorson frank rowe simon pacheco batie arnold saterfiel simmons glenn bishop markowski gordon gorski lindsey moy richards-walker ramsey poston trott alvarado sullivan paden dameron russell hodge williams gil frasier gomez richards robinson ruiz Question 2 Question 3 Question 4 Question 5 +
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started