DATABASE FUNDAMENTALS
BASICS OF BIG DATA
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If you want to fill cells using the fill handle, but do not want the series to increment, hold down the ____ key while dragging the fill handle.
|
alt
|
|
crtl
|
|
F1
|
|
shift
|
Explanation:
Detailed explanation-1: -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. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.
Detailed explanation-2: -The number won’t increase automatically if we hold down the Ctrl key while dragging the AutoFill handle in Excel. In our case, please select the Cell A2; hold down the Ctrl key which will change the cursor to a double-cross; and then drag the AutoFill handle down to the cells as you need.
There is 1 question to complete.