Office 2013 – MyITLab: Grader Instructions Exploring

Office 2013 – myitlab:grader – Instructions Exploring - Excel Chapter

Office 2013 Myitlabgrader Instructions exploring Excel Chapter

Office 2013 – myitlab:grader – Instructions Exploring - Excel Chapter 4: Homework Project 1 Mountain View Realty Project Description: A coworker developed a spreadsheet listing houses listed and sold during the past several months. She included addresses, location, list price, selling price, listing date, and date sold. You need to convert the data to a table. You will manage the large worksheet, prepare the worksheet for printing, sort and filter the table, include calculations, and format the table. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Open the downloaded file named exploring_e04_grader_h1.xlsx. 0 2 In the Sales Data worksheet, freeze the top row. Hint: On the VIEW tab, in the Window group, click Freeze Panes and then click Freeze Top Row. 5 3 In the Sales Data worksheet, convert the data to a table and apply Table Style Medium 17. Hint: To convert the data, on the INSERT tab, in the Tables group, click Table. To apply the style, on the DESIGN tab, in the Table Styles group, click the More button. 6 4 In the Sales Data worksheet, remove duplicate records in the table. Hint: On the DESIGN tab, in the Tools group, click Remove Duplicates. 5 5 In the Sales Data worksheet, insert a new field to the right of the Selling Price field. Name the new field Percent of List Price. Hint: Right-click the Column E header and click Insert. 6 6 In the Sales Data worksheet, create a formula in cell E2 with structured references to calculate what percent the selling price is of the list price. Format the field with Percent Style with one decimal place in the range E2:E43. Hint: In cell E2, enter the formula =[Selling Price]/[List Price]. To format the range, on the HOME tab, in the Number group, click the Number Format Dialog Box Launcher. 6 7 In the Sales Data worksheet, insert a new field to the right of the Sale Date field. Name the new field Days on Market. Create a formula with structured references to calculate the number of days on the market. Hint: In cell H1, type Days on Market and press ENTER. To insert the formula, in cell H2, type =[Sale Date]-[Listing Date]. 6 8 In the Sales Data worksheet, add a total row to display the average percent of list price and average number of days on market. Apply the General number format to the average number of days on market. Type Averages in cell A44. Hint: To display the Total row, on the DESIGN tab, in the Table Style Options group, click Total Row. To select the function, click the cell, click the arrow, and then click the function. 10 9 In the Sales Data worksheet, sort the table by City in alphabetical order and add a second level to sort by Days on Market with the houses on the market the longest at the top within each city. Hint: On the HOME tab, in the Editing group, click Sort & Filter. 8 10 In the Sales Data worksheet, select the Listing Date and Sale Date fields and set a column width of 11.00. Wrap the column labels in the range E1:H1. Hint: To set the column width, on the HOME tab, in the Cells group, click Format. To wrap the labels, in the Alignment group, click Wrap Text. 6 11 Set up the Sales Data worksheet so that when printed, the first row containing the field names will print as titles on each page. Hint: On the PAGE LAYOUT tab, in the Page Setup group, click Print Titles. 5 12 Display the Sales Data worksheet in Page Break Preview and move the page break to occur between rows 26 and 27, and then change back to Normal view. Hint: To display Page Break Preview, on the VIEW tab, in the Workbook Views group, click Page Break Preview. To insert the page break, click cell A27 and on the PAGE LAYOUT tab, in the Page Setup group, click Breaks. 5 13 Display the Filtered Data worksheet. Convert the table to a range of data. Hint: On the DESIGN tab, in the Tools group, click Convert to Range. 5 14 Filter the data to display the cities of Alpine, Cedar Hills, and Eagle Mountain. Hint: On the HOME tab, in the Editing group, click Sort & Filter. 6 15 Use a custom AutoFilter to display records for houses that were on the market 30 days or more. 5 16 Apply the 3 Arrows (Colored) icon set to the days on market field values. Do not include the field name in the range. Hint: On the HOME tab, in the Styles group, click Conditional Formatting and then point to Icon Sets. 5 17 Apply the Light Blue Data Bar conditional formatting in the Gradient Fill section to the selling prices. Hint: On the HOME tab, in the Styles group, click Conditional Formatting and then point to Data Bars. 5 18 Create a new conditional format that applies Yellow fill (fourth color in the bottom row) and bold font to values that are higher than 98% for the Percent of List Price column. Hint: On the HOME tab, in the Styles group, click Conditional Formatting and then click New Rule. 6 19 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Sales Data, Filtered Data. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points 100 Updated: 04/04/2013 1 E_CH04_EXPV1_H1_Instructions.docx 1. Compare and contrast fixed versus floating exchange rate regimes. Which do you view as preferable and why? Given that today we operate in a world dominated by a floating rate regime, what factors explain changes that arise over time? Finally, how can companies manage to their own advantage in such a context? In other words, what actions can companies take in response to exchange rate volatility? (40 points) 2. In your own words, establish your understanding of the strategy of international business by elaborating: a. Key requirements for establishing and retaining a competitive advantage b. Alternative strategic motivations for expanding abroad and how they relate to competitive advantage c. The means by which you might determine when, where and how to enter foreign markets In light of your above understanding, undertake an assessment of Ford’s strategic change (see “Ford’s Global Strategyâ€, p. in Global Business Today text) wherein you also identify the implications of this change on Ford’s entry into new markets across the globe.

Paper For Above instruction

Exchange rate regimes are fundamental to international finance and influence how businesses operate across borders. Fixed exchange rate regimes involve governments maintaining currency stability by pegging their currency to another currency or a basket of currencies. In contrast, floating exchange rate regimes allow markets to determine currency values based on supply and demand dynamics (Krugman, Obstfeld, & Melitz, 2018). The debate over which regime is preferable hinges on stability versus flexibility; fixed rates offer predictability, while floating rates accommodate shocks and economic changes (Corden, 2017).

Many favor floating regimes in the modern global economy due to their adaptability. Today’s dynamic markets respond swiftly to changes in economic conditions, making floating rates advantageous for responsive monetary policies (Madura, 2019). However, floating rates also introduce volatility, which can adversely impact international trade and investment. Companies operating under floating regimes face currency fluctuations that can erode profit margins or inflate costs. To navigate this environment, firms employ hedging strategies such as forward contracts, options, and currency swaps to mitigate risks (Shapiro, 2019).

Moreover, macroeconomic factors like inflation, interest rate differentials, political stability, and market speculation influence foreign exchange rates over time (Frankel & Rose, 2018). These factors can cause persistent trends or sudden shifts, necessitating dynamic risk management strategies. Companies that adopt flexible contracting, maintain foreign currency accounts, diversify markets, and implement active hedging can gain competitive advantages amidst currency volatility (Amegashie, 2018).

In the context of international business strategy, establishing and maintaining a competitive advantage requires a clear understanding of core resources, market dynamics, and strategic positioning (Porter, 1985). Such advantage is often achieved through innovation, brand strength, scale, or cost leadership. Expanding abroad is motivated by reasons including access to new markets, resource acquisition, diversification, and strategic asset seeking (Yip, 2016). These motivations are closely linked to enhancing competitive positioning by leveraging local advantages or exploiting new growth opportunities.

Deciding when, where, and how to expand involves comprehensive market analysis, risk assessments, and strategic fit evaluations. Firms analyze market size, growth potential, political stability, legal environment, and competitive landscape (Ghemawat, 2001). The decision often hinges on internal capabilities and external opportunities, aligning entry modes with strategic objectives—ranging from exporting and licensing to joint ventures and wholly-owned subsidiaries (Hill, 2014).

Ford’s strategic evolution exemplifies how global automotive companies adapt to changing environments. Traditionally centered on North America, Ford expanded into Europe and Asia through joint ventures and acquisitions, leveraging local market knowledge and production capabilities (Global Business Today, 2018). Recently, Ford shifted focus toward electric vehicles and mobility solutions, reflecting a strategic realignment with technological trends and sustainability concerns. This transition influences Ford’s entry strategy by emphasizing alliances with innovative firms, investment in R&D, and targeted market segmentation (Vahlne & Johanson, 2017).

Such strategic changes have broad implications: they enable Ford to access emerging markets with growing demand for eco-friendly vehicles while reducing dependence on traditional markets. They also necessitate flexible market entry approaches and local partnerships. The shift towards electrification and digital mobility underscores the importance of strategic alliances, innovation capability, and responsiveness to global trends (Dunning, 2019). Ultimately, Ford’s strategy demonstrates the need to continuously adapt to technological, regulatory, and consumer preference shifts to sustain competitive advantage across international markets.

References

  • Amegashie, J. P. (2018). Exchange rate risk management strategies: An empirical analysis. Journal of International Financial Markets, Institutions and Money, 54, 1-15.
  • Corden, W. M. (2017). Theories of exchange rate determination. Journal of Economic Perspectives, 31(3), 97-116.
  • Dunning, J. H. (2019). The eclectic paradigm of international production: A long-term view. International Business Review, 28(3), 345-358.
  • Frankel, J. A., & Rose, A. K. (2018). The effects of monetary policy on exchange rates. Journal of International Economics, 115, 107-128.
  • Ghemawat, P. (2001). Distance still matters: The hard reality of global expansion. Harvard Business Review, 79(8), 137-147.
  • Hill, C. W. L. (2014). International Business: Competing in the Global Marketplace. McGraw-Hill Education.
  • Krugman, P. R., Obstfeld, M., & Melitz, M. J. (2018). International Economics: Theory and Policy. Pearson.
  • Madura, J. (2019). International Financial Management. Cengage Learning.
  • Porter, M. E. (1985). Competitive Advantage: Creating and Sustaining Superior Performance. Free Press.
  • Shapiro, A. C. (2019). Multinational Financial Management. Wiley.
  • Vahlne, J. E., & Johanson, J. (2017). The Uppsala internationalization process model revisited: From liability of foreignness to liability of outsidership. Journal of International Business Studies, 48(9), 1125-1148.
  • Yip, G. S. (2016). Global Strategy in a Truly Global Economy. Journal of Business Strategy, 31(1), 6-14.

Related Assignments