Wall Street Prep Exam Bundle

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

Add/delete worksheets - alt i w Move back and forth to different worksheets - ctrl page up and down Open a new file - alt f n, ctrl n open a file - alt f o, ctrl o save a file - alt f s, ctrl s, alt f a(save as) print a file - alt f p, ctrl p Navigating to the too...

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

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

What is the latest actual share count reported in the 2013 Colgate-Palmolive 10-K? Please provide your answer without comma separator or decimal (Ex: ) - According to its 2013 10-K, how many more shares can Colgate repurchase in the future under it share repurchase program? - 25,937,562 ...

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

Do companies prefer straight-line or accelerated depreciation? 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 ...

Assets - resources a company uses to operate its business includes cash, A/R, PP&E Liabilities - represents the company's contractual obligations and includes A/P, debt, accrued expenses Shareholder's equity - is the residual the value of the business available to the owners ...

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

Accounting Entity - A corporation is considered a "living" enterprise i.e. a "fictional" being. Going concern - A corporation is assumed to remain in existence for the foreseeable future. Measurement & Units of Measure - Financial Statements show only measurable activities of a co...