DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The paste option Keep Source Column Widths will paste this
|
|
the cell formatting
|
|
|
only the column width formatting
|
|
|
all content and cell formatting including the column width format
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -You can keep the original formatting, merge with the destination formatting, or paste just plain text. Keep Source Formatting (K) This option retains formatting that was applied to the copied text.
Detailed explanation-2: -Click the first cell in the area where you want to paste what you copied. On the Home tab, under Edit, click Paste, and then click Paste Special. Paste all cell contents and formatting, including linked data. Paste only the formulas as entered in the formula bar.
Detailed explanation-3: -In Excel, click the lower half of the Paste button on the home tab of the ribbon, and select the first option: Keep Source Formatting.
There is 1 question to complete.