Topgrades20

#2 fuel oil - ANSWER-most frequently used and burns at 140,000 BTU per gallon air bend - ANSWER-regulates the volume (amount) by changing it to a spray of tiny droplets atomizing - ANSWER-vaporizing liquid oil (turning it into gas) by changing it to a spray of tiny droplets bleeder - ANSWER-on the side of the oil pump - used to remove air from oil line cad cell - ANSWER-detects if a flame is present combustion head - ANSWER-plate at the end of the burners air tube - specifically d...

Wall Street Prep Exam Bundle Questions &Answers 100% SOLVED

Explanation: Start by inputting the start_date into the first argument. Then input how many months ahead or behind you would like to go from that start_date. EDATE Function - ANSWER-Definition: Similar to EOMONTH but this return the exact date from the start-date, after the specified number of months. Explanation: Start by inputting the start_date into the first argument. Then input how many months ahead or behind you would like to go from that start_date. ISNUMBER Function - ANSWER-Defin...

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