Baud 312 Final Exam Fall 2018

Content type
User Generated
Subject
Excel
Type
Homework
Rating
Showing Page:
1/28

Showing Page:
2/28

Showing Page:
3/28

End of Preview - Want to read all 28 pages?
Access Now
Unformatted Attachment Preview
ACTIVITIES 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 INSTRUCTION Task 1: STANDARDIZING THE DATASET Populate the FULLNAME consisting of the following fields ONLY, in the prescribed format: PREFIX FIRSTNAME LASTNAME. (Note: All the UPPERCASE) Generate EMAIL ADDRESS for those members, who speak English, in the prescribed format : lastname.firstname@cmcnow.org. (Note: All lowercase) Generate the USER NAME for only those members, who don't speak English, in the prescribed format : FIRSTNAME(Initial in Uppercase)LASTNAME(lowercase)COUNTRYCODE.INDEX CONVERT only the Columns 2, 10 and 11 to NUMERICAL values. (NO FORMULAS MUST BE VISIBLE.) THIS IS A GOOD TIME TO VERIFY YOU HAVE MET THE FOLLOWING OBJECTIVES : A. All members who speak English, have an email address? B. All members who don't speak English, have a user name? C. No members have both an email address and a user name? TASK 2: CONVERSIONS Col.13 has the members' height in CENTIMETERS. Jennifer needs it converted to INCHES in column 25, rounded to ONE significant digit. ( Note: 1 cm = 0.3937007874 inch. ) Col.14 has the members' weight in KILOGRAMS. Jennifer needs it converted to POUNDS in column 26, rounded to TWO significant digit. ( Note: 1 Kg = 2.2046226218 Lbs. ) Using data computed in Col.25 and Col.26, calculate CMC-SCORE in Col.27 using the formula : 703 x Weight [ LBS] / ( Height [ INCH]^2 ). Ensure that the is ROUNDED to from one significant digit after decimal. Using data computed in Col.27, usecalculated ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Review

Anonymous
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!

Studypool
4.7
Indeed
4.5
Sitejabber
4.4