ALL BUNDLED WALLSTREETPREP: EXCEL CRASH, ACCOUNTING AND BOND COURSE QUESTIONS AND ANSWERS

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

WALLSTREETPREP: EXCEL CRASH COURSE QUESTIONS AND ANSWERS All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: Alt h i w What is a keyboard shortcut to open a file?` Ctrl o What is the recommended workbook calculation setting for Excel? ...

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

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

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

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

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

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

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

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

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

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