SpreedSheet
savgehawkDeliverable Length: 2 Parts: See Assignment Details
The company from Week 1 has merged with another smaller company that operates out of Kobe, Japan. Each company has its own personnel database. In order to take advantage of Microsoft Excel’s database features, these two databases must be merged.
Part 1: For the worksheet labeled "Seattle, Washington," perform the following steps:
- Save the spreadsheet using the following naming scheme: FirstInitialLastName_week2IPa (e.g., MRogers_week2IPa.xls).
- Add 2 columns to the next to the Full Name column. Label the first new column "First" and the second new column "Last." Using either spreadsheet functions (e.g., Left, Right, or Find) or text-to-columns, split the Full Name column into a First Name column and a Last Name column.
- Change the contents of the Full Name column to be in "Last Name, First Name" format.
- Add another column, and label it "Location." Place the worksheet name in each row of this column for each employee. Use either Copy and Paste or Fill Down operations.
- Change the Manager column contents to be in "Last Name, First Name" format. You may add temporary columns to do this and then delete them afterward. (If you use formulas that reference temporary columns, you cannot delete the temporary columns. Hint: Copy the calculated formula results, and paste values on top of them.)
- Adjust column widths for the best fit of all data.
Part 2: For the worksheet labeled "Kobe, Japan," perform the following steps:
- Add a column to the right of the Last column. Label it "Full Name."
- Using spreadsheet functions or operations, populate the Full Name column using the format "Last Name, First Name."
- Add another column, and label it "Location." Place the worksheet name in each row of this column for each employee. Use either Copy and Paste or Fill Down operations.
- Change the job titles to match Seattle job titles using the following information:
Kobe Title
Seattle Title
Assistant
Administrative Assistant
Customer Service Level 1
Customer Service Representative
Customer Service Level 2
Software Analyst
- Convert the Salary column contents from Japanese yen to U.S. dollars using the conversion rate 1 U.S. dollar = 84 Japanese Yen. You may add temporary columns to do this and delete them afterward.
- Add a column, and label it "Manager." Populate this new column. All employees report to the manager in Kobe. The manager in Kobe reports to the CEO in Seattle. Use the format "Last Name, First Name" for this column.
- 10 years ago
- 30
Answer(1)
Purchase the answer to view it
- mhutchison_week2ipa.xls
Bids(1)
other Questions(10)
- help with psychology assignment
- For each question you answer, please state the following: legal issue (if not identified in the problem), legal rule, analysis or application of the rule to the facts, your conclusion
- E8-1B (Inventoriable Costs) Presented below is a list of items that may or may not be reported as inventory in a company’s December 31 balance sheet.
- 3 PAGES
- In essence, capital budgeting is the process of:
- Can you help
- History
- Cindy Neuer’s regular hourly wage rate is $16, and she receives an hourly rate of $24 for work in excess of
- Homework for Scarlett Hadson
- Contrast how health care providers can avoid a breach of duty and stay within the federal regulations regarding sterilization procedures. Discuss the implications of this to you as a consumer of health care services.