On the Public Works worksheet, in cell G5, insert a formula that will calculate what percentage of the total cost (in F10) was used by the Administration department (in F5). Ensure that the reference to the total cost is an absolute cell reference, and then copy the formula into the range G6:G9.
What is this formula?
and number 2 :
On the Public Works worksheet, in cell C32, insert a formula that will calculate the projected operations cost after the forecasted increase in cell B30 is added to the 2016 total (in B32). Ensure that the reference to cell B30 is an absolute cell reference, and then copy the formula into the range D32:F32.
Do your own homework.
Seriously, these are not hard questions.
Question one is simply dividing one into the other and formatting the cell properly.
I cannot give you help with question 2 as you did not provide enough details as to what is currently entered in the cells that the question references.
Now stop looking for easy answers online and study so that you can provide the answers on here one day.
EDIT: You additional information makes no sense. In neither of the 2 questions posted is B14 or B11 ever mentioned. In addition, that formula also makes no sense.
Please provide details as to what the contents are of the following cells:
F10, F5, B30, and B32.