Wall Street Prep: Analyzing Financial Reports:Excel Crash Course Exam from Wall Street Prep - Wall Street Prep Questions:Wall Street Prep Premium Exam:Financial Modeling Exam Wallstreet Prep:

All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: (Ans- Alt h i w What is a keyboard shortcut to open a file?` (Ans- Ctrl o What is the recommended workbook calculation setting for Excel? (Ans- Automatic Except for Data Tables ...

What is generally not considered to be a pre-tax non-recurring (unusual or infrequent) item? (Ans- Extraordinary gains/losses what is false about depreciation and amortization (Ans- D&A may be classified within interest expense Company X's current assets increased by $40 million from whi...

Like many computer programmers, people who build

In 2017, $2 million in wages were earned and no cash wages were paid. In 2018, $8 million in wages were earned and $7 million in cash wages were paid. Cash wages were used to first pay wages earned in 2017 with the remainder used to pay wages earned in 2018. Any earned but unpaid wages will be ...

Liquidity Ratios (Ans- measures of a firm's short-term ability to meet its current obligations Profitability Ratios (Ans- measures of a firm's profitability relative to its assets (operating efficiency) and to its revenue (operating profitability) Activity Ratios (Ans- Measure of effic...

True or false: 10-Q's must be filed four times a year for publicly traded companies. (Ans- False; only 3x a year True or False: Both the 10-K and 10-Q filings are audited. (Ans- False; only 10-K filings are audited True or false: All publicly traded companies and private companies with re...

You've never worked in finance before. How much do you know about what bankers actually do? (Ans- I've done a lot of research on my own. Based on that, I know that bankers advise companies on transactions - buying and selling other companies, and raising capital. They are "agents" that connec...

Keyboard Versus the Mouse (Ans- 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 (Ans- Tells you what cell you are in (top left below th...

Which of the following keys IS NOT a way to trace precedent cells? (Ans- 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 (Ans- 1. With the active cell on any row bu...

Questions 1-4 will refer to AEO’s latest 10K, which you can download by clicking here. Ignoring the impact of stock based compensation expense included in cost of sales, what is gross profit for the year ending 1/30/2016? $1,267,757 $1,323,734 $1,326,181 $1,337,711 $1,372,581 Question 2...