USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To remove unwanted pieces of data from view in a table.
|
|
Markup
|
|
|
Workbook
|
|
|
Autofill
|
|
|
Filter
|
Explanation:
Detailed explanation-1: -Once the data is filtered, you can delete only the filtered rows by selecting the filtered data and pressing the “Ctrl” and “-” keys on your keyboard at the same time. This will open the “Delete” dialog box. Make sure that the “Shift cells up” option is selected and then click the “OK” button.
Detailed explanation-2: -Remove all the filters in a worksheet If you want to completely remove filters, go to the Data tab and click the Filter button, or use the keyboard shortcut Alt+D+F+F.
There is 1 question to complete.