DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Right-click the mouse button.
|
|
|
Hold down the left mouse button on the fill handle and drag to the right.
|
|
|
Drag the fill handle and move to the right.
|
|
|
Right-click the mouse button.
|
Detailed explanation-1: -Select the cell with the formula, and hover the mouse cursor over a small square at the lower right-hand corner of the cell, which is called the Fill handle. As you do this, the cursor will change to a thick black cross. Hold and drag the fill handle down the column over the cells where you want to copy the formula.
Detailed explanation-2: -Select the cell that contains the formula you want to move. Click Home > Cut (or press Ctrl + X). Select the cell you want the formula to be in, and then click Paste (or press Ctrl + V). Verify that the cell references are still what you want.
Detailed explanation-3: -If you’re copying cell content to adjacent cells in the same row or column, the fill handle is a good alternative to the copy and paste commands. Select the cell(s) containing the content you want to use, then hover the mouse over the lower-right corner of the cell so the fill handle appears.
Detailed explanation-4: -These are called “relative” cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a “$” before the column letter if you want that to always stay the same.