Wall Street Prep Guías de estudio, Notas de estudios & Resúmenes

Wall Street Prep – Excel questions and answers 2024

Wall Street Prep Premium Exam Questions With 100% Correct Answers What is generally not considered to be a pre-tax non-recurring (unusual or infrequent) item? - answerExtraordinary gains/losses what is false about depreciation and amortization - answerD&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 capital...

Practice Test Exam Wall Street Prep Excel Crash Course Formulas =AVERAGE(number1,[number2],...) - CORRECT ANSWER-Average Function =IF(logical test, [value if true], [value if false]) - CORRECT ANSWER-Simple IF Function =IFS(logical test n, value if true n, value if false n) - CORRECT ANSWER-IFS Function =IFERROR(value, value_if_error) - CORRECT ANSWER-IFERROR Function =EOMONTH(start_date,months) - CORRECT ANSWER-EOMONTH Function =EDATE(start date,months) - CORRECT ANSWER-EDATE Function =...

FASB - ANSWER-Financial Accounting Standards Board, which oversees GAAP through issuance of SFAS, oversight by the SEC SFAS - ANSWER-Standard Financial Accounting Statements, issued by the FASB AA,P,C: Accounting Entity - ANSWER-The assumption that a corporation is an entity separate from any person AA,P,C: Going Concern - ANSWER-The Assumption that a corporation will continue to exist for the foreseeable future AA,P,C: Measurement & Units - ANSWER-The principle that financial statem...

Wall Street Prep Exam Questions and Answers 100%Assets - ANSWER-resources a company uses to operate its business includes cash, A/R, PP&E Liabilities - ANSWER-represents the company's contractual obligations and includes A/P, debt, accrued expenses Shareholder's equity - ANSWER-is the residual the value of the business available to the owners (shareholders) after debts have been paid off Income statement - ANSWER-illustrates the profitability of the company over a specified per...

Wall Street Prep Exam 2024 Questions and Answers (Do companies prefer straight-line or accelerated depreciation? - ANSWER-For GAAP reporting purposes, companies generally prefer straight-line depreciation. That's because a company will record lower depreciation in the early years of the asset's life than if they had used accelerated depreciation. As a result, companies using straight-line depreciation will show higher net income than under accelerated depreciation. Do companies depreciate l...

Excel Final Exam Review (Excel Crash Course) Q&A Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings? - CORRECT ANSWER-B. Show Which of the following notebook- like features organizes the sheets for use in Excel? - CORRECT ANSWER-A. Workbook Which view enables a user to create or modify a worksheet while seeing how it will look in printed format? - CORRECT ANSWER-A. Page Layout Which of the following would you use to enter, calc...

Practice Test Exam Wall Street Prep Excel Crash Course Formulas =AVERAGE(number1,[number2],...) - CORRECT ANSWER-Average Function =IF(logical test, [value if true], [value if false]) - CORRECT ANSWER-Simple IF Function =IFS(logical test n, value if true n, value if false n) - CORRECT ANSWER-IFS Function =IFERROR(value, value_if_error) - CORRECT ANSWER-IFERROR Function =EOMONTH(start_date,months) - CORRECT ANSWER-EOMONTH Function =EDATE(start date,months) - CORRECT ANSWER-EDATE Function =...

excel crash course study review questions and solutions If I want to add the title "Company Financials" in cell A1 ensure that all columns are the same width across all the worksheets in my workbook, how would I do that? - CORRECT ANSWER-1. Group the worksheets by hitting Ctrl Shift and use the PageUp/Down keys to select the worksheets. 2. In the active sheet type in "Company Financials" in A1 and apply the desired width to all columns 3. Remember to hit Ctrl Pageup or Pagedown t...

Wall Street Prep Excel Crash Course Study Guide Exam All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: - CORRECT ANSWER-Alt i w What is a keyboard shortcut to open a file? - CORRECT ANSWER-ctrl o What is the recommended workbook calculation setting for Excel? - CORRECT ANSWER-Automatic except for data tables To add a cell reference from a different worksheet into an existing formula with your keyboard, you should follow the f...