Use the fill handle and, where necessary, a key, on one column as a time to propagate the 12 series through row 14, as shown in Figure 3-82. In cells O2;O13, 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 use a key in combination with the Drag, you would enter the key+drag, Ctrl+Drag for example. 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, A1 A3 Drag for example 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. 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. 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 CTRL key, drag the pointer to cell K22 to copy the contents of cell H22 to cell K22. Select cell K20. Drag the fill handle in to the center of cell K20 so that the cell is shaded and the cell contents are deleted. Select cell range H2:114, and insert a 3-D column chart on a new sheet. Change the chart title to Yearly Breakdown. Use the fill handle and, where necessary, a key, on one column as a time to propagate the 12 series through row 14, as shown in Figure 3-82. In cells O2;O13, 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 use a key in combination with the Drag, you would enter the key+drag, Ctrl+Drag for example. 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, A1 A3 Drag for example 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. 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. 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 CTRL key, drag the pointer to cell K22 to copy the contents of cell H22 to cell K22. Select cell K20. Drag the fill handle in to the center of cell K20 so that the cell is shaded and the cell contents are deleted. Select cell range H2:114, and insert a 3-D column chart on a new sheet. Change the chart title to Yearly Breakdown