FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

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: -By default when you copy (or cut) and paste in Excel, everything in the source cell or range-data, formatting, formulas, validation, comments-is pasted to the destination cell(s). This is what happens when you press CTRL+V to paste.

Detailed explanation-4: -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-5: -Click the cell that contains the data that you want to edit, and then press F2.

There is 1 question to complete.
Previous
Next