DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Using the Paste Values option allows you to change a workbook in what way?
|
|
Remove excess worksheets.
|
|
|
Insert hyperlinks to external files.
|
|
|
Replace functions with the actual data.
|
|
|
Change the case of text.
|
Explanation:
Detailed explanation-1: -To Paste Values only – Alt+E+S+V + Enter. To Paste Formatting only – Alt+E+S+T + Enter. To Paste Comments only – Alt+E+S+C + Enter. To set column width the same as that of the copied cells – Alt+E+S+W + Enter.
Detailed explanation-2: -Pastes only the values of the copied data as displayed in the cells. Pastes only cell formatting of the copied data. Pastes only comments and notes attached to the copied cell.
There is 1 question to complete.