Question: Run Excel. Open the workbook Extend 3-1 Fill and IF. If necessary, make Fill the active sheet. 1. Use the fill handle on one column

Run Excel. Open the workbook Extend 3-1 Fill and IF. If necessary, make Fill the active sheet. 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 AutoFill.) 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 select something other than the cell in row 2 prior to using the fill handle, enter the selection and then the drag action, A2:A3 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 ctrl key, drag the pointer to cell K22 to copy the contents of cell H22 to cell K2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!