FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO INSERT HEADERS FOOTERS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
When you move or copy a cell, the data in the original location is cleared and the format of the cell is reset to the default.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -When you copy a cell, the selected cell data remains in its original location and is added in a temporary storage area called the Clipboard. Select the cell or cell range you want to copy. Click the Copy button on the Home tab. Press Ctrl + C.

Detailed explanation-2: -By default, all worksheet cells are formatted with the General number format. With the General format, anything you type into the cell is usually left as-is. For example, if you type 36526 into a cell and then press ENTER, the cell contents are displayed as 36526.

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.

There is 1 question to complete.
Previous
Next