Wall Street Prep
Las últimas cargas en Wall Street Prep. ¿Buscando notas en Wall Street Prep? Tenemos muchas notas, guias de estudio y notas de estudio disponsible para tu escuela.
-
692
- 0
-
99
All courses for Wall Street Prep
-
Wall Street Prep 692
-
Wall Street Prep: 3
Últimos notas y resúmenes 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.	...
- Package deal
- Examen
- • 17 páginas's •
-
Wall Street Prep•Wall Street Prep
-
WALL STREET PREP PREMIUM EXAM QUESTIONS WITH VERIFIED CORRECT ANSWERS AND SOLUTIONS• Por INVINCIBLE
Vista previa 3 fuera de 17 páginas
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...
- Package deal
- Examen
- • 11 páginas's •
-
WALL STREET PREP•WALL STREET PREP
-
WALL STREET PREP PREMIUM EXAM QUESTIONS WITH VERIFIED CORRECT ANSWERS AND SOLUTIONS• Por INVINCIBLE
Vista previa 2 fuera de 11 páginas
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...
- Package deal
- Examen
- • 5 páginas's •
-
WALL STREET PREP•WALL STREET PREP
-
WALL STREET PREP PREMIUM EXAM QUESTIONS WITH VERIFIED CORRECT ANSWERS AND SOLUTIONS• Por INVINCIBLE
Vista previa 2 fuera de 5 páginas
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...
- Package deal
- Examen
- • 4 páginas's •
-
WALL STREET PREP•WALL STREET PREP
-
WALL STREET PREP PREMIUM EXAM QUESTIONS WITH VERIFIED CORRECT ANSWERS AND SOLUTIONS• Por INVINCIBLE
Vista previa 1 fuera de 4 páginas
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...
- Package deal
- Examen
- • 8 páginas's •
-
WALL STREET PREP•WALL STREET PREP
-
WALL STREET PREP PREMIUM EXAM QUESTIONS WITH VERIFIED CORRECT ANSWERS AND SOLUTIONS• Por INVINCIBLE
Vista previa 2 fuera de 8 páginas
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...
- Package deal
- Examen
- • 12 páginas's •
-
WALL STREET PREP•WALL STREET PREP
-
WALL STREET PREP PREMIUM EXAM QUESTIONS WITH VERIFIED CORRECT ANSWERS AND SOLUTIONS• Por INVINCIBLE
Vista previa 2 fuera de 12 páginas
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 ...
- Package deal
- Examen
- • 8 páginas's •
-
WALL STREET PREP•WALL STREET PREP
-
WALL STREET PREP PREMIUM EXAM QUESTIONS WITH VERIFIED CORRECT ANSWERS AND SOLUTIONS• Por INVINCIBLE
Vista previa 2 fuera de 8 páginas
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...
- Package deal
- Examen
- • 5 páginas's •
-
WALL STREET PREP•WALL STREET PREP
-
WALL STREET PREP PREMIUM EXAM QUESTIONS WITH VERIFIED CORRECT ANSWERS AND SOLUTIONS• Por INVINCIBLE
Vista previa 2 fuera de 5 páginas
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...
- Package deal
- Examen
- • 4 páginas's •
-
WALL STREET PREP•WALL STREET PREP
-
WALL STREET PREP PREMIUM EXAM QUESTIONS WITH VERIFIED CORRECT ANSWERS AND SOLUTIONS• Por INVINCIBLE
Vista previa 1 fuera de 4 páginas
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...
- Package deal
- Examen
- • 36 páginas's •
-
WALL STREET PREP•WALL STREET PREP
-
WALL STREET PREP PREMIUM EXAM QUESTIONS WITH VERIFIED CORRECT ANSWERS AND SOLUTIONS• Por INVINCIBLE
Vista previa 4 fuera de 36 páginas
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...