Topgrades20

=ISNUMBER(value) - ANSWER-ISNUMBER Function =ISTEXT(value) - ANSWER-ISTEXT Function =YEARFRAC(start_date,End_date,Basis) - ANSWER-YEARFRAC Function =DATE(year, month, day) - ANSWER-DATE Function =DAY(Serial Number) - ANSWER-DAY Function

manipulating data inside a cell - ANSWER-*F2* is the command that puts you inside a cell: -pressing the F2 key once shows you the components of the formula you created earlier, puts you inside a cell and enables you to navigate through it to edit the existing cell data -pressing the F2 key twice activates the cursor and enables you to move to different cells, worksheets, and even other open Excel files *Shift arrow key* will highlight characters one at a time *Shift Ctrl arrow key* will ...

Esc - ANSWER-gets out of cell without changing anything Alt H E A - ANSWER-Deletes content and formatting Shift F2 - ANSWER-Insert a comment Alt H E M - ANSWER-Deletes a comment Ctrl R - ANSWER-right fill

Format cells - ANSWER-ctrl 1 Paste special - ANSWER-alt e-s Freeze panes - ANSWER-alt w-f-f Split panes - ANSWER-alt w-s Move between panes - ANSWER-F6 Get in cell AND navigate to others while inside - ANSWER-F2 Edit a cell from the outside - ANSWER-alt h-e Add comments - ANSWER-Shift F2 Right (and down) fill - ANSWER-Ctrl (d) r Insert/delete row - ANSWER-alt i-r/h-d-r Insert/delete column - ANSWER-alt i-c/h-d-c Date formatting - ANSWER-Ctrl shift #

What is the keyboard shortcut to freeze panes within a worksheet? - ANSWER-Alt W F F 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 - ANSWER-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 will need to hit F6 several times to get from one pane to the other)...

A company has the following information: • 2014 share repurchase plan of $4 billion • Average share price of $60 for the year 2013 • Expected EPS growth for 2014 of 10% What should the number of shares repurchased by the company be in your financial model? - ANSWER-60.6 million non-controlling interest - ANSWER-is an expense on the income statement and equity o the balance sheet A company has the following information: • 2013 retained earnings balance of $12 billion • Net i...

What was the weighted average interest rate Colgate faced on its short-term borrowings in 2013? Enter with 1 decimal place and with % sign (Ex: 9.9%) - ANSWER-2.2% Based on the company's 2013 10-K, how much long term debt is maturing between 2014 and 2016? Please provide your answer in millions without comma separator or decimal (Ex: 2345). - ANSWER-1641 Colgate declared a common stock split during 2013. - ANSWER-True How many Colgate options were outstanding as of December 31, 2013? P...

All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: - ANSWER-Alt h i w What is a keyboard shortcut to open a file?` - ANSWER-Ctrl o What is the recommended workbook calculation setting for Excel? - 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 following steps: - ANSWER-1. Hit F2 to get into the existing formula; delete ...

Which pesticide is best suited for dispatching moles? - ANSWER-Poison bait. What herbicide CHARACTERISTIC is desired when you need to control creeping charlie WITHOUT damaging surrounding turf? - ANSWER-Narrow spectrum. What is the easy-to-use for a pesticide active ingredient? - ANSWER-Common name. What is necessary for herbicides to kill a plant? - ANSWER-Getting absorbed into the plant. What type of herbicide is absorbed and trans-located throughout the plant? - ANSWER-Systemic. ...

c. Post a warning sign at the location - ANSWER-Secure the pesticides against unauthorized access What is often the most hazardous activity associated with normal pesticides? (76) a. Applying pesticides to the treatment site b. Cleaning application equipment c. Mixing and loading pesticides - ANSWER-Mixing and loading pesticides When must a facility have an impervious mixing and loading pad? (78) a. Loading restricted-use pesticides b. Located less than 100 feet from a well c. Loadin...