By the worksheet name, Cell References, to the sheet with Erregested by your intor, add a dash followed by to the revised workbook as specified by your instructor RHow would you rewrite the formula in cell H5 using relative and will Sore the workbook using the file name, Apply 3.1 Absolute Reference ons to come up with the same result as showing in Figure 3-83, and to produce the sides currently showing in cells G6 and G7 in cells H6 and 117 when the form Extend the skills you learned in this module and experiment with new skills. You may Nite to complete this assignment, you will be required to use the Data Files. Please contact your www. with nominal 117 in Figure Theme calor to the sheet tab. chose cells? Extend Your Knowledge need to use Help to complete the assignment. The Fill Handle and Nested IF Functions structor for information about accessing the required files, Perform the filling tasker the active sheet ration Part : Run Excel Open the workbook Extend 3-1 Fil and IF. If necessary, make Fiu 1. Use the fill handle on one column at a time to propagate the 12 series through row 14, as shown in Figure 3 - 84. (Hint: Search in Help to learn more about the fill handle and Auto Fil.) In cells 02:013, indicate the actions used with the fill handle to propagate the series. For instance, in cell O2, enter Drag. For instances where you need to select something other than the cell in row 2 prior to using the fill handle, enter the selection and then the drag action, 12:23 Drag for example. 2. Select cell D20. While holding down the CTRL key, one at a time drag the fill handle three cells to the right, to the left, up, and down to generate four series of numbers beginning with zero and incremented by one. 3. Select cell H20. Point to the cell border so that the pointer changes to a plus sign with four arrows. Drag the pointer down to cell H22 to move the contents of cell H20 to cell H22. 4. If necessary, select cell H22. Point to the cell border so that the pointer changes to a plus sign with four arrows. While holding down the CTRI. key, drag the pointer to cell K22 to copy the contents of cell H22 to cell K22. ng 28. FB By the worksheet name, Cell References, to the sheet with Erregested by your intor, add a dash followed by to the revised workbook as specified by your instructor RHow would you rewrite the formula in cell H5 using relative and will Sore the workbook using the file name, Apply 3.1 Absolute Reference ons to come up with the same result as showing in Figure 3-83, and to produce the sides currently showing in cells G6 and G7 in cells H6 and 117 when the form Extend the skills you learned in this module and experiment with new skills. You may Nite to complete this assignment, you will be required to use the Data Files. Please contact your www. with nominal 117 in Figure Theme calor to the sheet tab. chose cells? Extend Your Knowledge need to use Help to complete the assignment. The Fill Handle and Nested IF Functions structor for information about accessing the required files, Perform the filling tasker the active sheet ration Part : Run Excel Open the workbook Extend 3-1 Fil and IF. If necessary, make Fiu 1. Use the fill handle on one column at a time to propagate the 12 series through row 14, as shown in Figure 3 - 84. (Hint: Search in Help to learn more about the fill handle and Auto Fil.) In cells 02:013, indicate the actions used with the fill handle to propagate the series. For instance, in cell O2, enter Drag. For instances where you need to select something other than the cell in row 2 prior to using the fill handle, enter the selection and then the drag action, 12:23 Drag for example. 2. Select cell D20. While holding down the CTRL key, one at a time drag the fill handle three cells to the right, to the left, up, and down to generate four series of numbers beginning with zero and incremented by one. 3. Select cell H20. Point to the cell border so that the pointer changes to a plus sign with four arrows. Drag the pointer down to cell H22 to move the contents of cell H20 to cell H22. 4. If necessary, select cell H22. Point to the cell border so that the pointer changes to a plus sign with four arrows. While holding down the CTRI. key, drag the pointer to cell K22 to copy the contents of cell H22 to cell K22. ng 28. FB