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:
The balance in Eve's prepaid insurance account as of December 2021 is $18000 as shown below.
Explanation:
The balance of prepaid insurance would be the balance left after 12 months expense has taken from both amounts
Liability policy $36000*6/18=$12000
Crop damage policy $12000*12/24=$6000
Balance of prepaid insurance $18,000
The balance of $18000 would be left in the prepaid insurance account,whereas the balance damage crop policy account would be enough for the coming year, there is a need for 6 months insurance policy payment in respect of liability policy in the year 2022
These are examples of D. documentation
Hope this helps!