Reference no: EM131324609
Case Problem-
Global Site GPS - Kevin Hodge is a production assistant at Global Site GPS, a leading manufacturer of GPS devices located in Crestwood, Missouri. One of Kevin's jobs is to monitor output at the company's five regional plants. He wants to create an Excel workbook that reports the monthly production at the five sites, including the monthly average, minimum, and maximum production and total production for the previous year. He asks you to crate the workbook that reports these stats.
Complete the following steps:
1. Open the Global workbook located on your flash drive, and then save it as Global Site.
2. Rename the sheet1 worksheet as Production History, and then inset 12 new rows at the top of the worksheet.
3. Increase the width of column to 23 characters and the width of columns B through F top 14 characters.
4. In the range B7:F7, enter the titles Plant1, Plant2, Plant3, Plant4 and Plant5, respectively.
5. In the range A8:A11, enter Total Units Produced, Average per Month, Maximum, and Minimum, respectively.
6. Select the range B26:F26, use AutoSum to calculate the sum of the production values for each of the five plants, and then drag and drop the selected cells to the range B8:F8.
7. Select the range B26:F26, use AutoSum to calculate the average of the production values for each of the five plants, and then drag and drop the selected cells to the range B9:F9.
8. Repeat Step 7 to calculate the maximum values for each of the five plants and then move those calculated values to the range B10:F10, and then repeat to calculate the minimum production values and drag and drop those calculated values to the range B11:F11.
9. In the Production History worksheet, enter the following data:
Cell Data Cell Data
A1 Global Site Gps
A2 Production Report
A3 Model B3 MapTracker 201
A4 Year B4 2010
A5 Total Units Produced
10. In cell B5, use the SUM function to add the values in the range B8:F8.
11. Insert a new worksheet named Plant Directory as the first worksheet in the workbook.
12. In cells A1 and A2, enter Global Site GPS and Plant Directory, respectively, and then enter the text given to you by your instructor
|
Plant
|
Plant Manager
|
Address
|
Phone
|
|
1
|
Karen Brookers
|
300 Commerce Ave
Crestwood, MO 63216
|
(314)555-3881
|
|
2
|
Daniel Gomez
|
15 North Main Street
Edison, NJ 08837
|
(732)555-0012
|
|
3
|
Jody Hetrick
|
3572 Howard Lane
Weston, FL 33326
|
(954)555-4817
|
|
4
|
Yong Jo
|
900 South Street
Kirkland, WA 98033
|
(425)555-8775
|
|
5
|
Sandy Nisbett
|
3771 Water Street
Helena, MT 59623
|
(406)555-4114
|
13. Set the width of Column B to 15 characters, the width of column C to 30 characters, and the width of column D to 16 characters. Autofit the height of each rows to its content.
14. Insert a new worksheet named Documentation as the first worksheet in the workbook, and then enter the following data
Cell Data Cell Data
A1 Global Site Gps
A3 Author B3 Your Name
A4 Date B4 the current date
A5 Purpose B5 Production report for Global Site GPS
15. Switch the Production History worksheet to Page Layout view, change the orientation to landscape, and then verify that the worksheet fits on a single page.
16. Save the workbook.
|
Explain at least five potential causes of network failure
: Identify at least 5 potential causes of network failure. For each potential cause of network failure, create a plan with the necessary steps and required hardware to reduce the risk of failure.
|
|
Create an acceptable use policy for the organization
: Create an Acceptable Use Policy for the organization the student has chosen. In a separate discussion (meaning outside of the policy) talk about the tools and processes that can be used for investigate violations.
|
|
What is its current yield
: A bond with a par value of $1000 and a semi annual coupon has a nominal yield to maturity of 5.3% and a current price of $920 . if the bond has 6 years to maturity, what is its current yield?
|
|
Discuss the influence of wto on global health
: Discuss the influence of WTO (World Trade Organization) on global health. How is poverty considered the cause of diseases?
|
|
Create an excel workbook that reports the monthly production
: He wants to create an Excel workbook that reports the monthly production at the five sites, including the monthly average, minimum, and maximum production and total production for the previous year.
|
|
Paper topic - charles carrol of carrollton
: TOPIC: Charles Carrol of Carrollton. Describe the resources that you found. Are your resources books, article, letters, diaries, prayer books, or material culture (i.e. relics, statues, pictures, prayer cards, etc.)
|
|
Discussing the domestic and foreign policy of your selection
: Select a postcolonial African nation and craft an essay discussing the domestic and foreign policy of your selection. Your essay MUST include significant data on politics, economic, and social triumphs and challenges of this nation
|
|
Determine the cost of internal equity
: The Gordon Company currently pays an annual common stock dividend of $4.00 per share.
|
|
Write a descriptive annotated bibliography
: Write a descriptive annotated bibliography.- Select a current public health issue.- Conduct a search for programs at the local, state or federal level that are addressing the issues.
|