Wall Street Prep Exam Bundle GRADED A+!!

All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: Alt i w Alt h i s Shift F11 Alt Shift F1 Alt h i w Incorrect - ANSWER-Alt i w, Alt h i s, Shift F11 and Alt Shift F1 are all keyboard shortcuts for adding more sheets to a workbook. A...

Add/delete sheets - ANSWER-alt-i-w OR alt h-i-s Moving around task ribbon - ANSWER-Tab and shift (to select) Auto fit cell - ANSWER-alt-h-o-i Custom fit columns - ANSWER-alt h-o-w Custom fit rows - ANSWER-alt h-o-h Select entire column/row - ANSWER-ctrl shift-arrow key Format cells...

Average Function - ANSWER-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 - ANSWER-Definition: A function that returns one value when a condition you specify evaluates to true and a different value ...

=AVERAGE(number1,[number2],...) - ANSWER-Average Function =IF(logical test, [value if true], [value if false]) - ANSWER-Simple IF Function =IFS(logical test n, value if true n, value if false n) - ANSWER-IFS Function =IFERROR(value, value_if_error) - ANSWER-IFERROR Function =EOMONTH(star...

move back and forth between the worksheets in a workbook - ANSWER-*Ctrl PageUp* or *Ctrl PageDown* open a file - ANSWER-*alt f o* *ctrl o* save a file - ANSWER-*alt f s* *ctrl s* print a file - ANSWER-*alt f p* *ctrl p* navigating to the toolbars without the mouse - ANSWER-hit ...

Alt I W - ANSWER-Add new sheet Alt E L - ANSWER-Delete worksheet Alt V Z - ANSWER-Zoom size Alt H O I - ANSWER-Auto fit column width Ctrl 1 - ANSWER-Formatting window Ctrl space - ANSWER-highlight row Alt H O R - ANSWER-Rename Worksheet Shift space - ANSWER-highlight row Alt ...

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? - ANSWER-1. Group the worksheets by hitting Ctrl Shift and use the PageUp/Down keys to select the worksheets. 2. In the active sheet ...

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

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: ) - ANSWER- According to its 2013 10-K, how many more shares can Colgate repurchase in the future under it share repurchase program? - ANSWER-25,93...