Wall Street Prep

WALL STREET PREP: EXCEL CRASH COURSE QUESTIONS AND CORRECT ANSWERS Keyboard Versus the Mouse Almost 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 Tells you what cell you are in (top left below the ribbon) Formula Bar When you insert a formula into a cell and hit return, the cell will show you the output The formula bar, however, wil...

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; 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...

WALL STREET PREP: EXCEL CRASH COURSE QUESTIONS AND CORRECT ANSWERS Keyboard Versus the Mouse Almost 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 Tells you what cell you are in (top left below the ribbon) Formula Bar When you insert a formula into a cell and hit return, the cell will show you the output The formula bar, however, wil...

Wall Street Prep Premium Exam Questions and Answers 1. What is generally not considered to be a pre-tax non-recurring (unusual or infrequent) item?: Ans- Extraordinary gains/losses 2. what is false about depreciation and amortization: Ans- D&A may be classified within interest expense 3. 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 capital was: Ans-...

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...

This study pack provides a clear, student-friendly breakdown of key concepts from the Wall Street Prep: Bonds Crash Course, including practice exam questions with full reasoning and explanations. It covers essential foundations of debt markets, bond structures, fixed-income mechanics, securitization, and institutional demand for bonds. Each question includes complete concept-based solutions to help you understand not only the what, but the why behind every answer. Topics included: – Bon...