Reference no: EM131553751
Assignment
For this module's assignment we will focus on the integration of Microsoft Word and Microsoft Excel. To continue our travel project theme, we will first create a PivotTable to provide us with the travelers that have a balance due greater than or equal to $2000. Then, we will create a memo to show the management team our results.
Part 1: Adding Formulas and Creating the Pivot Table
Open the Module Data file linked below and follow these steps:
Module Data File
1. Add your name and your travel destination.
2. Add first and last names for all travelers.
3. Create formulas for the Totaland Amount Duecolumns. (The information is given on the sheet).
4. Create a pivot table for the information.
5. Filter the pivot table to show only those travelers with a balance of 2000 or more. HINT: you should have four travelers after you filter.
6. Save the Excel document using the naming convention given at the end of this assignment.
Part 2: Integrating the Pivot Table into a Word Memo
Using the Professional Design Memo template in Microsoft Word, create a memo to your employer which provides them with the travelers that have a balance due greater than or equal to $2000. In doing so, be sure to address the following requirements:
1. Open a new Word document. In the search box, run a search for the Professional Design Memo Template.
2. Update the Company Name to International Travel Company.
3. Update the values in the To, CC, From, and Date fields.
4. Update the Re: to be Statistics from Recent Balance Due Inquiry
5. The title of your template should be Travelers with >=$2000 Balance Due
6. In the body of the memo, include a short explanation of the details that you are providing to your employer.
7. Integrate the PivotTable you created in part 1 into the Memo as an Excel object. (donotcreate a link).HINT: when you double click the pivot table, you should get a mini copy of Excel.
Corporate governance and stockholder analysis
: Corporate Governance, Stockholder Analysis, Risk and Return, Dividend Policy, and Valuation.
|
How do you propose to train providers to gain these skills
: Healthcare providers need communication skills to effectively handle situations with patients, family, coworkers, and employer-employee conflicts.
|
Manufacturer of sophisticated computer parts
: W.B. Milestone, Inc., a manufacturer of sophisticated computer parts, recently moved the operations of one of its divisions to Malaysia.
|
Analyzing a portfolio
: Analyzing a portfolio. You have to invest in a portfolio containing Stock X, Stock Y and a risk free asset.
|
Create formulas for the totaland amount duecolumns
: Add your name and your travel destination. Create formulas for the Totaland Amount Duecolumns. Create a pivot table for the information.
|
Modern flooring is considering new product line
: Modern Flooring is considering a new product line. What is the net present value of the new line at a discount rate of 11.5% and tax rate of 35%.
|
The principle of autonomy prohibits a health care provider
: The principle of autonomy prohibits a health care provider from treating a patient without the informed consent of the patient or the patient's surrogate.
|
Calculate the required rate of return
: Calculate the required rate of return for Mercury Inc assuming that investors expect a 5% rate of inflation in the future.
|
How many electrons would you have to add to each sphere
: Two very small 8,55-g spheres, 15,0 cm apart from center to center, are charged by adding equal numbers of electrons to each of them.
|