FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.
A
ENTER
B
ALT
C
CTRL
D
SHIFT
Explanation: 

Detailed explanation-1: -Press Ctrl + C to copy the formula. Select a cell or a range of cells where you want to paste the formula (to select non-adjacent ranges, press and hold the Ctrl key). Press Ctrl + V to paste the formula. Press Enter to complete the pasted formulas.

Detailed explanation-2: -You can also select the first cell or range of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection.

Detailed explanation-3: -The cut command removes the selected data from its original position, while the copy command creates a duplicate; in both cases the selected data is kept in temporary storage (the clipboard). The data from the clipboard is later inserted wherever a paste command is issued.

Detailed explanation-4: -The cell being copied is called the source area (or copy area).

There is 1 question to complete.
Previous
Next