FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WORKBOOK THEMES

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

When using formulas, what function will copy the formula across the adjacent cells?

A	Formula
B	Cell reference
C	Active cell
D	Fill handle

Explanation:

Detailed explanation-1: -You can use the Fill command to fill a formula into an adjacent range of cells. Simply do the following: Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left.

Detailed explanation-2: -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-3: -Unlike copying a formula, when you move a formula to another location in the same or another worksheet, the cell references in the formula don’t change, regardless of what type of cell reference you used.

Detailed explanation-4: -Select the cell and press Ctrl + C (PC) or ⌘ Command + C (Mac). This copies the formula to your clipboard. Select the cells you want to copy the formula to. Click on one and drag up or down using your mouse or the arrow keys.

There is 1 question to complete.