Reference no: EM133371751

The Patagonia Exploration Club International (PECO is a group of diverse individuals across many co. Jennifer Cardozo, the club's President, has taken up the challenge to systematize the membership ro In a very short time, she has pulled together a lot of information!
An extract of 50 such records is available on the tab, CLUBDATA.
This is the portion, where PECI needs your EXCEL expertise...
Starting with the tab, CLUBDATA, Jennifer would like you to help her solve the following

INSTRUCTION:

Part 1:
Populate the FULLNAME consisting of the following fields ONLY, in the prescribed format: PREFIX FIRSTNAME LASTNAN lowercase)
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 WE 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?

Part 2:
Kg = 2.2046226218 Lbs. )
the calculated number is ROUNDED to one significant digit after decimal.
Using data computed in Co1.27, use VLOOKUP to populate PECI-CODE from the tab FITNESS TABLE. Use AUTOFILL. Righ tag 'ADMIT'. Right justify the results.
THIS IS A GOOD TIME TO VERIFY WE HAVE MET THE FOLLOWING OBJECTIVES :
A. All members have their height listed in INCHES in the format ##.#
B. All members have their weight listed in POUNDS in the format itittt.tal
C. All members have their PECI-SCORE as a WHOLE NUMBER in format hint

Part 3:

10 Create a PIVOT table in the tab, PIVOT, starting at cell B3, with the following details:
In COLUMNS (Group : YEARS only. Remove QUARTERS and BIRTHDATE.) In ROWS (Group : SEX. COUNTRY.)
In VALUES (Calculate AVERAGE OF HEIGHT IN INCHES, formatted as ##.#) Remove GRAND TOTAL
Freeze both panes from cell D5.
Adjust COLUMN WIDTH from D to the end of the PIVOT table, to the value, 8.

Part 4:

Insert the following details into the HEADER using the PAGE SETUP: In LEFT section : Enter your FIRSTNAME LASTNAME in Calibri 12 BOLD.
In CENT1 section: Insert link for FILENAME and SHEETNAME in Calibri 12 BOLD. In RIGHT section: Insert link for TIME and DATE in Calibri 12 BOLD.
Insert the following details into the FOOTER using the PAGE SETUP: In CENTER section: Insert path to FILENAME in Calibri 10 BOLD.