Reference no: EM132685702
Review Assignments
Data File needed for the Review Assignments: Youth.xlsx
The Billings Cooking Club also has a youth division for members 6 to 18 years of age. Shirley has a second workbook to store the information collected about these members. Shirley asks you to clean and format the data.
Complete the following:
1. Open the Youth workbook located in the ExcelA > Review folder included with your Data Files, and then save the workbook in Excel Workbook format as Youth Cooking in the location specified by your instructor.
2. In the Documentation worksheet, enter your name and the date.
3. In the Members worksheet, rename the table MembersTbl.
4. Insert a blank column to the left of column B to store the first name, and leave the last name in column A.
5. Use the Text to Columns command to split the Member column into two columns named Last Name and First Name. (Hint: You will have two delimiters-space and comma.)
6. In cell H1, enter Status as the column header. In cell H2, use the IF and LEFT functions to display the word Discard if the address begins with PO; otherwise, leave the cell blank. Copy the data in column H to the Clipboard, and then paste the values back over column H to remove the formulas.
7. In cell 11, enter Street as the column header. In cell 12, enter a formula to trim the extra spaces from the address. Copy the data in column Ito the Clipboard, and then paste the values back over column Ito remove the formulas.
8. In cell J1, enter Cty as the column header. In cell J2, enter a formula to convert the data in the City column to proper case. Copy the data in column J to the Clipboard, and then paste the values back over column J to remove the formulas.
9. In cell Kl, enter St as the column header. In column K, enter a formula to convert the data in the State column to uppercase. Copy the data in column K to the Clipboard, and then paste the values back over column K to remove the formulas.
10. In cell Ll, enter City State as the column header. In column L, combine the city and state data from columns J and K into one column using the format City, State.
11. Format the data in the Phone column (column F) with the Phone Number format.
12. You can now delete columns C (Address), D (City), and E (State).
13. Save the workbook, and then close it.
Attachment:- Youth.rar
|
Analyze african popular music as a convergence of genres
: Analyze African popular music as a convergence of genres, immersed in experimentations, negotiations and transformations that crisscross histories
|
|
Introduced to sUAS regulation
: You were introduced to sUAS regulation, components and systems, operations, technology, and the concepts of safety of flight,
|
|
Presence of income taxes change
: What does the presence of income taxes change in respect to the net present value of a project?
|
|
Data abstractions-technology for developing effective system
: Using the data abstractions, technology for developing effective systems, management issues in system development database systems
|
|
Convert the data in the city column to proper case
: Use the Text to Columns command to split the Member column into two columns named Last Name and First Name - paste the values back over column K to remove
|
|
How humans are causing global warming and climate change
: Elaborate on how humans are causing global warming and climate change. Elaborate on thing like carbon foot prints and greenhouse gases.
|
|
What you understand by the term full risk models
: With the aid of examples from different organisations, discuss what you understand by the term full risk models and the criticisms of full models.
|
|
Compare and contrast symmetrical and cambered wings
: Compare and contrast Symmetrical and Cambered wings. What are the reasons for using these different type of wings in an aircraft design?
|
|
How will the development impact their lives
: How did they arrive at this conclusion? What steps will you take to develop this area? How will this development impact their lives?
|