FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Putting data or cell contents in a location with option to just insert the values only, formatting, or perform operations on data.
A
Fill
B
Flash Fill
C
Paste Special
D
Replace Data
Explanation: 

Detailed explanation-1: -Right-click the cell you want to copy (here, B2), and choose Copy (or use the keyboard shortcut CTRL + C). 2. Right-click the cell where you want to paste (B4), choose Paste special and Paste all except borders.

Detailed explanation-2: -Transpose Data Click the cell where you want to paste the data. Click the Paste list arrow. To preview a paste option before you commit to it, click the Paste list arrow and hold the mouse over the paste option. Select Transpose.

Detailed explanation-3: -When you copy text that has different formatting into an Office program, the program, such as PowerPoint or Word, automatically reformats that text to match the text of the destination. However, you can use Paste Special to maintain the original formatting or paste it as a link or a picture, for example.

There is 1 question to complete.
Previous
Next