Answer:
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
Explanation:
In MS Excel, on the left hand side below the tool bar there is a small box which tells the cell name where the cursor is clicked, the name of the cell can be changed from here easily, click on the desired cell and then by clicking on the box you can enter the name of the cell. After a cell is renamed the formula can be written by simply putting the name of the cell instead of the original e.g. E13
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
The cells provided in the formula above is just an example and more than two cells can be selected.
Answer: $3,026.55
Explanation:
If US$1 is to £0.7269 then that means that the pound is stronger than the dollar because a dollar buys less than a pound in which case £2,200 will be more than $2,200.
It will be;
= 2,200/0.7269
= $3,026.55
<em>Options seem to be for a variant of this question. </em>
Answer:
planning
Explanation:
In this scenario it seems that Amy is demonstrating the planning part of the managerial functions. This part focuses on creating the plans and processes needed in order to be able to meet all of the company goals and objectives. In this scenario, by stating the actions that she thinks would better the company, she is letting everyone know her plan, therefore she is demonstrating the planning function.
Answer:
$4.50
Explanation:
In order to make a profit from the futures contracts, it would be appropriate to take a long position in the June futures contract(buy) and take a short position in the December futures contract.
The investor would borrow $60 today which would necessitate paying back $60 plus a half-year in interest payment.
loan repayment=$60*(1+5%/2)=$ 61.50
In December, sell crude oil at $66 and repay the loan principal and interest
profit=$66-$61.50=$4.50