Answer:
Question is incomplete and it needs a proper XL sheet image and more details. I have assumed and answered this question.
1. Use the values in the range A7:A8 to extend the list of years to the range A9:A11
Ans : Use Ctrl + select A7: A8 and drag till A9: A11 : This will extend the list
2. Use AutoFill to fill the range A9:H11 with the formatting from the range A7:H8.
Ans : Apply format immediately to the cells A9: H11 below with the help of Auto Fill Handle. Using Auto fill button we can able to a cell format to the cell bellow of active cell by just double clicking on the auto fill button.
3. In cell B8, create a formula without using a function that multiplies the value in cell B7 by the value in cell B6 and then adds the value in B7. Update the cell reference to cell B6, from a relative reference to a mixed reference by making an absolute reference to row
Ans : =($B7*$B6)+$B7
4. Copy the formula from cell B8 to the range B9:B11 and then copy the formulas from the range B8:B11 to the range C8:H11.
Ans:
1. Select the cell B8 that contains which has formula to be copied
2. Click inside the formula bar to activate it and select the entire formula by using mouse and keyboard.
3. Copy the selected formula and press Esc to deactivate the formula bar.
4. Select the cell B9 : B11 in which you want the copy of the formula to appear.
5. Most range names refer to absolute cell references. This means that when you copy a formula that uses a range name, the copied formula will use the same range name as the original.
6. Paste the formula by using references.
7. Repeat the steps of 1 to 6 for B8:B11 for range C8:H11.
5. Switch to the Cost Estimates worksheet. In cell A9, create a formula using the AVERAGE function that calculates the average of the values in the range A5:A7, then copy your formula to cell D9.
Ans : =AVERAGE(A5:A7) and Copy it to D9 using answer given in 4.
Explanation:
