Quiz on Excel techniques

1. You can change the color of a worksheet tab in Excel 2010.TrueFalse2. Rows are identified using numbers.TrueFalse3. To view a comment on a worksheet you can simply mouse over the red triangle in a cell.TrueFalse4. Columns are identified using numbers.TrueFalse5. You can rename a worksheet tab.TrueFalse6. The feature of Excel allows you to copy the same value, function, or formula to another cell or group of cells.Auto FillMergeText alignmentEither Merge or Text alignment7. To use the AuotFit Row Height tool you would find it in the follow group:FormulaCellsEditingClipboard8. What is in a cell that indicates a comment is present?Green triangleRed triangleYellow triangleNone of the above9. What specific type of application is Excel considered to be?DatabaseWord ProcessingSpreadsheetPresentation10. In the format cells dialog box you can format all of the following except:FontFillProtectionTab name11. If you need to change the width of a column or height of a row you would use this feature in Excel:AlignmentAutofitAutosizeResize12. This group in Excel contains the options to align text within a cell.Font GroupAlignment GroupParagraph groupStyles group13. Where a row and column intersect is referred to as a:CellLocationName boxNone of the above14. In Excel 2010, by default a number is formatted as:CurrencyGeneralPercentageNormal15. In Excel this element can be thought of like the old paper legers, in online electronic form.CellWorksheetFormulaNone of the above16. The cell size in a worksheet is seldom times large enough to hold text that you may want to type into a cell. To ensure all your text appears in a cell without resizing the cell you could use the following tool:Center and MergeIndentationWrap TextOnly type single words in a cell17. To select an entire worksheet to change the font or font size you would select the:Font ribbonFont and font size optionSelect all buttonNone of the above18. Where is the fill handle located?Lower right hand corner of an active cellLower left hand corner of an active cellUpper right hand corner of an active cellUpper left hand corner of an active cell19. The column width tools are found in this groupEditingHomeInsertCells20. The format currency button is found in this group:HomeCellsNumberEditing21. To format a worksheet professionally you could select this tool:FormattingStylesFontColor22. To add a useful tip or to document something in Excel you can add something that looks like a post-it note. This is referred to as a:CommentDescriptionDocumentationNone of the above23. This bar is located directly below the ribbon and just above the grid of columns and rows in a worksheet. You use this bar to enter formulas and/or functions.MenuNumberFormulaEither Number or Formula24. This is located at the bottom of a worksheet below the worksheet tabs. This displays a variety of information related to the data on a worksheet:Formula BarName BoxMenu BarStatus Bar25. By default when you first open Excel these numbers of worksheets are available?OneFourTwoThree

Software Application

1. You can change the color of a worksheet tab in Excel 2010.TrueFalse2. Rows are identified using numbers.TrueFalse3. To view a comment on a worksheet you can simply mouse over the red triangle in a cell.TrueFalse4. Columns are identified using numbers.TrueFalse5. You can rename a worksheet tab.TrueFalse6. The feature of Excel allows you to copy the same value, function, or formula to another cell or group of cells.Auto FillMergeText alignmentEither Merge or Text alignment7. To use the AuotFit Row Height tool you would find it in the follow group:FormulaCellsEditingClipboard8. What is in a cell that indicates a comment is present?Green triangleRed triangleYellow triangleNone of the above9. What specific type of application is Excel considered to be?DatabaseWord ProcessingSpreadsheetPresentation10. In the format cells dialog box you can format all of the following except:FontFillProtectionTab name11. If you need to change the width of a column or height of a row you would use this feature in Excel:AlignmentAutofitAutosizeResize12. This group in Excel contains the options to align text within a cell.Font GroupAlignment GroupParagraph groupStyles group13. Where a row and column intersect is referred to as a:CellLocationName boxNone of the above14. In Excel 2010, by default a number is formatted as:CurrencyGeneralPercentageNormal15. In Excel this element can be thought of like the old paper legers, in online electronic form.CellWorksheetFormulaNone of the above16. The cell size in a worksheet is seldom times large enough to hold text that you may want to type into a cell. To ensure all your text appears in a cell without resizing the cell you could use the following tool:Center and MergeIndentationWrap TextOnly type single words in a cell17. To select an entire worksheet to change the font or font size you would select the:Font ribbonFont and font size optionSelect all buttonNone of the above18. Where is the fill handle located?Lower right hand corner of an active cellLower left hand corner of an active cellUpper right hand corner of an active cellUpper left hand corner of an active cell19. The column width tools are found in this groupEditingHomeInsertCells20. The format currency button is found in this group:HomeCellsNumberEditing21. To format a worksheet professionally you could select this tool:FormattingStylesFontColor22. To add a useful tip or to document something in Excel you can add something that looks like a post-it note. This is referred to as a:CommentDescriptionDocumentationNone of the above23. This bar is located directly below the ribbon and just above the grid of columns and rows in a worksheet. You use this bar to enter formulas and/or functions.MenuNumberFormulaEither Number or Formula24. This is located at the bottom of a worksheet below the worksheet tabs. This displays a variety of information related to the data on a worksheet:Formula BarName BoxMenu BarStatus Bar25. By default when you first open Excel these numbers of worksheets are available?OneFourTwoThree

Analysis of financial statements

you will be comparing the financial statements of two companies. Please select from the following list:1.Wal-Mart2.Kmart3.Target        http://investors.target.com/phoenix.zhtml?p=irol-irhome&ref=nav5Ffooter5Finvestors&c=658284.Carrefour       Group5.Tesco plc.To locate the financial statements, go to the Investors section of the company website and access the most recent annual report. Be sure when you are comparing the companies, the annual report selected is for the same year. Once you have made your selection, please answer the following Discussion Questions:1.What are the differences and similarities between their income statements?2.What are the differences and similarities between their balance sheets? What classifications are presented?3.Locate the notes the financial statements and highlight some of the notes you found would be of interest to investors about each company.

Four Essays

The long essay would be a traditional essay that typically fiveparagraphs long. The first paragraph should introduce the topic and state thestudent’s position / answer to the question. It should contain betweenthree-five (3-5) complete sentences, including the thesis statement for theessay. The second, third, and fourth paragraphs are the body paragraphs. Eachbody paragraph should contain between three-five (3-5) sentences, including thetopic sentence (first sentence of the body paragraph, states a main point thatsupports the thesis) and at least two-three (2-3) specific examples per mainpoint. The fifth and final paragraph should begin with a restatement of thethesis. It should be three-five (3-5) complete sentences, and include a briefsummary/conclusion of the student’s answer to the essay question. It isessential, particularly in the survey courses, for students to provide citesand footnotes for their work in untimed exams. Citations must adhere to theChicago Style format but perfection is not expected. An example of commoncitations are included on pages four and five of this edition.What was the role of the railroads in the settlement of theGreat West?Describe Keynesianeconomic policies. How important were they to the NewDeal?What was the long term significance of the Korean War?What were the key elements of Reagan’s domestic policy?DUE THURSDAY!!!!

BUS 401 Chapter 9 Mini Case

Review the financial information in the Chapter 9 Mini Case on pages 260 and 261 of you text. Answer the following questions in an Excel document. Solve using Excel formulas (preferred) or clearly write out the steps you took to calculate your answers. Round any dollar amounts to the nearest dollar ($1,500,074) and any percentages to two decimals (9.56%).
Market prices are $1,035 for bonds, $19 for preferred stock, and $35 for common stock. There will be sufficient internal common equity funding (i.e., retained earnings) available such that the firm does not plan to issue new common stock. Calculate the firm’s weighted average cost of capital.
In part a we assumed that Nealon would have sufficient retained earnings such that it would not need to sell additional common stock to finance its new investments. Consider the situation now, when Nealon’s retained earnings anticipated for the coming year are expected to fall short of the equity requirement of 47 percent of new capital raised. Consequently, the firm foresees the possibility that new common shares will have to be issued. To facilitate the sale of shares, Nealon’s investment banker has advised management that they should expect a price discount of approximately 7 percent, or $2.45 per share. Under these terms, the new shares should provide net proceeds of about $32.55. What is Nealon’s cost of equity capital when new shares are sold, and what is the weighted average cost of the added funds involved in the issuance of new shares?