Wall Street Prep

Excel Crash Course Exam from Wall Street Prep - Wall Street Prep. Instructions: Questions 1-4 use the financial model on tab Q1-4 in the Exam Workbook. Complete the model by filling in the blank cells before answering the question below. Answers should be rounded to the nearest whole number, comma separating 000s, NOT written in currency format. So if the answer is $5,505,210.50, you would input 5,505,210. 1. What is forecast Revenue in 2017? 13,642,021 2. ...

WALL STREET PREP PREMIUM EXAM QUESTIONS WITH VERIFIED CORRECT ANSWERS AND SOLUTIONS What is generally not considered to be a pre-tax non-recurring (unusual or infrequent) item? Extraordinary gains/losses what is false about depreciation and amortization D&A may be classified within interest expense Company X's current assets increased by $40 million from while the companies current liabilities increased by $25 million over the same period. the cash impact of the change in working capit...

WALL STREET PREP: BONDS CRASH COURSE EXAM QUESTIONS WITH COMPLETE SOLUTIONS What is the focus of the course? analysis of debt Where does demand for bonds come from? Demand comes from governments, corporations, and households. What are Fixed income securities? Fixed income securities: financial instruments that require the borrower to pay a predetermined amount to the holder of the security in exchange for capital upfront. Example of a fixed income security Example: a corporation needs to...

WALL STREET PREP: EXCEL EXAM QUESTIONS WITH COMPLETE SOLUTIONS RATED A++ Add/delete sheets alt-i-w OR alt h-i-s Moving around task ribbon Tab and shift (to select) Auto fit cell alt-h-o-i Custom fit columns alt h-o-w Custom fit rows alt h-o-h Select entire column/row ctrl shift-arrow key Format cells ctrl 1 Paste special alt e-s Freeze panes alt w-f-f Split panes alt w-s Move between panes F6 Get in cell AND navigate to others while inside F2 Edit a cell from the outsi...

ACCOUNTING CRASH COURSE - WALL STREET PREP QUESTIONS AND COMPLETE SOLUTIONS UPDATED AND VERIFEID Net Revenues -Total dollar payment for goods and services that are credited to an income statement over a particular time period Cost of Goods Sold (COGS) -represents a company's direct cost of manufacture or procurement of. a good or service that the company sells to generate revenue. Gross Profit Revenues - Cost of Goods Sold (COGS) Selling, General & Administrative (SG&A) -Operating cos...

EXCEL SHORTCUTS FROM WALL STREET PREP EXAM QUESTIONS WITH COMPLETE SOLUTIONS Bold CTRL + B Italic CTRL + I Underline CTRL + U Format Cells Menu CTRL + 1 Copy Ctrl + C Paste Ctrl + V Paste Only Formats ALT+E+S+T Paste Only Formulas ALT+E+S+F Paste Only Values ALT+E+S+V Cut CTRL + X Redo CTRL + Y Undo CTRL + Z Delete cell contents Delete Delete all cell attributes ALT + H + E + A Delete cell comment ALT + H + E + M Outline border SHIFT + CTRL + & Remove border S...

WALL STREET PREP; EXCEL CRASH COURSE FORMULAS EXAM QUESTIONS EXPLAINED Average Function Definition: An Excel function that adds a group of values, and then divides the result by the number of values in the group. IF Statement Function Definition: A function that returns one value when a condition you specify evaluates to true and a different value if it evaluates to false. Explanation: First you begin with the logical test for the function, and then provide the value the function should ...

WALL STREET PREP: EXCEL CRASH COURSE FORMULAS EXAMS WITH COMPLETE SOLUTIONS =AVERAGE(number1,[number2],...) Average Function =IF(logical test, [value if true], [value if false]) Simple IF Function =IFS(logical test n, value if true n, value if false n) IFS Function =IFERROR(value, value_if_error) IFERROR Function =EOMONTH(start_date,months) EOMONTH Function =EDATE(start date,months) EDATE Function =ISNUMBER(value) ISNUMBER Function =ISTEXT(value) ISTEXT Function =YEARFRAC(st...

WALL STREET PREP EXCEL EXAM QUESTIONS AND ANSWERS WITH COMPLETE SOLUTIONS Which of the following keys IS NOT a way to trace precedent cells? Ctrl Alt [ 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 1. With the active cell on any row but in column A, hit Alt W S to split the panes to a top and bottom. 2. Hit F6 to jump from pane to pane (in some versions of Excel you wil...

WALL STREET PREP: ACCOUNTING CRASH COURSE QUESTIONS AND CORRECT VERIFIED ANSWERS LATEST UPDATED What is Accounting? Accounting 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 pub...