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:
$99.3625
Explanation:
The computation of ex-dividend stock price is shown below:-
Ex-dividend stock price = Stock closing price - Stock dividend × (1 - tax rate)
= $105.64 - $7.75 × (1 - 19%)
= $105.64 - $7.75 × 0.81
= $105.64 - 6.2775
= $99.3625
Therefore for computing the ex-dividend stock price we simply applied the above formula.
Answer:
pic quality is too low so I didn't understand
C. None of the individuals who end up working are paid more than if the were paid the equilibrium wage.