Wall street prep stuvia - Study guides, Class notes & Summaries

Alt I W - ANSWER-Add new sheet Alt E L - ANSWER-Delete worksheet Alt V Z - ANSWER-Zoom size Alt H O I - ANSWER-Auto fit column width Ctrl 1 - ANSWER-Formatting window Ctrl space - ANSWER-highlight row Alt H O R - ANSWER-Rename Worksheet Shift space - ANSWER-highlight row Alt H O H - ANSWER-Sets row height ALT E S - ANSWER-Paste Special Ctrl Home - ANSWER-Jumps to left side of a cell Ctrl End - ANSWER-Jumps to the end of a cell Esc - ANSWER-gets out of cell wit...

Keyboard Versus the Mouse - ANSWERSAlmost everything that can be done in Excel using a mouse can also be done using the keyboard shortcuts Best way to learn is to disconnect the mouse and work through Excel using only the keyboard Name Box - ANSWERSTells you what cell you are in (top left below the ribbon) Formula Bar - ANSWERSWhen you insert a formula into a cell and hit return, the cell will show you the output The formula bar, however, will show you the formula Next to "fx" right b...

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-controlling interest - ANSWER-is an expense on the income statement and equity o the balance sheet A company has the following information: • 2013 retained earnings balance of $12 billion • Net i...

Wall Street Prep: Excel 2024 Questions and Answers 100% Verified Wall Street Prep: Excel 2024 Questions and Answers 100% Verified Wall Street Prep: Excel 2024 Questions and Answers 100% Verified Wall Street Prep: Excel 2024 Questions and Answers 100% Verified Wall Street Prep: Excel 2024 Questions and Answers 100% Verified Add/delete sheets - ANSWER-alt-i-w OR alt h-i-s Moving around task ribbon - ANSWER-Tab and shift (to select) Auto fit cell - ANSWER-alt-h-o-i

What is Accounting? - ANSWERSAccounting is the language of business; it is a standard set of rules for measuring a company's financial performance. Assessing a company's financial performance is important for: The firm's officers (managers and employees) Investors Lenders General public Standard financial statements serve as a "yardstick" of communicating financial performance to the general public. Why is Accounting Important? - ANSWERSEnables managers to make corporate decisions ...

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 months. 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. ISNUMBER Function - ANSWER-Defin...

=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

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-Shift F2 Right (and down) fill - ANSWER-Ctrl (d) r Insert/delete row - ANSWER-alt i-r/h-d-r Insert/delete column - ANSWER-alt i-c/h-d-c Date formatting - ANSWER-Ctrl shift #

Wall Street Prep Premium Exam 2023 Questions and Answers 100% Accurate!!Wall Street Prep Premium Exam 2023 Questions and Answers 100% Accurate!!Wall Street Prep Premium Exam 2023 Questions and Answers 100% Accurate!!Wall Street Prep Premium Exam 2023 Questions and Answers 100% Accurate!!Wall Street Prep Premium Exam 2023 Questions and Answers 100% Accurate!! What is generally not considered to be a pre-tax non-recurring (unusual or infrequent) item? - ANSWER-Extraordinary gains/losses what...

Wall Street Prep Premium Exam 2023 Questions and Answers 100% Accurate!!Wall Street Prep Premium Exam 2023 Questions and Answers 100% Accurate!!