<span>
Most workers recieve on the job training to learn what they need to know.</span>
Answer:
$187,750
Explanation:
Computation for operating income for the West Division.
OPERATING INCOME FOR THE WEST DIVISION
Sales $450,000
Less Cost of goods sold ($155,000)
Gross profit $295,000
($450,000-155,000)
Less: Salary Expense ($51,000)
Allocated rent ($56,250)
($90,000 * 11250/18,000)
West Division income $187,750
Total area of both division = 11,250 + 6,750 = 18,000 square feet
Therefore operating income for the West Division is $187,750
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.
