Wall Street Prep Exam Bundle Questions &Answers 100% SOLVED

What was the weighted average interest rate Colgate faced on its short-term borrowings in 2013? Enter with 1 decimal place and with % sign (Ex: 9.9%) - ANSWER-2.2% Based on the company's 2013 10-K, how much long term debt is maturing between 2014 and 2016? Please provide your answer in millions ...

A company has the following information: • 2014 share repurchase plan of $4 billion • Average share price of $60 for the year 2013 • Expected EPS growth for 2014 of 10% What should the number of shares repurchased by the company be in your financial model? - ANSWER-60.6 million non-cont...

What is the keyboard shortcut to freeze panes within a worksheet? - ANSWER-Alt W F F Please select the answer that best describes the shortcut to Split (not freeze) an excel sheet into just two panes (top and bottom) To navigate from pane to pane - ANSWER-1. With the active cell on any row but ...

Format cells - ANSWER-ctrl 1 Paste special - ANSWER-alt e-s Freeze panes - ANSWER-alt w-f-f Split panes - ANSWER-alt w-s Move between panes - ANSWER-F6 Get in cell AND navigate to others while inside - ANSWER-F2 Edit a cell from the outside - ANSWER-alt h-e Add comments - ANSWER...

Esc - ANSWER-gets out of cell without changing anything Alt H E A - ANSWER-Deletes content and formatting Shift F2 - ANSWER-Insert a comment Alt H E M - ANSWER-Deletes a comment Ctrl R - ANSWER-right fill

manipulating data inside a cell - ANSWER-*F2* is the command that puts you inside a cell: -pressing the F2 key once shows you the components of the formula you created earlier, puts you inside a cell and enables you to navigate through it to edit the existing cell data -pressing the F2 key twice a...

=ISNUMBER(value) - ANSWER-ISNUMBER Function =ISTEXT(value) - ANSWER-ISTEXT Function =YEARFRAC(start_date,End_date,Basis) - ANSWER-YEARFRAC Function =DATE(year, month, day) - ANSWER-DATE Function =DAY(Serial Number) - ANSWER-DAY Function

Explanation: Start by inputting the start_date into the first argument. Then input how many months ahead or behind you would like to go from that start_date. EDATE Function - ANSWER-Definition: Similar to EOMONTH but this return the exact date from the start-date, after the specified number of mo...